@AbapCatalog.sqlViewName: 'PRSHWCSHIFTDEF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
/*
CONTRACT**********************************************************************************************************************
Name: Work Center Shift Definitions
Specification: This view retrieves the shift definition details.
Requires: NA
Ensures: Break Duration is calculated by End Time - Start Time - Operating Duration.
Owners: CK
Contributors: AN
Unit Test required Y/N: Yes
Additional comments None
END OF CONTRACT***************************************************************************************************************
*/
define view P_RSHShiftDefinition
as select from P_RSHShiftDefinitionBase
{
key ShiftDefinition,
key ShiftGrouping,
key ShiftEndDate,
ShiftEndTime,
ShiftDefinitionName,
CapacityEndTimeID,
ShiftStartDate,
ShiftStartTime,
CapacityStartTimeID,
OperatingDurationInSeconds,
ValidityEndDate,
WorkBreakSchedule,
// Calculate Break Duration
case when OperatingDurationInSeconds = 0
then 0
else
case when CapacityStartTimeID < CapacityEndTimeID
then ( CapacityEndTimeID - CapacityStartTimeID - OperatingDurationInSeconds )
else ( CapacityEndTimeID - CapacityStartTimeID + 86400 - OperatingDurationInSeconds ) end end as BreakDuration
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RSHSHIFTDEFINITIONBASE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/