P_MaterialDocumentExtract

DDL: P_MATERIALDOCUMENTEXTRACT Type: view_entity COMPOSITE Package: ODATA_MM_IM_PI_MASS_CREATE
13 Fields 1 Data Sources

Basis view for MATDOC EXTRACT table

P_MaterialDocumentExtract is a Composite CDS View that provides data about "Basis view for MATDOC EXTRACT table" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 13 fields. Part of development package ODATA_MM_IM_PI_MASS_CREATE.

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
StockIdentifyingMaterial matbf Stock Mat.
Plant werks Receiving Plant
StockIdfgStorageLocation lgort_sid Stor. Location SID
StockIdentifyingBatch charg_sid Batch SID
SpecialStockIdfgSupplier lifnr_sid Supplier SID
SpecialStockIdfgSalesOrder mat_kdauf SD Doc of Inv.
SpecialStockIdfgSalesOrderItem mat_kdpos SD Item of Inv.
SpecialStockIdfgWBSElement mat_pspnr WBSElem of Inv.
SpecialStockIdfgCustomer kunnr_sid Customer SID
InventorySpecialStockType Special Stock
InventoryStockType lbbsa_sid Stock Type
SpecialStockIdfgStockOwner Addl Supplier SID
withrecordsoftypeMDOC_CP

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.

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
;

Learn More