I_WorkCenterCapacityShift_3

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Shift Version 3'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM.viewType: #COMPOSITE
define view entity 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 _Shift.WeekDay,
    key _Shift.AvailableCapacityShift,
    _Shift.IntervalStartDate,
    _Shift.WorkDayRule,
    _Shift.ShiftDefinition,
    _Shift.ShiftStartTime,
    _Shift.ShiftEndTime,
    _Shift.ShiftDefValidityStartDate,
    _Shift.ShiftDefValidityEndDate,
    _Shift.CapacityNumberOfCapacities,
    _Shift.CapacityPlanUtilizationPercent,
    _Shift.CapacityBreakDuration,
    _Shift.OperatingDurationInSeconds,
    _Shift.TotOperatingDurationInSeconds,
    _Shift.CapacityLastChangeDateTime,
    /* Associations */
    //I_WorkCenterCapacityShift_2

    _Shift._AvailableCapacityType,
    _Shift._Capacity,
    _Shift._EndDate, 
    _Shift._WeekDay
}