P_MaintBacklogNonStkCompUnion

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_MaintBacklogNonStkCompUnion.
-- 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_MaintBacklogNonStkCompUnion AS
SELECT
  _MaintenanceOrderComponent.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrderComponent.MaintOrderComponentInternalID AS MaintOrdProcurementDocument,
  _MaintenanceOrderComponent.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _MaintenanceOrderComponent.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  cast ('RESERVATION' as abap.char( 11 ) ) AS ProcuredtFromCode,
  _MaintenanceOrderComponent.PurchaseRequisition AS PurchaseRequisition,
  _MaintenanceOrderComponent.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurgRequisitionItem.PurchasingDocument AS PurchaseOrder,
  _PurgRequisitionItem.PurchasingDocumentItem AS PurchaseOrderItem,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrderComponent.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  _MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[1: LanguageCode = $session.system_language ].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[1: LanguageCode = $session.system_language ].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintenanceOrderComponent.Material AS Product,
  _MaintenanceOrderComponent.Material AS Material,
  _MaintenanceOrderComponent._Material.MaterialType AS ProductType,
  _MaintenanceOrderComponent.MaterialGroup AS ProductGroup,
  _MaintenanceOrderComponent.ProductTypeCode AS ProductTypeCode,
  case when _MaintenanceOrderComponent.Material = '' then _MaintenanceOrderComponent.ComponentDescription else _MaintenanceOrderComponent._MaterialText[1:Language = $session.system_language ].MaterialName end as ComponentDescription AS MaterialNameendasComponentDescription,
  _MaintenanceOrderComponent.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  _MaintenanceOrderComponent.BaseUnit AS BaseUnit,
  _PurchaseOrder.Supplier AS PurchaseOrderSupplier,
  _PurgRequisitionItem.FixedSupplier AS FixedSupplier,
  _MaintenanceOrderComponent.Supplier AS PreferredSupplier,
  _MaintenanceOrderOperation.OperationSupplier AS OperationSupplier,
  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,
  _MaintenanceOrderComponent.Reservation AS Reservation,
  _MaintenanceOrderComponent.ReservationItem AS ReservationItem,
  _MaintenanceOrderComponent.ReservationType AS ReservationType,
  _MaintenanceOrderComponent.MaintComponentItemCategory AS MaintComponentItemCategory,
  _MaintenanceOrderComponent.GoodsMovementType AS GoodsMovementType,
  _MaintenanceOrderComponent.WithdrawnQuantity AS WithdrawnQuantity,
  cast (0 as pph_enmng ) AS ReceivedQuantity,
  _MaintenanceOrderComponent.MaintOrderComponentInternalID AS MaintOrderComponentInternalID,
  _MaintenanceOrderComponent.RequirementDate AS RequirementDate,
  _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.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintOrdBasicStartTime AS MaintOrdBasicStartTime,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _MaintenanceOrderComponent._MaintenanceOrder.MaintOrdBasicEndTime AS MaintOrdBasicEndTime,
  _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,
  _MaintOrdProcurementMilestone.MaintProcurementMilestone AS MaintProcurementMilestone,
  _MaintOrdProcurementMilestone.MaintOrdProcmtMilestoneDate AS MaintOrdProcmtMilestoneDate,
  _MaintOrdProcurementMilestone.MaintOrdProcmtMlstnWarningDate AS MaintOrdProcmtMlstnWarningDate,
  _MaintOrdProcurementMilestone.MaintOrdProcurementDocType AS MaintOrdProcurementDocType,
  _MaintenanceOrderComponent.ReservationIsFinallyIssued AS IsCompletelyDelivered,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS ComponentDescription,
  case when _PurchaseRequisitionItem.PurchasingDocument != '' then _PurchaseOrder.Supplier when _PurchaseRequisitionItem.FixedSupplier != '' then _PurchaseRequisitionItem.FixedSupplier else _PurchaseRequisitionItem.Supplier end as Supplier AS SupplierendasSupplier
FROM I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent
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_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_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_Supplier AS _PreferredSupplier ON _PreferredSupplier.Supplier = PreferredSupplier  -- 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 P_PurOrdSingleScheduleLine AS _PurOrdSingleScheduleLine ON PurchaseOrder = _PurOrdSingleScheduleLine.PurchasingDocument AND PurchaseOrderItem = _PurOrdSingleScheduleLine.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_EAMMaterialItemCategory AS _BillOfMaterialItemCategory ON _BillOfMaterialItemCategory.BOMItemCategory = MaintComponentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IsDeletedStatus ON _IsDeletedStatus.StatusObject = MaintOrderComponentInternalID AND _IsDeletedStatus.StatusCode = 'I0013'  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
-- UNION ALL with additional select branch(es): I_MaintenanceOrder
;