I_WorkCenterCapacityShift_3

@AbapCatalog.sqlViewName: 'IWRKCTRCAPSHIFT3'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Capacity Shift Version 3'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM.viewType: #COMPOSITE
define view I_WorkCenterCapacityShift_3 as select from I_WorkCenterCapacityShift_2 as _Shift
       inner join I_WorkCenterCapacityInterval_3 as _Interval on _Interval.CapacityInternalID = _Shift.CapacityInternalID
                                                             and _Interval.CapacityActiveVersion = _Shift.CapacityActiveVersion
                                                             and _Interval.IntervalEndDate = _Shift.IntervalEndDate
                                                             
{
    //I_WorkCenterCapacityShift_2

    key _Interval.WorkCenterInternalID       as WorkCenterInternalID,
    key _Interval.WorkCenterTypeCode         as WorkCenterTypeCode,
    key _Interval.CapacityCategoryAllocation as CapacityCategoryAllocation,
    key _Shift.CapacityInternalID            as CapacityInternalID,
    key _Shift.CapacityActiveVersion         as CapacityActiveVersion,
    key _Shift.IntervalEndDate               as IntervalEndDate,
    key WeekDay,
    key AvailableCapacityShift,
    _Shift.IntervalStartDate,
    _Shift.WorkDayRule,
    ShiftDefinition,
    ShiftStartTime,
    ShiftEndTime,
    ShiftDefValidityStartDate,
    ShiftDefValidityEndDate,
    _Shift.CapacityNumberOfCapacities,
    _Shift.CapacityPlanUtilizationPercent,
    CapacityBreakDuration,
    OperatingDurationInSeconds,
    TotOperatingDurationInSeconds,
    _Shift.CapacityLastChangeDateTime,
    /* Associations */
    //I_WorkCenterCapacityShift_2

    _AvailableCapacityType,
    _Capacity,
    _EndDate, 
    _WeekDay
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYINTERVAL_3",
"I_WORKCENTERCAPACITYSHIFT_2"
],
"ASSOCIATED":
[
"I_AVAILABLECAPACITYTYPE",
"I_CALENDARDATE",
"I_CAPACITY",
"I_WEEKDAY"
],
"BASE":
[
"I_WORKCENTERCAPACITYSHIFT_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/