I_MaterialDocumentRecordXtrct

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 I_MaterialDocumentRecordXtrct.
-- 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.

CREATE VIEW I_MaterialDocumentRecordXtrct 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,
  cast(mat_pspnr as mmim_mat_pspnr preserving type) 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_disub_owner_sid preserving type) AS SpecialStockIdfgStockOwner,
  resourcename_sid AS ResourceID
FROM matdoc_extract
LEFT OUTER JOIN I_Product AS _StockIdentifyingMaterial ON StockIdentifyingMaterial = _StockIdentifyingMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StockIdfgStorageLocation ON StockIdfgStorageLocation = _StockIdfgStorageLocation.StorageLocation AND Plant = _StockIdfgStorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SpecialStockIdfgSupplier ON SpecialStockIdfgSupplier = _SpecialStockIdfgSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SpecialStockIdfgCustomer ON SpecialStockIdfgCustomer = _SpecialStockIdfgCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SpecialStockIdfgStockOwner ON SpecialStockIdfgStockOwner = _SpecialStockIdfgStockOwner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryStockType ON InventoryStockType = _InventoryStockType.InventoryStockType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _SpecialStockIdfgWBSElement ON SpecialStockIdfgWBSElement = _SpecialStockIdfgWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SpecialStockIdfgSalesOrder ON SpecialStockIdfgSalesOrder = _SpecialStockIdfgSalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SpecialStockIdfgSalesOrderItm ON SpecialStockIdfgSalesOrder = _SpecialStockIdfgSalesOrderItm.SalesOrder AND SpecialStockIdfgSalesOrderItem = _SpecialStockIdfgSalesOrderItm.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _SpclStkIdfgWBSElmntBasicData ON SpecialStockIdfgWBSElement = _SpclStkIdfgWBSElmntBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ResourceBasic AS _ResourceBasic ON ResourceID = _ResourceBasic.ResourceID  -- association [0..*]
;