P_AvgDailyUsgeHrznForCalDte

DDL: P_AVGDAILYUSGEHRZNFORCALDTE SQL: PHORIZFOREACHDTE Type: view COMPOSITE Package: PPH_DD_VDM_STLM
6 Fields 2 Data Sources

P view

P_AvgDailyUsgeHrznForCalDte is a Composite CDS View that provides data about "P view" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_MatlAvgDailyUsgeCalHrznDates) and exposes 6 fields with key fields Material, Plant, MRPArea. Part of development package PPH_DD_VDM_STLM.

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate _CalDate left_outer
P_MatlAvgDailyUsgeCalHrznDates _Horizons from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PHORIZFOREACHDTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

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

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_AvgDailyUsgeHrznForCalDte.
-- 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: PHORIZFOREACHDTE

CREATE VIEW P_AvgDailyUsgeHrznForCalDte AS
SELECT
  Material,
  Plant,
  MRPArea,
  _CalDate.CalendarDate AS CalendarDate,
  DATS_ADD_DAYS( cast( _CalDate.CalendarDate as sydatum) , -1 * ceil (cast(HorizonDaysInPast as abap.int4)) ,'FAIL') AS ADUHorizonStartDate,
  DATS_ADD_DAYS( cast( _CalDate.CalendarDate as sydatum) , ceil (cast(HorizonDaysInFuture as abap.int4)) - 1,'FAIL') AS ADUHorizonEndDate
FROM P_MatlAvgDailyUsgeCalHrznDates AS _Horizons
LEFT OUTER JOIN I_CalendarDate AS _CalDate ON /* join condition not captured in parsed metadata */
;

Learn More