P_DailyWeeklyMnthlyPIRHist

DDL: P_DAILYWEEKLYMNTHLYPIRHIST SQL: PDYMNTHWKPIRHIST Type: view CONSUMPTION
11 Fields 2 Data Sources 1 Associations

P_DailyWeeklyMnthlyPIRHist is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_PIRHistByLastChangeDateTime, P_ForecastDemandItemHistory) and exposes 11 fields with key fields Material, ProductionPlant, MRPArea, DeliveryDate. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_PIRHistByLastChangeDateTime _PlndIndReqHist from
P_ForecastDemandItemHistory PIRHist inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.DeliveryDate = _CalendarDate.CalendarDate

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PDYMNTHWKPIRHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material P_PIRHistByLastChangeDateTime Material Vehicle Model
KEY ProductionPlant P_PIRHistByLastChangeDateTime ProductionPlant Prod plnt
KEY MRPArea P_PIRHistByLastChangeDateTime MRPArea MRP Area
KEY DeliveryDate P_PIRHistByLastChangeDateTime DeliveryDate Delivery Date
LastChangeDateTime P_ForecastDemandItemHistory LastChangeDateTime Timestamp
LastChangeDate
LastChangeTime
NumberOfDays
FirstDayOfMonthDateendasStartDate
LastDayOfMonthDateendasEndDate
NumberOfDays3endasQuantityInBaseUnit

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_DailyWeeklyMnthlyPIRHist.
-- 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: PDYMNTHWKPIRHIST

CREATE VIEW P_DailyWeeklyMnthlyPIRHist AS
SELECT
  _PlndIndReqHist.Material AS Material,
  _PlndIndReqHist.ProductionPlant AS ProductionPlant,
  _PlndIndReqHist.MRPArea AS MRPArea,
  _PlndIndReqHist.DeliveryDate AS DeliveryDate,
  PIRHist.LastChangeDateTime AS LastChangeDateTime,
  tstmp_to_dats( PIRHist.LastChangeDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS LastChangeDate,
  tstmp_to_tims( PIRHist.LastChangeDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS LastChangeTime,
  _CalendarDate._YearMonth.NumberOfDays AS NumberOfDays,
  case ForecastPeriodMode when '1' then _PlndIndReqHist.DeliveryDate when '2' then _CalendarDate.FirstDayOfWeekDate when '3' then _CalendarDate._YearMonth.FirstDayOfMonthDate end as StartDate AS FirstDayOfMonthDateendasStartDate,
  case ForecastPeriodMode when '1' then _PlndIndReqHist.DeliveryDate when '2' then dats_add_days(_CalendarDate.FirstDayOfWeekDate, 6, 'NULL') when '3' then _CalendarDate._YearMonth.LastDayOfMonthDate end as EndDate AS LastDayOfMonthDateendasEndDate,
  case ForecastPeriodMode when '1' then ForecastQuantity when '2' then division( fltp_to_dec( ForecastQuantity as abap.dec(10,0) ), 7, 3 ) when '3' then division( fltp_to_dec(ForecastQuantity as abap.dec(10,4) ), _CalendarDate._YearMonth.NumberOfDays, 3) end as QuantityInBaseUnit AS NumberOfDays3endasQuantityInBaseUnit
FROM P_PIRHistByLastChangeDateTime AS _PlndIndReqHist
INNER JOIN P_ForecastDemandItemHistory AS PIRHist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON DeliveryDate = _CalendarDate.CalendarDate  -- association [0..1]
;

Learn More