P_SlowMoMatPredMatDocUnion

DDL: P_SLOWMOMATPREDMATDOCUNION SQL: PSLOWMOMATDOCUNI Type: view COMPOSITE
33 Fields 4 Data Sources

P_SlowMoMatPredMatDocUnion is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_MatlStkPerdsBackFrmKeyDte, P_MatlStkPerdsBackFrmKeyDte, P_SlowMoMatPredMatDocRec, I_MaterialDocumentRecord) and exposes 33 fields with key fields YearPeriod, Material, Plant, StockIdentifyingBatch, SpecialStockIdfgSupplier.

Data Sources (4)

SourceAliasJoin Type
P_MatlStkPerdsBackFrmKeyDte P_MatlStkPerdsBackFrmKeyDte from
P_MatlStkPerdsBackFrmKeyDte P_MatlStkPerdsBackFrmKeyDte union_all
P_SlowMoMatPredMatDocRec P_SlowMoMatPredMatDocRec left_outer
I_MaterialDocumentRecord rec left_outer

Parameters (2)

NameTypeDefault
P_KeyDate nsdm_reference_date
P_InventoryConsumptionGroup inventory_consumption_group

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSLOWMOMATDOCUNI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY YearPeriod dat YearPeriod Fiscal Year Period
KEY Material I_MaterialDocumentRecord Material Stock Mat.
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
StartDate dat StartDate Valid From
EndDate dat EndDate Term to
MatlWrhsStkQtyInMatlBaseUnit
YearPeriod Fiscal Year Period
KEY Material I_MaterialDocumentRecord StockIdentifyingMaterial Stock Mat.
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
StartDate dat StartDate Valid From
EndDate dat EndDate Term to
MatlWrhsStkQtyInMatlBaseUnit
MatlCnsmpnQtyInMatlBaseUnit 0

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_SlowMoMatPredMatDocUnion.
-- 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: PSLOWMOMATDOCUNI
-- Parameters: P_KeyDate : nsdm_reference_date, P_InventoryConsumptionGroup : inventory_consumption_group

CREATE VIEW P_SlowMoMatPredMatDocUnion AS
SELECT
  dat.YearPeriod AS YearPeriod,
  rec.Material 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,
  dat.StartDate AS StartDate,
  dat.EndDate AS EndDate,
  sum(rec.MatlStkChangeQtyInBaseUnit) AS MatlWrhsStkQtyInMatlBaseUnit,
  0 AS MatlCnsmpnQtyInMatlBaseUnit
FROM P_MatlStkPerdsBackFrmKeyDte
LEFT OUTER JOIN P_SlowMoMatPredMatDocRec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDocumentRecord AS rec ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MatlStkPerdsBackFrmKeyDte
;

Learn More