P_PurchasingDocumentItem

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_PurchasingDocumentItem.
-- 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: PPURDOCITEM

CREATE VIEW P_PurchasingDocumentItem AS
SELECT
  ekpo.ebeln AS PurchasingDocument,
  ekpo.ebelp AS PurchasingDocumentItem,
  ekpo.bstyp AS PurchasingDocumentCategory,
  ekpo.loekz AS PurchasingDocumentDeletionCode,
  ekpo.txz01 AS PurchasingDocumentItemText,
  ekpo.elikz AS IsCompletelyDelivered,
  ekpo.meins AS OrderQuantityUnit,
  ekpo.menge AS OrderQuantity,
  _PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  ekpo.netwr AS NetAmount,
  ekpo.matnr AS Material,
  ekpo.berid AS MRPArea,
  ekpo.bukrs AS CompanyCode,
  ekpo.sobkz AS InventorySpecialStockType,
  _PurchasingDocument._DocumentCurrency AS _DocumentCurrency
FROM ekpo
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurgDocumentCategory ON PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchasingDocument = _ScheduleLine.PurchasingDocument AND PurchasingDocumentItem = _ScheduleLine.PurchasingDocumentItem  -- association [0..*]
;