C_MaterialStockByKeyDate

DDL: C_MATERIALSTOCKBYKEYDATE Type: view_entity CONSUMPTION Package: MM_IM_VDM_STOCK
21 Fields 1 Data Sources

Material Stock at posting date

C_MaterialStockByKeyDate (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Supply Chain

C_MaterialStockByKeyDate is a Consumption CDS View that provides data about "Material Stock at posting date" in SAP S/4HANA. It reads from 1 data source (I_MaterialStock_2) and exposes 21 fields. Part of development package MM_IM_VDM_STOCK.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM-2CL
CapabilitiesAnalytical Query
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul><li><p>What was my total stock on a specified date?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaterialStock_2 I_MaterialStock_2 from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_KeyDate vdm_v_key_date

Annotations (10)

NameValueLevelField
EndUserText.label Material Stock at posting date view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
Analytics.technicalName CMATSTOCKBYKDATE view
Metadata.allowExtensions true view

Fields (21)

KeyFieldSource TableSource FieldDescription
Material Material Material for Stock Mamangement
Plant Plant Valuation Area
StorageLocation StorageLocation Storage Location
Batch Batch Batch Number (Stock Identifier)
Supplier Supplier Supplier for Special Stock
SDDocument SDDocument Sales Order Number of Valuated Sales Order Stock
SDDocumentItem SDDocumentItem Sales Order Item of Valuated Sales Order Stock
WBSElementInternalID Valuated Sales Order Stock WBS Element
InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
InventorySpecialStockType InventorySpecialStockType Special Stock Type
CompanyCode CompanyCode Receiver Company Code
MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Stock Quantity
MaterialName Product Description
CompanyCodeName Name of Company Code or Company
PlantName Plant Name
StorageLocationName Storage Location Name
SupplierName Name of Supplier
CustomerName Name of Customer
InventoryStockTypeName Inventory Stock Type Name
InventorySpecialStockTypeName Special Stock Type Name

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 C_MaterialStockByKeyDate.
-- 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_Language : sylangu, P_KeyDate : vdm_v_key_date

CREATE VIEW C_MaterialStockByKeyDate AS
SELECT
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  cast( WBSElementInternalID as mat_pspnr preserving type ) AS WBSElementInternalID,
  InventoryStockType,
  InventorySpecialStockType,
  CompanyCode,
  MaterialBaseUnit,
  MatlWrhsStkQtyInMatlBaseUnit,
  _Material._Text[1: Language=$parameters.P_Language].ProductName AS MaterialName,
  I_MaterialStock_2._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_MaterialStock_2._Plant.PlantName AS PlantName,
  I_MaterialStock_2._StorageLocation.StorageLocationName AS StorageLocationName,
  I_MaterialStock_2._Supplier.SupplierName AS SupplierName,
  I_MaterialStock_2._Customer.CustomerName AS CustomerName,
  _InventoryStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName AS InventoryStockTypeName,
  _InventorySpecialStockType._Text[1: Language=$parameters.P_Language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName
FROM I_MaterialStock_2
;

Learn More