C_MaintenancePlanObjPg

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 C_MaintenancePlanObjPg.
-- 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.
-- SQL view name: CMAINTPLANOBJPG

CREATE VIEW C_MaintenancePlanObjPg AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  MaintenancePlanInternalID,
  MaintenanceStrategy,
  cast( SchedulingDuration as fti_mnomzins) AS SchedulingDuration,
  SchedulingDurationUnit,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  MaintenanceCallHorizonCalcType,
  CallHorizonPercent,
  CallHorizonInDays,
  AuthorizationGroup,
  CallHorizonValue,
  cast ('' as msehi) AS CallHorizonUnit,
  MaintenancePlanCategory,
  BasicStartDate,
  MaintPlanFreeDefinedAttrib,
  SchedulingStartDate,
  MaintSchedulingStartCounter,
  cast( case when MaintSchedulingStartCounter <> '' then cast( MaintSchedulingStartCounter as abap.numc(22) ) when MaintSchedulingStartCounter = '' then '0000000000000000000000' end as abap.fltp ) as MaintSchedulingStartCounter_H AS fltpasMaintSchedulingStartCounter_H,
  _MaintenanceSingleCycleTP._MeasuringPoint._Characteristic( P_KeyDate:$session.system_date ).CharcValueUnit AS CharcValueUnit,
  FactoryCalendar,
  LateCompletionShiftFactor,
  LateCompletionTolerancePercent,
  EarlyCompletionShiftFactor,
  EarlyCompletionTolerancePct,
  cast('%' as msehi) AS CompletionShiftFactorUnit,
  cast('%' as msehi) AS CompletionToleranceUnit,
  PrdcssrCallObjCompltnIsRqd,
  MaintPlanStartBufferQuantity,
  MaintPlanStartBufferUnit,
  LogicalOperator,
  Customer,
  cast ('' as eams_ltext ) AS MaintenancePlanLongText,
  cast ('' as txt30 ) AS MaintenancePlanSystemStatus,
  cast (0 as int1 ) AS MaintPlanStatusCriticality,
  _MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject,
  SchedulingEndDate,
  cast( '' as abap.char(14) ) AS MaintPlnRmngScheduleDays,
  cast ( '' as abap.char(22) ) AS MaintPlnRmngCounterValue,
  case when MaintSchedulingEndCounter <> '' then cast( cast( MaintSchedulingEndCounter as abap.numc(22) ) as abap.fltp ) - cast( _MaintPlanLastMsmtDoc.MeasurementCounterReading as abap.fltp ) AS However,
  you will see 0 value for the empty fields in the data preview. On the other hand AS Ontheotherhand,
  the database stores the null value. Furthermore AS Furthermore,
  the filtering and the sorting logic will handle this value properly. AS Forexample,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  LastChangeDate,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription
FROM I_MaintenancePlanTP AS _MaintenancePlanTP
LEFT OUTER JOIN C_MaintPlanChgHistory AS _MaintPlanChgHistory ON MaintenancePlan = _MaintPlanChgHistory.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceItemObjPg AS _MaintenanceItem ON _MaintenanceItem.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN C_MaintPlnObjPgSingleCycle AS _MaintenanceSingleCycleTP ON _MaintenanceSingleCycleTP.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN C_MaintPlanObjPgCycle AS _Cycles ON _Cycles.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN C_MaintPlanObjPgMaintCall AS _ScheduledCalls ON _ScheduledCalls.MaintenancePlan = MaintenancePlan AND SchedulingType <> 'M'  -- association [0..*]
LEFT OUTER JOIN C_MaintPlanObjPgMaintCall AS _ManualCalls ON _ManualCalls.MaintenancePlan = MaintenancePlan AND SchedulingType = 'M'  -- association [0..*]
LEFT OUTER JOIN C_MaintPlanObjPgMaintCall AS _MaintenanceCallTP ON _MaintenanceCallTP.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintCallObjectType AS _MaintCallObjectType ON _MaintCallObjectType.MaintenanceCallObjectType = MaintenanceCallObjectType  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanType AS _MaintenancePlanType ON _MaintenancePlanType.MaintenancePlanType = MaintenancePlanType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaintPlanStartBufferUnit ON _MaintPlanStartBufferUnit.UnitOfMeasure = MaintPlanStartBufferUnit  -- association [0..1]
LEFT OUTER JOIN P_MaintPlanLastMsmtDoc AS _MaintPlanLastMsmtDoc ON _MaintPlanLastMsmtDoc.MaintenancePlan = MaintenancePlan  -- association [0..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]
;