P_WeeklyPlndIndepRqmtHistByDte

DDL: P_WEEKLYPLNDINDEPRQMTHISTBYDTE SQL: PWPIRHISTBYDTE Type: view CONSUMPTION

P_WeeklyPlndIndepRqmtHistByDte is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_WeeklyPlndIndepRqmtHist) and exposes 13 fields with key fields Material, ProductionPlant, MRPArea, LastChangeDate, LastChangeTime.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate _CalendarDate left_outer
P_WeeklyPlndIndepRqmtHist _PlndIndReqHist from

Annotations (5)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY ProductionPlant ProductionPlant
KEY MRPArea MRPArea
KEY LastChangeDate LastChangeDate
KEY LastChangeTime LastChangeTime
LastChangeDateTime LastChangeDateTime
PostingDate I_CalendarDate CalendarDate
CalendarYear I_CalendarDate CalendarYear
QuantityInBaseUnit P_WeeklyPlndIndepRqmtHist AverageDailyUsage
FirstDayOfWeekDate P_WeeklyPlndIndepRqmtHist FirstDayOfWeekDate
LastDayOfWeekDate P_WeeklyPlndIndepRqmtHist LastDayOfWeekDate
CalendarMonth
CalendarWeek I_CalendarDate CalendarWeek 
@AbapCatalog.sqlViewName: 'PWPIRHISTBYDTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_WeeklyPlndIndepRqmtHistByDte
  as select from    P_WeeklyPlndIndepRqmtHist as _PlndIndReqHist
    left outer join I_CalendarDate            as _CalendarDate on  _CalendarDate.CalendarDate >= _PlndIndReqHist.FirstDayOfWeekDate
                                                               and _CalendarDate.CalendarDate <= _PlndIndReqHist.LastDayOfWeekDate
{
  key Material,
  key ProductionPlant,
  key MRPArea,
  key Forecast,
  key ForecastYearMonth,
  key LastChangeDate,
  key LastChangeTime,
      LastChangeDateTime,
      _CalendarDate.CalendarDate        as PostingDate,
      _CalendarDate.CalendarYear,
      _PlndIndReqHist.AverageDailyUsage as QuantityInBaseUnit,
      _PlndIndReqHist.FirstDayOfWeekDate,
      _PlndIndReqHist.LastDayOfWeekDate,
      _CalendarDate._CalendarMonth.CalendarMonth,
      _CalendarDate.CalendarWeek
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_CALENDARMONTH",
"P_WEEKLYPLNDINDEPRQMTHIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More