I_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 I_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.
-- SQL view name: IMAINTPLANTP

CREATE VIEW I_MaintenancePlanTP AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  SchedulingDuration,
  SchedulingDurationUnit,
  Equipment,
  FunctionalLocation,
  Customer,
  NumberOfMaintenanceItems,
  Language,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  cast( '' as fti_mnomzins) AS CallHorizonValue,
  MaintenanceCallHorizonCalcType,
  AuthorizationGroup,
  MaintenancePlanInternalID,
  MaintenanceCall,
  MaintenancePlanCategory,
  MaintPlanFreeDefinedAttrib,
  BasicStartDate,
  SchedulingStartDate,
  SchedulingStartTime,
  MaintSchedulingStartCounter,
  cast(MaintPlanStartBufferQuantity as fti_mnomzins) AS MaintPlanStartBufferQuantity,
  MaintPlanStartBufferUnit,
  FactoryCalendar,
  cast(LateCompletionShiftFactor as fti_mnomzins) AS LateCompletionShiftFactor,
  cast(LateCompletionTolerancePercent as fti_mnomzins) AS LateCompletionTolerancePercent,
  cast(EarlyCompletionShiftFactor as fti_mnomzins) AS EarlyCompletionShiftFactor,
  cast(EarlyCompletionTolerancePct as fti_mnomzins) AS EarlyCompletionTolerancePct,
  PrdcssrCallObjCompltnIsRqd,
  LogicalOperator,
  MaintPlanIsLockedAgainstCalls,
  SchedulingEndDate,
  MaintSchedulingEndCounter
FROM I_MaintenancePlan
LEFT OUTER JOIN I_MaintenanceSingleCycleTP AS _MaintenanceSingleCycleTP ON _MaintenanceSingleCycleTP.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanMaintCallTP AS _MaintenanceCallTP ON _MaintenanceCallTP.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN E_MaintenancePlan AS _MaintenancePlanExtension ON MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan  -- association [0..1]
;