P_SlowMoMatPredConsDocRec

DDL: P_SLOWMOMATPREDCONSDOCREC Type: view_entity COMPOSITE Package: ODATA_MM_IM_SLONOMOMAT
18 Fields 2 Data Sources

Stock Change and Consumption Quantity

P_SlowMoMatPredConsDocRec is a Composite CDS View that provides data about "Stock Change and Consumption Quantity" in SAP S/4HANA. It reads from 2 data sources (I_InventoryCnsmpnGroupVH, I_MaterialDocumentRecord) and exposes 18 fields with key fields InventoryConsumptionGroup, Material, Plant, StorageLocation, StockIdentifyingBatch. Part of development package ODATA_MM_IM_SLONOMOMAT.

Data Sources (2)

SourceAliasJoin Type
I_InventoryCnsmpnGroupVH congroup cross
I_MaterialDocumentRecord rec from

Annotations (6)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InventoryConsumptionGroup I_InventoryCnsmpnGroupVH InventoryConsumptionGroup Inventory Consumption Group
KEY Material I_MaterialDocumentRecord StockIdentifyingMaterial
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
KEY StorageLocation I_MaterialDocumentRecord StockIdfgStorageLocation
KEY StockIdentifyingBatch I_MaterialDocumentRecord StockIdentifyingBatch Batch SID
KEY SpecialStockIdfgSupplier I_MaterialDocumentRecord SpecialStockIdfgSupplier Supplier SID
KEY SpecialStockIdfgSalesOrder I_MaterialDocumentRecord SpecialStockIdfgSalesOrder Stock Ident Header
KEY SpecialStockIdfgSalesOrderItem I_MaterialDocumentRecord SpecialStockIdfgSalesOrderItem Stock Ident Item
KEY SpecialStockIdfgWBSElement I_MaterialDocumentRecord SpecialStockIdfgWBSElement WBS Internal ID
KEY SpecialStockIdfgCustomer I_MaterialDocumentRecord SpecialStockIdfgCustomer Customer SID
KEY SpecialStockIdfgStockOwner I_MaterialDocumentRecord SpecialStockIdfgStockOwner
KEY InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType Special Stock Type
KEY InventoryStockType I_MaterialDocumentRecord InventoryStockType Stock Type
KEY MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType Movement Type
MatlStkChangeQtyInBaseUnit I_MaterialDocumentRecord MatlStkChangeQtyInBaseUnit
MatlCnsmpnQtyInMatlBaseUnit I_MaterialDocumentRecord MatlCnsmpnQtyInMatlBaseUnit

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_SlowMoMatPredConsDocRec.
-- 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_SlowMoMatPredConsDocRec AS
SELECT
  congroup.InventoryConsumptionGroup AS InventoryConsumptionGroup,
  rec.StockIdentifyingMaterial AS Material,
  rec.Plant AS Plant,
  rec.StockIdfgStorageLocation AS StorageLocation,
  rec.StockIdentifyingBatch AS StockIdentifyingBatch,
  rec.SpecialStockIdfgSupplier AS SpecialStockIdfgSupplier,
  rec.SpecialStockIdfgSalesOrder AS SpecialStockIdfgSalesOrder,
  rec.SpecialStockIdfgSalesOrderItem AS SpecialStockIdfgSalesOrderItem,
  rec.SpecialStockIdfgWBSElement AS SpecialStockIdfgWBSElement,
  rec.SpecialStockIdfgCustomer AS SpecialStockIdfgCustomer,
  rec.SpecialStockIdfgStockOwner AS SpecialStockIdfgStockOwner,
  rec.InventorySpecialStockType AS InventorySpecialStockType,
  rec.InventoryStockType AS InventoryStockType,
  rec.MaterialBaseUnit AS MaterialBaseUnit,
  rec.PostingDate AS PostingDate,
  rec.GoodsMovementType AS GoodsMovementType,
  rec.MatlStkChangeQtyInBaseUnit AS MatlStkChangeQtyInBaseUnit,
  rec.MatlCnsmpnQtyInMatlBaseUnit AS MatlCnsmpnQtyInMatlBaseUnit
FROM I_MaterialDocumentRecord AS rec
CROSS JOIN I_InventoryCnsmpnGroupVH AS congroup
;

Learn More