R_MaintPlngBcktExecObjectTP

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_MaintPlngBcktExecObjectTP.
-- 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_MaintPlngBcktExecObjectTP AS
SELECT
  P_MaintPlngBcktExecObjectUnion.MaintExecutionObject AS MaintExecutionObject,
  P_MaintPlngBcktExecObjectUnion.MaintExecutionObjectType AS MaintExecutionObjectType,
  P_MaintPlngBcktExecObjectUnion._MaintExecutionObjectTypeText[ 1:Language = $session.system_language ].MaintExecutionObjectTypeDesc AS MaintExecutionObjectTypeDesc,
  P_MaintPlngBcktExecObjectUnion.DocumentText AS DocumentText,
  MaintPlngBcktExecObjectUnion.MaintPlanningBucketUUID AS MaintPlanningBucketUUID,
  P_MaintPlngBcktExecObjectUnion.MaintPriority AS MaintPriority,
  P_MaintPlngBcktExecObjectUnion._MaintenancePriority._Text[ 1:Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  P_MaintPlngBcktExecObjectUnion.MainWorkCenter AS MainWorkCenter,
  P_MaintPlngBcktExecObjectUnion.WorkCenterInternalID AS WorkCenterInternalID,
  P_MaintPlngBcktExecObjectUnion.NotificationType AS NotificationType,
  P_MaintPlngBcktExecObjectUnion.OrderType AS MaintenanceOrderType,
  P_MaintPlngBcktExecObjectUnion.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  P_MaintPlngBcktExecObjectUnion.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  P_MaintPlngBcktExecObjectUnion.MaintenanceRevision AS MaintenanceRevision,
  P_MaintPlngBcktExecObjectUnion.Equipment AS Equipment,
  P_MaintPlngBcktExecObjectUnion.FunctionalLocationName AS FunctionalLocationName,
  P_MaintPlngBcktExecObjectUnion.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  P_MaintPlngBcktExecObjectUnion.ABCIndicator AS ABCIndicator,
  P_MaintPlngBcktExecObjectUnion.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  P_MaintPlngBcktExecObjectUnion._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  P_MaintPlngBcktExecObjectUnion.OperationSystemCondition AS OperationSystemCondition,
  P_MaintPlngBcktExecObjectUnion.MaintenanceActivityType AS MaintenanceActivityType,
  P_MaintPlngBcktExecObjectUnion.MaintenanceItem AS MaintenanceItem,
  P_MaintPlngBcktExecObjectUnion._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  P_MaintPlngBcktExecObjectUnion.MaintExecObjRequiredStartDate AS MaintExecObjRequiredStartDate,
  P_MaintPlngBcktExecObjectUnion.MaintExecObjectRequiredEndDate AS MaintExecObjectRequiredEndDate,
  P_MaintPlngBcktExecObjectUnion.MaintExecObjRequiredStartTime AS MaintExecObjRequiredStartTime,
  P_MaintPlngBcktExecObjectUnion.MaintExecObjectRequiredEndTime AS MaintExecObjectRequiredEndTime,
  P_MaintPlngBcktExecObjectUnion.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  P_MaintPlngBcktExecObjectUnion.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  cast( 1 as abap.int4 ) AS NmbrOfMaintPlngBcktExecObjects,
  P_MaintPlngBcktExecObjectUnion.MaintObjectInternalID AS MaintObjectInternalID,
  P_MaintPlngBcktExecObjectUnion.TechnicalObjectType AS TechnicalObjectType,
  P_MaintPlngBcktExecObjectUnion.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  P_MaintPlngBcktExecObjectUnion.SoldToParty AS SoldToParty,
  cast( P_MaintPlngBcktExecObjectUnion.SoldToPartyName as businesspartnername ) AS SoldToPartyName
FROM P_MaintPlngBcktExecObjectUnion
INNER JOIN I_MaintenancePlanningBucket_2 AS MaintPlngBcktExecObjectUnion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PMNotificationPriority AS _MaintenancePriority ON MaintPriority = _MaintenancePriority.MaintPriority  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhaseText AS _EAMProcessPhaseText ON _EAMProcessPhaseText.EAMProcessPhaseCode = MaintOrdProcessPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhaseText AS _EAMProcessSubPhaseText ON _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = MaintOrdProcessSubPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_ABCIndicatorText AS _ABCIndicatorText ON ABCIndicator = _ABCIndicatorText.ABCIndicator  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON MaintenanceOrderType = _MaintenanceOrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_NotificationTypeName AS _NotificationTypeName ON NotificationType = _NotificationTypeName.NotificationType  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceActivityTypeText AS _MaintenanceActivityTypeText ON MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType  -- association [0..*]
LEFT OUTER JOIN I_MaintOperationSystConditionT AS _OperationSystemConditionText ON OperationSystemCondition = _OperationSystemConditionText.OperationSystemCondition  -- association [0..*]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderProcessingContext AS _MaintOrdProcessingContext ON MaintOrderProcessingContext = _MaintOrdProcessingContext.MaintOrderProcessingContext  -- association [1..1]
;