P_MatlStkCsgnmtStockQuantity

DDL: P_MATLSTKCSGNMTSTOCKQUANTITY Type: view_entity COMPOSITE
10 Fields 2 Data Sources

P_MatlStkCsgnmtStockQuantity is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaterialDocumentRecord, I_MatlStkSubscrpnConsignment) and exposes 10 fields with key fields Plant, Supplier, Material, StorageLocation, InventoryStockType.

Data Sources (2)

SourceAliasJoin Type
I_MaterialDocumentRecord _Record from
I_MatlStkSubscrpnConsignment _Subs inner

Parameters (2)

NameTypeDefault
P_PostingDate sydate
P_CreationDateTime timestamp

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
KEY Supplier I_MaterialDocumentRecord SpecialStockIdfgSupplier Supplier SID
KEY Material I_MaterialDocumentRecord Material Vehicle Model
KEY StorageLocation I_MaterialDocumentRecord StorageLocation StorageLocation
KEY InventoryStockType I_MaterialDocumentRecord InventoryStockType Stock Type
KEY MaterialBaseUnit
KEY CompanyCode I_MaterialDocumentRecord CompanyCode Receiver Company Code
MaterialStockSubscriptionUUID I_MatlStkSubscrpnConsignment MaterialStockSubscriptionUUID Collection Subs. Id
MaterialStockSubscriptionItem I_MatlStkSubscrpnConsignment MaterialStockSubscriptionItem Stock Reporting Subscription Id Item
MatlWrhsStkQtyInMatlBaseUnit

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_MatlStkCsgnmtStockQuantity.
-- 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.
-- Parameters: P_PostingDate : sydate, P_CreationDateTime : timestamp

CREATE VIEW P_MatlStkCsgnmtStockQuantity AS
SELECT
  _Record.Plant AS Plant,
  _Record.SpecialStockIdfgSupplier AS Supplier,
  _Record.Material AS Material,
  _Record.StorageLocation AS StorageLocation,
  _Record.InventoryStockType AS InventoryStockType,
  _Record._Material.MaterialBaseUnit AS MaterialBaseUnit,
  _Record.CompanyCode AS CompanyCode,
  _Subs.MaterialStockSubscriptionUUID AS MaterialStockSubscriptionUUID,
  _Subs.MaterialStockSubscriptionItem AS MaterialStockSubscriptionItem,
  sum(_Record.MatlStkChangeQtyInBaseUnit ) AS MatlWrhsStkQtyInMatlBaseUnit
FROM I_MaterialDocumentRecord AS _Record
INNER JOIN I_MatlStkSubscrpnConsignment AS _Subs ON /* join condition not captured in parsed metadata */
;

Learn More