P_MatDocRec

DDL: P_MATDOCREC SQL: PMATDOCREC Type: view COMPOSITE
19 Fields 1 Data Sources

P_MatDocRec is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 19 fields.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDoc from

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PMATDOCREC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear Material Document Year
MaterialDocument I_MaterialDocumentRecord MaterialDocument Material Doc.
MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem Material Document Item
StockIdentifyingMaterial StockIdentifyingMaterial Stock Mat.
Plant I_MaterialDocumentRecord Plant Valuation Area
StockIdfgStorageLocation StockIdfgStorageLocation Stor. Location SID
StockIdentifyingBatch StockIdentifyingBatch Batch SID
SpecialStockIdfgSupplier SpecialStockIdfgSupplier Supplier SID
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder Stock Ident Header
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem Stock Ident Item
SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement WBS Internal ID
SpecialStockIdfgCustomer SpecialStockIdfgCustomer Customer SID
InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType Special Stock Type
InventoryStockType InventoryStockType Stock Type
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
GoodsMovementType GoodsMovementType Movement Type

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_MatDocRec.
-- 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: PMATDOCREC

CREATE VIEW P_MatDocRec AS
SELECT
  MatDoc.MaterialDocumentYear AS MaterialDocumentYear,
  MatDoc.MaterialDocument AS MaterialDocument,
  MatDoc.MaterialDocumentItem AS MaterialDocumentItem,
  StockIdentifyingMaterial,
  MatDoc.Plant AS Plant,
  StockIdfgStorageLocation,
  StockIdentifyingBatch,
  SpecialStockIdfgSupplier,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SpecialStockIdfgWBSElement,
  SpecialStockIdfgCustomer,
  MatDoc.InventorySpecialStockType AS InventorySpecialStockType,
  InventoryStockType,
  SpecialStockIdfgStockOwner,
  MatDoc.PostingDate AS PostingDate,
  MatDoc.MaterialBaseUnit AS MaterialBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  GoodsMovementType
FROM I_MaterialDocumentRecord AS MatDoc
;

Learn More