P_RSHAvailableCapacityShift

DDL: P_RSHAVAILABLECAPACITYSHIFT SQL: PRSHAVCAPSHIFT Type: view CONSUMPTION Package: RSH_CDS_WC_CAPACITY

Work Center Capacity Shifts

P_RSHAvailableCapacityShift is a Consumption CDS View that provides data about "Work Center Capacity Shifts" in SAP S/4HANA. It reads from 1 data source (I_AvailableCapacityShift) and exposes 14 fields with key fields CapacityInternalID, AvailableCapacityType, ValidityEndDate, WeekDay, AvailableCapacityShift. Part of development package RSH_CDS_WC_CAPACITY.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_AvailableCapacityShift shift from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSHAVCAPSHIFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_AvailableCapacityShift CapacityInternalID
KEY AvailableCapacityType I_AvailableCapacityShift AvailableCapacityType
KEY ValidityEndDate I_AvailableCapacityShift ValidityEndDate
KEY WeekDay I_AvailableCapacityShift WeekDay
KEY AvailableCapacityShift I_AvailableCapacityShift AvailableCapacityShift
CapacityNumberOfCapacities I_AvailableCapacityShift CapacityNumberOfCapacities
WorkDayRule I_AvailableCapacityShift WorkDayRule
ShiftDefinition I_AvailableCapacityShift ShiftDefinition
CapacityPlanUtilizationPercent I_AvailableCapacityShift CapacityPlanUtilizationPercent
CapacityStartTimeID I_AvailableCapacityShift CapacityStartTimeID
CapacityEndTimeID I_AvailableCapacityShift CapacityEndTimeID
OperatingDurationInSeconds I_AvailableCapacityShift OperatingDurationInSeconds
BreakDurationInSeconds I_AvailableCapacityShift BreakDurationInSeconds
TotOperatingDurationInSeconds I_AvailableCapacityShift TotOperatingDurationInSeconds 
@AbapCatalog.sqlViewName: 'PRSHAVCAPSHIFT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

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

Name:                       Work Center Capacity Shifts with Input Period
Specification:              This view retrieves all shifts (from all work centers in the system) from the supplied 
                            start date (P_StartDate) onwards. P_EndDate (end date) is not considered at lower level as of now 
Requires:                   NA
Ensures:                    Details of shifts from the supplied start date are returned from work center capacity data.
Owners:                     PRP
Contributors:               
Unit Test required Y/N:     Yes
Additional comments         None

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

define view P_RSHAvailableCapacityShift
  with parameters
    P_StartDate : datum,
    P_EndDate   : datum

  as select from I_AvailableCapacityShift as shift
{
  key shift.CapacityInternalID             as CapacityInternalID,
  key shift.AvailableCapacityType          as AvailableCapacityType,
  key shift.ValidityEndDate                as ValidityEndDate,
  key shift.WeekDay                        as WeekDay,
  key shift.AvailableCapacityShift         as AvailableCapacityShift,

      // Attributes

      shift.CapacityNumberOfCapacities     as CapacityNumberOfCapacities,
      shift.WorkDayRule                    as WorkDayRule,
      shift.ShiftDefinition                as ShiftDefinition,

      // Times and Durations

      shift.CapacityPlanUtilizationPercent as CapacityPlanUtilizationPercent,
      shift.CapacityStartTimeID            as CapacityStartTimeID,
      shift.CapacityEndTimeID              as CapacityEndTimeID,
      shift.OperatingDurationInSeconds     as OperatingDurationInSeconds,
      shift.BreakDurationInSeconds         as BreakDurationInSeconds,
      shift.TotOperatingDurationInSeconds  as TotOperatingDurationInSeconds
}
where

//  The starting interval could have an overnight shift that overlaps to (or ends on) P_StartDate. In such a case, 

//  the ValidityEndDate of the interval would be P_StartDate-1. Consider such interval(s) also


//  ValidityEndDate >= $parameters.P_StartDate

    ValidityEndDate >= dats_add_days($parameters.P_StartDate, -1, 'FAIL' )

Learn More