P_MaintBacklogServiceUnion

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_MaintBacklogServiceUnion.
-- 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_MaintBacklogServiceUnion AS
SELECT
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[1: LanguageCode = $session.system_language ].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[1: LanguageCode = $session.system_language ].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintenanceOrderComponent._Material.MaterialType AS ProductType,
  case when _PurgRequisitionItem.PurchasingDocument != '' then _PurchaseOrder.Supplier when _PurgRequisitionItem.FixedSupplier != '' then _PurgRequisitionItem.FixedSupplier when _MaintenanceOrderComponent.Supplier != '' then _MaintenanceOrderComponent.Supplier else _MaintenanceOrderOperation.OperationSupplier end as Supplier AS OperationSupplierendasSupplier,
  cast (0 as pph_enmng ) AS ReceivedQuantity,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _MaintenanceOrderComponent._MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintenanceOrderComponent._MaintenanceOrder.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _MaintenanceOrderComponent._MaintenanceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _MaintenanceOrderComponent._MaintenanceOrder.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  _MaintenanceOrderComponent._MaintenanceOrder._LocationAccountAssignment.PlantSection AS PlantSection,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrderComponent._MaintenanceOrder.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceOrderComponent._MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  _MaintenanceOrderComponent._MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrderComponent._MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintenanceOrderComponent._MaintenanceOrder._Equipment AS _Equipment,
  _MaintenanceOrderComponent._MaintenanceOrder._LocationAccountAssignment AS _LocationAccountAssignment,
  _MaintenanceOrderComponent.MaintOrdOpComponentCurrency AS MaintenanceOrder,
  case when I_OrderOperation.SuperiorOperationInternalID <> '00000000' then I_OrderOperationBasic.Operation else I_OrderOperation.Operation end as MaintenanceOrderOperation AS OperationendasMaintenanceOrderOperation,
  cast ('' as aposn ) AS MaintenanceOrderComponent,
  '' AS Product,
  '' AS Material,
  '' AS ProductTypeCode,
  _PurchaseOrderItem._PurchasingDocument.Supplier AS PurchaseOrderSupplier,
  case when _PurchaseOrderItem.PurchasingDocument != '' then _PurchaseOrderItem._PurchasingDocument.Supplier when _PurgRequisitionItem.FixedSupplier != '' then _PurgRequisitionItem.FixedSupplier else I_OrderOperation.Supplier end as Supplier AS SupplierendasSupplier,
  cast( '' as rsnum ) AS Reservation,
  cast( '' as rspos ) AS ReservationItem,
  cast( '' as rsart ) AS ReservationType,
  cast ('' as postp ) AS MaintComponentItemCategory,
  cast ('' as bwart ) AS GoodsMovementType,
  cast (0 as pph_enmng ) AS WithdrawnQuantity,
  cast ('' as objnr ) AS MaintOrderComponentInternalID,
  cast( '00000000000000' as timestamp ) AS RequirementDateTime,
  '00000000' AS PerformancePeriodStartDate,
  '00000000' AS PerformancePeriodEndDate,
  '' AS SrvcSchedgIsAlignedWthOpWrkCtr,
  '' AS ServicePerformer,
  '' AS MaintenanceOrderOperation,
  ' ' AS MaintenanceOrderSubOperation,
  '' AS OperationDescription,
  '' AS MaintOperationExecStageCode,
  '' AS OperationSupplier,
  '00000000' AS RequirementDate,
  I_PurchasingDocumentItem._PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  I_PurchasingDocumentItem._PurchaseRequisitionItem.Supplier AS PreferredSupplier,
  _MaintenanceOrderComponent.MaintOrderComponentInternalID AS MaintOrdProcurementDocument,
  _MaintenanceOrderComponent.PurchaseRequisition AS PurchaseRequisition,
  _MaintenanceOrderComponent.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _MaintenanceOrderComponent.MaterialGroup AS ProductGroup,
  _MaintenanceOrderComponent.ComponentDescription AS ComponentDescription,
  _MaintenanceOrderComponent.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  _MaintenanceOrderComponent.BaseUnit AS BaseUnit,
  _MaintenanceOrderComponent.ReservationIsFinallyIssued AS IsCompletelyDelivered,
  _MaintenanceOrderComponent.OverallLimitAmount AS OverallLimitAmount,
  _MaintenanceOrderComponent.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_PurchasingDocumentItem.PurchasingDocument AS PurchaseOrder,
  I_PurchasingDocumentItem.PurchasingDocumentItem AS PurchaseOrderItem,
  I_PurchasingDocumentItem.DocumentCurrency AS MaintOrdOpComponentCurrency,
  _MaintOrdProcurementMilestone.MaintProcurementMilestone AS MaintProcurementMilestone,
  _MaintOrdProcurementMilestone.MaintOrdProcmtMilestoneDate AS MaintOrdProcmtMilestoneDate,
  _MaintOrdProcurementMilestone.MaintOrdProcmtMlstnWarningDate AS MaintOrdProcmtMlstnWarningDate,
  _MaintOrdProcurementMilestone.MaintOrdProcurementDocType AS MaintOrdProcurementDocType
FROM I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent
INNER JOIN I_OrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurReqnAcctAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintOrdProcurementMilestone AS _MaintOrdProcurementMilestone ON _MaintOrdProcurementMilestone.MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder AND _MaintOrdProcurementMilestone.MaintOrdProcurementDocument = _MaintenanceOrderComponent.MaintOrderComponentInternalID AND _MaintOrdProcurementMilestone.MaintOrdProcmtMlstnIsCurrent = 'X' AND _MaintOrdProcurementMilestone.MaintOrdProcurementDocType = 'OKP'  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseRequisition = _MaintenanceOrderComponent.PurchaseRequisition AND _PurchaseOrderItem.PurchaseRequisitionItem = _MaintenanceOrderComponent.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchaseOrder ON _PurchaseOrder.PurchasingDocument = _PurgRequisitionItem.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintOrderRoutingNumber = _MaintenanceOrderComponent.MaintOrderRoutingNumber AND _MaintenanceOrderOperation.MaintOrderOperationCounter = _MaintenanceOrderComponent.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PreferredSupplier ON _PreferredSupplier.Supplier = PreferredSupplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PurchaseOrderSupplier ON _PurchaseOrderSupplier.Supplier = PurchaseOrderSupplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _OperationSupplier ON _OperationSupplier.Supplier = operationsupplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _FixedSupplier ON _FixedSupplier.Supplier = FixedSupplier  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = functionallocation  -- association [0..1]
LEFT OUTER JOIN I_FunclocationLabelInternal AS _FuncnlLocationLabel ON _FuncnlLocationLabel.FunctionalLocation = functionallocation  -- association [0..*]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON _PurchaseRequisitionItem.PurchaseRequisition = I_OrderOperation.PurchaseRequisition AND _PurchaseRequisitionItem.PurchaseRequisitionItem = I_OrderOperation.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = I_OrderOperation.MaintOperationExecStageCode AND _MaintOpExecStageCodeText.LanguageCode = $session.system_language  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaintenanceOrder
;