P_RSHTHISWEEKANDNEXTWEEK

CDS View

P_RSHTHISWEEKANDNEXTWEEK is a CDS View in S/4HANA. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_RSHMaintSchedSimulationOvw view inner CONSUMPTION My Schedules
C_RSHOpInMaintSchedVH view inner CONSUMPTION Value Help for Schedules
C_RSHWrkCtrUtilizationKPI view inner CONSUMPTION Work Center Utilization Overview 
@AbapCatalog.sqlViewName: 'PRSHTHISCWNEXTCW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

/*
CONTRACT**********************************************************************************************************************

Name:                       Date of current week and next week
Specification:              This view helps to convert rows into columns in work center utilization service.
                            It is not possible to return two calendar weeks with one CDS View.
Requires:                   NA
Ensures:                    Date of current week and next week is returned
Owners:                     AN
Contributors:               PRP
Unit Test required Y/N:     Yes
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view P_RSHThisWeekAndNextWeek
  as select from I_CalendarDate
{

  key CalendarDate                            as DateOfCurrentWeek,

      dats_add_days(CalendarDate, 7, 'FAIL')  as DateOfNextWeek,
      dats_add_days(CalendarDate, -7, 'FAIL') as DateOfPreviousWeek,
      dats_add_days(CalendarDate, 14, 'FAIL') as DateofThirdWeek,
      dats_add_days(CalendarDate, 21, 'FAIL') as DateofFourthWeek
}

where
  CalendarDate = $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More