I_ProdAvgDailyUsgeTimeSeries

DDL: I_PRODAVGDAILYUSGETIMESERIES SQL: ITIMESERIESADU Type: view COMPOSITE Package: PPH_DD_VDM_STLM
4 Fields 1 Data Sources 1 Associations

Time Series Avg Daily Usage

I_ProdAvgDailyUsgeTimeSeries is a Composite CDS View that provides data about "Time Series Avg Daily Usage" in SAP S/4HANA. It reads from 1 data source (P_TotalAvgDailyUsgeByDate) and exposes 4 fields with key fields Material, Plant, MRPArea, CalendarDate. It has 1 association to related views. Part of development package PPH_DD_VDM_STLM.

Data Sources (1)

SourceAliasJoin Type
P_TotalAvgDailyUsgeByDate _ADUValForHoriz from

Parameters (1)

NameTypeDefault
P_NonGoodsIssueDayAreExcluded pph_exclude_non_gi_days_ind

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_DDProductCalcFields _DDProdCF $projection.Material = _DDProdCF.Material and $projection.Plant = _DDProdCF.Plant and $projection.MRPArea = _DDProdCF.MRPArea

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ITIMESERIESADU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Time Series Avg Daily Usage view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY CalendarDate CalendarDate Calendar Date

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_ProdAvgDailyUsgeTimeSeries.
-- 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.
-- SQL view name: ITIMESERIESADU
-- Parameters: P_NonGoodsIssueDayAreExcluded : pph_exclude_non_gi_days_ind

CREATE VIEW I_ProdAvgDailyUsgeTimeSeries AS
SELECT
  Material,
  Plant,
  MRPArea,
  CalendarDate
FROM P_TotalAvgDailyUsgeByDate AS _ADUValForHoriz
LEFT OUTER JOIN P_DDProductCalcFields AS _DDProdCF ON Material = _DDProdCF.Material AND Plant = _DDProdCF.Plant AND MRPArea = _DDProdCF.MRPArea  -- association [1..1]
;

Learn More