P_PPH_REPORTINGDATE3

CDS View

P_PPH_REPORTINGDATE3 is a CDS View in S/4HANA. It contains 4 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 4 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MfgOrderItemAmountCube view inner COMPOSITE Manufacturing Order Item Amount - Cube
I_MfgOrderItemCube view inner COMPOSITE Manufacturing Order Item - Cube
I_MfgOrderOperationCompCube view inner COMPOSITE Manufacturing Order Operation Component - Cube
I_MfgOrderOperationConfCube view inner COMPOSITE Manufacturing Order Operation Confirmation - Cube
I_MfgOrderOperationConfOper view inner COMPOSITE Mfg Order Operation Confirmation with Operation Details
I_MfgOrderOperationDurnCube view inner COMPOSITE Manufacturing Order Operation Duration - Cube
I_MfgOrderSFILeadTimeCube view inner COMPOSITE Mfg Order SFI Lead Time - Cube

Fields (4)

KeyField CDS FieldsUsed in Views
ReportingDateMonth EndDateMonth,EntryDateMonth,RequirementDateMonth 7
ReportingDateWeek EndDateWeek,EntryDateWeek,RequirementDateWeek 7
ReportingDateWeekDay EndDateWeekDay,EntryDateWeekDay,RequirementDateWeekDay 6
ReportingDateYear EndDateYear,EntryDateYear,RequirementDateYear 7 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_PPH_ReportingDate3
    as select from P_PPH_ReportingDate2

  association [1..1] to I_ReportingPeriod     as _ReportingPeriod on $projection.ReportingPeriod = _ReportingPeriod.ReportingPeriod
  association [0..*] to I_ReportingPeriodText as _Text            on $projection.ReportingPeriod = _Text.ReportingPeriod

{
  key ReportingDate,
      TodayDate,
      YesterdayDate,
      LastCalendarWeek,
      LastCalendarMonth,
      LastCalendarYear,

      // set master Reporting Period

      case 
        when ReportingDate > TodayDate
          then '00' // Future

        when ReportingDate = TodayDate
          then '01' // Today

        when ReportingDate = YesterdayDate
          then '02' // Yesterday

        when CurrentWeek = ReportingWeek
         and CurrentYear = ReportingYear
          then '03' // Current Week

        when LastCalendarWeek = ReportingWeek
         and CurrentYear = ReportingYear
          then '04' // Last Week

        when CurrentMonth = ReportingMonth
         and CurrentYear = ReportingYear
          then '05' // Current Month

        when LastCalendarMonth = ReportingMonth
         and CurrentYear = ReportingYear
          then '06' // Last Month

        when CurrentQuarter = ReportingQuarter
         and CurrentYear = ReportingYear
          then '09' // Current Quarter

        when LastCalendarQuarter = ReportingQuarter
         and CurrentYear = ReportingYear
          then '10' // Last Quarter

        when CurrentYear = ReportingYear
          then '07' // Current Year

        when LastCalendarYear = ReportingYear
          then '08' // Last Year

        else '13' // Older

      end as ReportingPeriod,

      // Reporting Date items (external usage)

      ReportingDateWeekDay,
      ReportingDateWeek,
      ReportingDateMonth,
      ReportingDateYear,

      // Associations

      _ReportingDate,
      _ReportingPeriod,
      _CurrentDate,
      _YesterdayDate,
      _Text
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PPH_REPORTINGDATE2"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_REPORTINGPERIOD",
"I_REPORTINGPERIODTEXT"
],
"BASE":
[
"P_PPH_REPORTINGDATE2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More