P_SupDmndAllDocMatlStk

DDL: P_SUPDMNDALLDOCMATLSTK Type: view COMPOSITE
11 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord Stock from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSUPDMNDMATSTK view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (11)

KeyFieldSource TableSource FieldDescription
Material I_MaterialDocumentRecord StockIdentifyingMaterial Stock Mat.
Plant I_MaterialDocumentRecord Plant Valuation Area
Batch I_MaterialDocumentRecord StockIdentifyingBatch Batch SID
StorageLocation I_MaterialDocumentRecord StockIdfgStorageLocation Stor. Location SID
SalesOrder I_MaterialDocumentRecord SpecialStockIdfgSalesOrder Stock Ident Header
SalesOrderItem I_MaterialDocumentRecord SpecialStockIdfgSalesOrderItem Stock Ident Item
TotalQuantity I_MaterialDocumentRecord MatlStkChangeQtyInBaseUnit
BaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
DocumentCurrency
NetPriceAmount
SupplyDeliveryDate

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_SupDmndAllDocMatlStk.
-- 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_SupDmndAllDocMatlStk AS
SELECT
  Stock.StockIdentifyingMaterial AS Material,
  Stock.Plant AS Plant,
  Stock.StockIdentifyingBatch AS Batch,
  Stock.StockIdfgStorageLocation AS StorageLocation,
  Stock.SpecialStockIdfgSalesOrder AS SalesOrder,
  Stock.SpecialStockIdfgSalesOrderItem AS SalesOrderItem,
  Stock.MatlStkChangeQtyInBaseUnit AS TotalQuantity,
  Stock.MaterialBaseUnit AS BaseUnit,
  cast( '' as waers ) AS DocumentCurrency,
  cast( 0 as abap.curr(11, 2) ) AS NetPriceAmount,
  $session.system_date AS SupplyDeliveryDate
FROM I_MaterialDocumentRecord AS Stock
;

Learn More