C_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 C_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 C_MaintenancePlanTP AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  LastChangeDate,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  MaintenanceStrategy,
  _MaintenanceStrategy._MaintenanceStrategyText[1:Language = $session.system_language].MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
  MaintenancePlanCycleSet,
  cast( SchedulingDuration as fti_mnomzins preserving type ) AS SchedulingDuration,
  SchedulingDurationUnit,
  NumberOfMaintenanceItems,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  MaintenanceCallHorizonCalcType,
  CallHorizonUnit,
  AuthorizationGroup,
  MaintenancePlanInternalID,
  MaintenanceCall,
  MaintenancePlanCategory,
  MaintPlanFreeDefinedAttrib,
  BasicStartDate,
  SchedulingStartDate,
  SchedulingStartTime,
  MaintPlanSchedgStartDateTime,
  MaintPlnStrtBufDurationInDays,
  FactoryCalendar,
  LateCompletionShiftInPercent,
  LateCompletionTolerancePercent,
  EarlyCompletionShiftInPercent,
  EarlyCompletionTolerancePct,
  PrdcssrCallObjCompltnIsRqd,
  MaintPlanLogicalOperatorCode,
  _LogicalOperatorText.MaintPlanLogicalOperatorText AS MaintPlanLogicalOperatorText,
  SchedulingEndDate,
  LastChangeDateTime,
  MaintenancePlanCallObject,
  MaintenancePlanType,
  IsAttachmentsEnabled,
  SystemStatus,
  MaintPlanEndCntrReadingValue,
  _SingleCycle.MeasuringPoint AS MeasuringPoint,
  virtual CharcValueUnit : msehi AS virtualCharcValueUnitmsehi,
  virtual MaintPlnRmngCounterValue : duration AS virtualMaintPlnRmngCounterValueduration,
  virtual MaintPlanIsNotMultiCounter : boolean AS virtualMaintPlanIsNotMultiCounterboolean,
  virtual MaintPlanIsNotSingleCycle : boolean AS virtualMaintPlanIsNotSingleCycleboolean,
  virtual UICT_PlanIsNotNonMCPForPM : boole_d AS virtualUICT_PlanIsNotNonMCPForPMboole_d,
  virtual UICT_PlanIsNotNonMCPForSO : boole_d AS virtualUICT_PlanIsNotNonMCPForSOboole_d,
  virtual UICT_PlanIsNotNonMCPForNO : boole_d AS virtualUICT_PlanIsNotNonMCPForNOboole_d,
  virtual UICT_HideCallHorizIsInDays : boole_d AS virtualUICT_HideCallHorizIsInDaysboole_d,
  virtual UICT_HideCallHorizUnit : boole_d AS virtualUICT_HideCallHorizUnitboole_d
FROM R_MaintenancePlanTP
LEFT OUTER JOIN C_MaintenancePlanScheduleTP AS _Schedule ON MaintenancePlan = _Schedule.MaintenancePlan  -- association [1..*]
LEFT OUTER JOIN C_MaintPlanChgHistory AS _MaintPlanChgHistory ON MaintenancePlan = _MaintPlanChgHistory.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_MaintPlanStrategyCycle AS _StrategyCycle ON MaintenancePlan = _StrategyCycle.MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN C_MaintPlanClfnClassTP AS _MaintPlanClfnClass ON _MaintPlanClfnClass.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN C_MaintenancePlanCategoryVH AS _CategoryVH ON MaintenancePlanCategory = _CategoryVH.MaintenancePlanCategory AND _CategoryVH.MaintenancePlanCallObject is initial OR _CategoryVH.MaintenancePlanCallObject = '2'  -- association [0..1]
;