P_SlowMoMatPrMoMatDocUnion

DDL: P_SLOWMOMATPRMOMATDOCUNION Type: view_entity COMPOSITE Package: ODATA_MM_IM_SLONOMOMAT
15 Fields 4 Data Sources

Material Document Union

P_SlowMoMatPrMoMatDocUnion is a Composite CDS View that provides data about "Material Document Union" in SAP S/4HANA. It reads from 4 data sources (P_MatlStkPerdsBackFrmKeyDte, P_MatlStkPerdsBackFrmKeyDte, P_SlowMoMatPrMoMatDocRec, I_MaterialDocumentRecord) and exposes 15 fields with key fields YearPeriod, Material, Plant, MaterialBaseUnit, Material. Part of development package ODATA_MM_IM_SLONOMOMAT.

Data Sources (4)

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

Parameters (2)

NameTypeDefault
P_KeyDate nsdm_reference_date
P_InventoryConsumptionGroup inventory_consumption_group

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
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 (15)

KeyFieldSource TableSource FieldDescription
KEY YearPeriod dat YearPeriod Fiscal Year Period
KEY Material I_MaterialDocumentRecord Material
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
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
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
KEY MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
StartDate dat StartDate Valid From
EndDate dat EndDate Term to
MatlWrhsStkQtyInMatlBaseUnit
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_SlowMoMatPrMoMatDocUnion.
-- 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_KeyDate : nsdm_reference_date, P_InventoryConsumptionGroup : inventory_consumption_group

CREATE VIEW P_SlowMoMatPrMoMatDocUnion AS
SELECT
  dat.YearPeriod AS YearPeriod,
  rec.Material AS Material,
  rec.Plant AS Plant,
  rec.MaterialBaseUnit AS MaterialBaseUnit,
  dat.StartDate AS StartDate,
  dat.EndDate AS EndDate,
  sum(rec.MatlStkChangeQtyInBaseUnit) AS MatlWrhsStkQtyInMatlBaseUnit,
  cast( 0 as nsdm_consumption_qty ) AS MatlCnsmpnQtyInMatlBaseUnit
FROM P_MatlStkPerdsBackFrmKeyDte
LEFT OUTER JOIN P_SlowMoMatPrMoMatDocRec 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