P_MaintPlngBcktOrder

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 P_MaintPlngBcktOrder.
-- 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 P_MaintPlngBcktOrder AS
SELECT
  I_MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  MaintOrderRoutingNumber,
  MaintenanceOrderType,
  MaintenanceOrderDesc,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  Equipment,
  MaintOrdPersonResponsible,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  MaintenanceActivityType,
  _OrderItem.Material AS Material,
  Assembly,
  SerialNumber,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  OperationSystemCondition,
  MaintenanceOrderPlanningCode,
  WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  MainWorkCenter,
  MainWorkCenterPlant,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  0 AS MaintOrdCompAvailyCritltyCode,
  cast( case when MaintOrdProcessPhaseCode >= '06' then 3 end as abap.int1) AS MaintOrdStatusCriticalityCode,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintOrderProcessingContext,
  _ServiceDocumentItem.SoldToParty AS SoldToParty,
  _ServiceDocumentItem._SoldToParty.BusinessPartnerName AS SoldToPartyName,
  ServiceDocument,
  ServiceDocumentItem,
  LatestAcceptableCompletionDate,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  cast( 1 as abap.int4 ) AS NumberOfOrders,
  MaintPriority,
  MaintPriorityType,
  _MaintOrderHasOpenMainWork.MaintOrdHasOpenMainWork AS MaintOrdHasOpenMainWork,
  EAMOverallObjectStatusProfile,
  EAMOverallObjectStatus,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenanceOrderInternalID,
  LastChangeDateTime,
  cast ( case when LatestAcceptableCompletionDate is initial then '0' when ScheduledBasicEndDate < LatestAcceptableCompletionDate then '3' when LatestAcceptableCompletionDate > '01011900' and ScheduledBasicStartDate <= LatestAcceptableCompletionDate and LatestAcceptableCompletionDate <= ScheduledBasicEndDate then '2' when LatestAcceptableCompletionDate < ScheduledBasicStartDate then '1' end as abap.int1 ) as MaintOrdSchedCriticalityCode AS int1asMaintOrdSchedCriticalityCode,
  I_MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  I_MaintenanceOrder.MaintenanceRevision AS MaintenanceEvent,
  I_MaintenanceOrder._LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation,
  _LocationAccountAssignment._ABCIndicator AS _ABCIndicator
FROM I_MaintenanceOrder
LEFT OUTER JOIN I_FunclocationLabelInternal AS _FuncnlLocationLabel ON _FuncnlLocationLabel.FunctionalLocation = functionallocation  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_EquipmentStdVH AS _EquipmentBasic ON _EquipmentBasic.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationStdVH AS _FunctionalLocationBasic ON _FunctionalLocationBasic.FunctionalLocation = functionallocation  -- association [0..1]
LEFT OUTER JOIN I_GenericPriority AS _Priority ON _Priority.GenericPriorityType = MaintPriorityType AND _Priority.PriorityCode = MaintPriority  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderHasOpenMainWork AS _MaintOrderHasOpenMainWork ON _MaintOrderHasOpenMainWork.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _MaintOrderIsFinallyConfirmed ON _MaintOrderIsFinallyConfirmed.IndicatorValue = MaintOrderIsFinallyConfirmed  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanningBucket AS _MaintPlanningBucket ON _MaintPlanningBucket.MaintOrderForAdministration = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocumentItem ON _ServiceDocumentItem.ServiceObjectType = 'BUS2000116' AND _ServiceDocumentItem.ServiceDocument = ServiceDocument AND _ServiceDocumentItem.ServiceDocumentItem = ServiceDocumentItem  -- association [0..1]
;