R_WorkCenterPooledCapShiftTP

//@AbapCatalog.sqlViewName: 'RWRKCTRCAPSHFTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Pooled Capacity Shift'
define view entity R_WorkCenterPooledCapShiftTP
  as select from I_WorkCenterCapacityShift_2 as _Shift
    inner join   I_WorkCenterPooledCapacity  as _PooledCapHeader on _Shift.CapacityInternalID = _PooledCapHeader.CapacityInternalID
  association to R_WorkCenterPooledCapacityTP       as _Header   on  $projection.CapacityInternalID = _Header.CapacityInternalID
  association to parent R_WrkCtrPooledCapIntervalTP as _Interval on  $projection.CapacityInternalID    = _Interval.CapacityInternalID
                                                                 and $projection.CapacityActiveVersion = _Interval.CapacityActiveVersion
                                                                 and $projection.IntervalEndDate       = _Interval.IntervalEndDate
{
  key _Shift.CapacityInternalID,
  key _Shift.CapacityActiveVersion,
  key _Shift.IntervalEndDate,
  key _Shift.WeekDay,
  key cast(coalesce(_Shift.AvailableCapacityShift,'0')as schichtnr preserving type ) as 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 */
      _Interval,
      _Header
}