C_SlsDocFlfmtItemProcess

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_SlsDocFlfmtItemProcess.
-- 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: CSOFSLSDOCITEMPR

CREATE VIEW C_SlsDocFlfmtItemProcess AS
SELECT
  SalesDocument,
  cast(SalesDocumentItem as sales_doc_item preserving type) AS SalesDocumentItem,
  cast(Material as productnumber preserving type ) AS Material,
  cast(_MaterialText[1:Language=$session.system_language].MaterialName as productdescription preserving type ) AS MaterialName,
  SalesDocumentItemText AS SalesOrderItemText,
  OrderQuantity,
  ShippedQuantityInOrderQtyUnit,
  InvoicedQuantityInOrderQtyUnit,
  OrderQuantityUnit,
  TargetQuantity,
  TargetQuantityUnit
FROM I_SalesDocumentItemFulfillmnt
LEFT OUTER JOIN I_SalesOrdOvrlDelivFlfmtSts AS _SalesOrdOvrlDelivFlfmtSts ON ShippingStatus = _SalesOrdOvrlDelivFlfmtSts.SalesOrdOvrlDelivFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_SalesOrdOvrlInvcgFlfmtSts AS _SalesOrdOvrlInvcgFlfmtSts ON InvoicingStatus = _SalesOrdOvrlInvcgFlfmtSts.SalesOrdOvrlInvcgFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;