P_SLOWMOMATPREDSTOCKSUM

DDL: P_SLOWMOMATPREDSTOCKSUM Type: view_entity COMPOSITE Package: ODATA_MM_IM_SLONOMOMAT
14 Fields 2 Data Sources

Stock Aggregate

P_SLOWMOMATPREDSTOCKSUM is a Composite CDS View that provides data about "Stock Aggregate" in SAP S/4HANA. It reads from 2 data sources (P_MatlStkPerdsInMonth, I_MaterialDocumentRecord) and exposes 14 fields with key fields StartDate, Material, Plant, StockIdentifyingBatch, SpecialStockIdfgSupplier. Part of development package ODATA_MM_IM_SLONOMOMAT.

Data Sources (2)

SourceAliasJoin Type
P_MatlStkPerdsInMonth per from
I_MaterialDocumentRecord rec inner

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 (14)

KeyFieldSource TableSource FieldDescription
KEY StartDate P_MatlStkPerdsInMonth StartDate Valid From
KEY Material I_MaterialDocumentRecord StockIdentifyingMaterial
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
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
MatlStkChangeQtyInBaseUnit

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_SLOWMOMATPREDSTOCKSUM.
-- 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_SLOWMOMATPREDSTOCKSUM AS
SELECT
  per.StartDate AS StartDate,
  rec.StockIdentifyingMaterial AS Material,
  rec.Plant AS Plant,
  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,
  sum(rec.MatlStkChangeQtyInBaseUnit) AS MatlStkChangeQtyInBaseUnit
FROM P_MatlStkPerdsInMonth AS per
INNER JOIN I_MaterialDocumentRecord AS rec ON /* join condition not captured in parsed metadata */
;

Learn More