C_MaterialStockTimeSeries

DDL: C_MATERIALSTOCKTIMESERIES Type: view CONSUMPTION
26 Fields 1 Data Sources

Material stock for periods by type

C_MaterialStockTimeSeries (Consumption)

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

Supply Chain

C_MaterialStockTimeSeries is a Consumption CDS View that provides data about "Material stock for periods by type" in SAP S/4HANA. It reads from 1 data source (I_MaterialStockTimeSeries) and exposes 26 fields.

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM
CapabilitiesAnalytical Query
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul><li><p>How does the stock quantity evolve over a certain time period such as a day, week, or month?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaterialStockTimeSeries I_MaterialStockTimeSeries from

Parameters (4)

NameTypeDefault
P_Language sylangu
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date
P_PeriodType nsdm_period_type

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMATSTOCKTIMESER view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Material stock for periods by type view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE 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
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
PeriodType PeriodType PeriodIndicator
EndDate EndDate End Date of Fiscal Period
YearPeriod YearPeriod Fiscal Year + Fiscal Period
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 WBSElementInternalID Valuated Sales Order Stock WBS Element
Customer Customer Customer for Special Stock
InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
InventorySpecialStockType InventorySpecialStockType Special Stock Type
CompanyCode CompanyCode Receiver Company Code
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Stock Quantity
MaterialName Material Description
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
PlantName _Plant PlantName Plant Name
StorageLocationName _StorageLocation StorageLocationName Storage Location Name
SupplierName _Supplier SupplierName Name of Supplier
CustomerName _Customer 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_MaterialStockTimeSeries.
-- 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_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_PeriodType : nsdm_period_type

CREATE VIEW C_MaterialStockTimeSeries AS
SELECT
  PeriodType,
  EndDate,
  YearPeriod,
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  InventoryStockType,
  InventorySpecialStockType,
  CompanyCode,
  FiscalYearVariant,
  MaterialBaseUnit,
  MatlWrhsStkQtyInMatlBaseUnit,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName AS MaterialName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Plant.PlantName AS PlantName,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _Supplier.SupplierName AS SupplierName,
  _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_MaterialStockTimeSeries
;

Learn More