R_MaintenancePlanTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_MaintenancePlanTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_MaintenancePlanTP AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  cast(' ' as wset ) AS MaintenancePlanCycleSet,
  SchedulingDuration,
  SchedulingDurationUnit,
  NumberOfMaintenanceItems,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  MaintenanceCallHorizonCalcType,
  AuthorizationGroup,
  MaintenancePlanInternalID,
  MaintenanceCall,
  MaintenancePlanCategory,
  MaintPlanFreeDefinedAttrib,
  BasicStartDate,
  SchedulingStartDate,
  SchedulingStartTime,
  dats_tims_to_tstmp( SchedulingStartDate, SchedulingStartTime, abap_system_timezone($session.client,'NULL'), $session.client, 'NULL' ) as MaintPlanSchedgStartDateTime AS clientNULLasMaintPlanSchedgStartDateTime,
  ltrim(MaintPlanStartCntrReadingValue, ' ') AS MaintPlanStartCntrReadingValue,
  MaintPlnStrtBufDurationInDays,
  MaintPlanStartBufferUnit,
  FactoryCalendar,
  LateCompletionShiftInPercent,
  LateCompletionTolerancePercent,
  EarlyCompletionShiftInPercent,
  EarlyCompletionTolerancePct,
  PrdcssrCallObjCompltnIsRqd,
  cast( MaintPlanLogicalOperatorCode as eams_mplan_logop preserving type ) AS MaintPlanLogicalOperatorCode,
  SchedulingEndDate,
  ltrim(MaintPlanEndCntrReadingValue, ' ') AS MaintPlanEndCntrReadingValue,
  LastChangeDateTime,
  MultipleCounterPlanShiftFactor,
  MaintenanceLeadFloatInDays,
  MaintenancePlanCallObject,
  cast(' ' as cv_orig preserving type ) AS IsAttachmentsEnabled
FROM I_MaintenancePlanBasic
LEFT OUTER JOIN I_MaintenanceStrategyT AS _StrategyText ON MaintenanceStrategy = _StrategyText.MaintenanceStrategy AND _StrategyText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN R_MaintenanceItemTP AS _Item ON MaintenancePlan = _Item.MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintenancePlanSchedule AS _Schedules ON MaintenancePlan = _Schedules.MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintPlanCallHorizonCalcType AS _CallHrznCalcTypeTxt ON CallHorizonUnit = _CallHrznCalcTypeTxt.MaintenanceCallHorizonCalcType  -- association [1..1]
LEFT OUTER JOIN I_MaintenancePlanType AS _MaintenancePlanType ON MaintenancePlanType = _MaintenancePlanType.MaintenancePlanType  -- association [0..1]
LEFT OUTER JOIN R_MaintenancePlanCycleTP AS _SingleCycle ON MaintenancePlan = _SingleCycle.MaintenancePlan AND _SingleCycle.MaintenancePlanCycle = '01'  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanStatus AS _MaintPlanActiveSystemStatus ON MaintenancePlan = _MaintPlanActiveSystemStatus.MaintenancePlan  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanSchedgInd AS _SchedIndicator ON MaintPlanSchedgIndicator = _SchedIndicator.MaintPlanSchedgIndicator  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON SchedulingDurationUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_MaintPlanLgclOptrText AS _LogicalOperatorText ON MaintPlanLogicalOperatorCode = _LogicalOperatorText.LogicalOperator AND _LogicalOperatorText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MaintPlanLgclOptr AS _LogicalOperator ON _LogicalOperator.LogicalOperator = MaintPlanLogicalOperatorCode  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanCallDate AS _MaintenancePlanCallDate ON MaintenancePlan = _MaintenancePlanCallDate.MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _ActivePlan ON MaintenancePlanInternalID = _ActivePlan.StatusObject AND _ActivePlan.StatusCode = 'I0001' AND _ActivePlan.StatusIsInactive is initial  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _InactivePlan ON MaintenancePlanInternalID = _InactivePlan.StatusObject AND _InactivePlan.StatusCode = 'I0320' AND _InactivePlan.StatusIsInactive is initial  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _DeletedPlan ON MaintenancePlanInternalID = _DeletedPlan.StatusObject AND _DeletedPlan.StatusCode = 'I0076' AND _DeletedPlan.StatusIsInactive is initial  -- association [0..1]
LEFT OUTER JOIN E_MaintenancePlan AS _MaintenancePlanExtension ON MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN R_MaintenancePlanCycleTP AS _MaintenanceCycle ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintPlanToMaintItemTP AS _MaintenanceItemLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintenancePlanTextTP AS _LongText ON /* condition not available in parsed metadata */  -- association [0..*]
;