C_SlsDocFlfmtPurgDocItem

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 C_SlsDocFlfmtPurgDocItem.
-- 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: CSOFPURGDOCITM

CREATE VIEW C_SlsDocFlfmtPurgDocItem AS
SELECT
  Item.PurchasingDocument AS PurchasingDocument,
  Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  cast(Item.Material as productnumber preserving type ) AS Material,
  Item._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  cast(Item.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  Item.Plant AS Plant,
  Item.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  Item.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.OrderQuantity AS OrderQuantity,
  Item.DocumentCurrency AS DocumentCurrency,
  Item.NetAmount AS NetAmount,
  Item.IsCompletelyDelivered AS IsCompletelyDelivered,
  Item.IsFinallyInvoiced AS IsFinallyInvoiced,
  ItemDeliveryDate.DeliveryDate AS DeliveryDate
FROM I_PurchasingDocumentItem AS Item
LEFT OUTER JOIN E_PurchasingDocumentItem AS _Extension ON PurchasingDocument = _Extension.PurchasingDocument AND PurchasingDocumentItem = _Extension.PurchasingDocumentItem  -- association [0..1]
;