I_DailyChmlProductStkQty

DDL: I_DAILYCHMLPRODUCTSTKQTY Type: view COMPOSITE
13 Fields 5 Data Sources

SARA: Daily Chemical Product Quantity

I_DailyChmlProductStkQty is a Composite CDS View that provides data about "SARA: Daily Chemical Product Quantity" in SAP S/4HANA. It reads from 5 data sources (I_UnitOfMeasure, I_ChemicalMaterial, I_ChemicalRevision, P_PLANTCURRENCY, I_MaterialStockTimeSeries) and exposes 13 fields with key fields Material, Plant, StorageLocation, InventoryStockType, ProductBaseUnit.

Data Sources (5)

SourceAliasJoin Type
I_UnitOfMeasure _BaseUnit inner
I_ChemicalMaterial _ChemicalMaterial inner
I_ChemicalRevision _ChemicalRevision inner
P_PLANTCURRENCY _CompanyCode inner
I_MaterialStockTimeSeries I_MaterialStockTimeSeries from

Parameters (3)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date
P_PeriodType nsdm_period_type

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICHMDLYPRODQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SARA: Daily Chemical Product Quantity view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
DataAging.noAgingRestriction true view

Fields (13)

KeyFieldSource TableSource FieldDescription
EndDateasEndDate
KEY Material MaterialStock Material Vehicle Model
KEY Plant MaterialStock Plant Valuation Area
KEY StorageLocation MaterialStock StorageLocation StorageLocation
KEY InventoryStockType MaterialStock InventoryStockType Stock Type
KEY ProductBaseUnit MaterialStock MaterialBaseUnit Valuation Unit
KEY ChemicalUUID I_ChemicalMaterial ChemicalUUID NodeID
Quantity
CompanyCode P_PLANTCURRENCY CompanyCode Receiver Company Code
_Material MaterialStock _Material
_StorageLocation MaterialStock _StorageLocation
_Plant MaterialStock _Plant
_InventoryStockType MaterialStock _InventoryStockType

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 I_DailyChmlProductStkQty.
-- 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_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_PeriodType : nsdm_period_type

CREATE VIEW I_DailyChmlProductStkQty AS
SELECT
  MaterialStock.Material AS Material,
  MaterialStock.Plant AS Plant,
  MaterialStock.StorageLocation AS StorageLocation,
  MaterialStock.InventoryStockType AS InventoryStockType,
  MaterialStock.MaterialBaseUnit AS ProductBaseUnit,
  _ChemicalMaterial.ChemicalUUID AS ChemicalUUID,
  sum(MatlWrhsStkQtyInMatlBaseUnit) AS Quantity,
  _CompanyCode.CompanyCode AS CompanyCode,
  MaterialStock._Material AS _Material,
  MaterialStock._StorageLocation AS _StorageLocation,
  MaterialStock._Plant AS _Plant,
  MaterialStock._InventoryStockType AS _InventoryStockType
FROM I_MaterialStockTimeSeries
INNER JOIN I_ChemicalMaterial AS _ChemicalMaterial ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChemicalRevision AS _ChemicalRevision ON /* join condition not captured in parsed metadata */
INNER JOIN I_UnitOfMeasure AS _BaseUnit ON /* join condition not captured in parsed metadata */
INNER JOIN P_PLANTCURRENCY AS _CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More