P_RSHTHISWEEKANDNEXTWEEK

CDS View

Return current Calendar Week and Next Calendar Week

P_RSHTHISWEEKANDNEXTWEEK is a CDS View in S/4HANA. Return current Calendar Week and Next Calendar Week. 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,

      dats_tims_to_tstmp( CalendarDate , cast( '000000' as abap.tims ),
                  $session.user_timezone,$session.client,'NULL' ) as StartDateTimeOfCurrentWeek,

      dats_tims_to_tstmp( dats_add_days(CalendarDate, 7, 'FAIL') , cast( '235959' as abap.tims ),
                  $session.user_timezone,$session.client,'NULL' ) as EndDateTimeOfNextWeek,

      dats_tims_to_tstmp( dats_add_days(CalendarDate, -7, 'FAIL') , cast( '000000' as abap.tims ),
                  $session.user_timezone,$session.client,'NULL')  as StartDateTimeOfPreviousWeek
}
// Filter based on user timeone date because the data shown in OVP will be according to

// user time zone

where
  CalendarDate = $session.user_date

Learn More