P_MaterialDocumentExtract

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_MaterialDocumentExtract.
-- 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: PMATDOCEXT

CREATE VIEW P_MaterialDocumentExtract AS
SELECT
  matbf AS StockIdentifyingMaterial,
  werks AS Plant,
  lgort_sid AS StockIdfgStorageLocation,
  charg_sid AS StockIdentifyingBatch,
  lifnr_sid AS SpecialStockIdfgSupplier,
  mat_kdauf AS SpecialStockIdfgSalesOrder,
  mat_kdpos AS SpecialStockIdfgSalesOrderItem,
  mat_pspnr AS SpecialStockIdfgWBSElement,
  kunnr_sid AS SpecialStockIdfgCustomer,
  cast(sobkz as nsdm_spcl_stock_type preserving type) AS InventorySpecialStockType,
  lbbsa_sid AS InventoryStockType,
  cast(disub_owner_sid as nsdm_add_spcl_stock_supplier preserving type) AS SpecialStockIdfgStockOwner
FROM matdoc_extract
;