P_MaterialStockTimeSeries3

DDL: P_MATERIALSTOCKTIMESERIES3 Type: view_entity COMPOSITE Package: ODATA_MM_IM_KPITIMESERIES
26 Fields 1 Data Sources

Join Consumption Groups to Movements

P_MaterialStockTimeSeries3 is a Composite CDS View that provides data about "Join Consumption Groups to Movements" in SAP S/4HANA. It reads from 1 data source (P_MaterialStockAggrMvt) and exposes 26 fields with key fields Material, Plant, StorageLocation, Batch, Supplier. Part of development package ODATA_MM_IM_KPITIMESERIES.

Data Sources (1)

SourceAliasJoin Type
P_MaterialStockAggrMvt P_MaterialStockAggrMvt from

Parameters (1)

NameTypeDefault
P_InventoryConsumptionGroup inventory_consumption_group

Annotations (6)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material mat Material Vehicle Model
KEY Plant mat Plant Valuation Area
KEY StorageLocation mat StorageLocation StorageLocation
KEY Batch mat Batch Lot No.
KEY Supplier mat Supplier Supplier
KEY SDDocument mat SDDocument SD Document
KEY SDDocumentItem mat SDDocumentItem Stock Ident Item
KEY WBSElementInternalID mat WBSElementInternalID WBS Internal ID
KEY Customer mat Customer Sold-to Party
KEY SpecialStockIdfgStockOwner mat SpecialStockIdfgStockOwner
KEY InventoryStockType mat InventoryStockType Stock Type
KEY InventorySpecialStockType mat InventorySpecialStockType Special Stock Type
KEY FiscalYearVariant mat FiscalYearVariant FY Variant
KEY MatlDocLatestPostgDate mat MatlDocLatestPostgDate Posting Date for GR
KEY MaterialBaseUnit mat MaterialBaseUnit Valuation Unit
KEY CostEstimate mat CostEstimate Cost EstimateNo
KEY GoodsMovementTypeMvt mat GoodsMovementType Movement Type
InventoryConsumptionGroupIcg mat InventoryConsumptionGroup
GoodsMovementTypeIcg icg GoodsMovementType Movement Type
CompanyCode mat CompanyCode Receiver Company Code
Currency mat Currency Valuation Crcy
MatlWrhsStkQtyInMatlBaseUnit mat MatlWrhsStkQtyInMatlBaseUnit Quantity
MatlCnsmpnQtyInMatlBaseUnit mat MatlCnsmpnQtyInMatlBaseUnit
MatlStkIncrQtyInMatlBaseUnit mat MatlStkIncrQtyInMatlBaseUnit
MatlStkDecrQtyInMatlBaseUnit mat MatlStkDecrQtyInMatlBaseUnit
_UnitOfMeasure mat _UnitOfMeasure

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_MaterialStockTimeSeries3.
-- 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_InventoryConsumptionGroup : inventory_consumption_group

CREATE VIEW P_MaterialStockTimeSeries3 AS
SELECT
  mat.Material AS Material,
  mat.Plant AS Plant,
  mat.StorageLocation AS StorageLocation,
  mat.Batch AS Batch,
  mat.Supplier AS Supplier,
  mat.SDDocument AS SDDocument,
  mat.SDDocumentItem AS SDDocumentItem,
  mat.WBSElementInternalID AS WBSElementInternalID,
  mat.Customer AS Customer,
  mat.SpecialStockIdfgStockOwner AS SpecialStockIdfgStockOwner,
  mat.InventoryStockType AS InventoryStockType,
  mat.InventorySpecialStockType AS InventorySpecialStockType,
  mat.FiscalYearVariant AS FiscalYearVariant,
  mat.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
  mat.MaterialBaseUnit AS MaterialBaseUnit,
  mat.CostEstimate AS CostEstimate,
  mat.GoodsMovementType AS GoodsMovementTypeMvt,
  mat.InventoryConsumptionGroup AS InventoryConsumptionGroupIcg,
  icg.GoodsMovementType AS GoodsMovementTypeIcg,
  mat.CompanyCode AS CompanyCode,
  mat.Currency AS Currency,
  mat.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit,
  mat.MatlCnsmpnQtyInMatlBaseUnit AS MatlCnsmpnQtyInMatlBaseUnit,
  mat.MatlStkIncrQtyInMatlBaseUnit AS MatlStkIncrQtyInMatlBaseUnit,
  mat.MatlStkDecrQtyInMatlBaseUnit AS MatlStkDecrQtyInMatlBaseUnit,
  mat._UnitOfMeasure AS _UnitOfMeasure
FROM P_MaterialStockAggrMvt
;

Learn More