P_MaintOrdNonStkCompFromPurOrd

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_MaintOrdNonStkCompFromPurOrd.
-- 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.
-- SQL view name: PMORDNSTOCKPO

CREATE VIEW P_MaintOrdNonStkCompFromPurOrd AS
SELECT
  PurchasingDocument AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  I_PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_PurgDocAccountAssignment.OrderID AS MaintenanceOrder,
  I_MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  I_PurgDocAccountAssignment.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurgDocAccountAssignment.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurgDocAccountAssignment.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem
FROM I_PurgDocAccountAssignment
INNER JOIN I_MaintenanceOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MaintPlngBcktOrder AS _PlanningBucketOrder ON _PlanningBucketOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = I_PurgDocAccountAssignment.OrderID  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON I_PurgDocAccountAssignment.OrderID = _MaintenanceOrderOperation.MaintenanceOrder AND I_PurgDocAccountAssignment.OrderIntBillOfOperationsItem = _MaintenanceOrderOperation.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
;