Mmim_Purchase_Order_Items

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 Mmim_Purchase_Order_Items.
-- 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: MMIMPURORDITEMS

CREATE VIEW Mmim_Purchase_Order_Items AS
SELECT
  PurchasingDocument AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  _PurchasingDocument.PurchasingDocumentType AS PurchaseOrderType,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchasingDocument.PurchasingOrganization AS PurOrdPurchasingOrganization,
  _PurchasingDocument.PurchasingGroup AS PurOrdPurchasingGroup,
  _PurchasingDocument.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  _PurchaseOrderHistory.PurchaseOrderHistCategory AS PurchaseOrderHistCategory,
  _PurchasingDocument.SupplyingPlant AS SupplyingPlant,
  _PurchasingDocument.Supplier AS Supplier,
  AccountAssignmentCategory,
  Material,
  PurchasingDocumentItemText AS PurchaseOrderItemText,
  Plant,
  IsCompletelyDelivered,
  PurchasingDocumentItemCategory
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderHistory AS _PurchaseOrderHistory ON PurchaseOrder = _PurchaseOrderHistory.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderHistory.PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchaseOrderType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON supplyingplant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN Mmim_Supplier_Data AS _Supplier_Data ON supplier = _Supplier_Data.Supplier  -- association [1..1]
;