P_WRKCTRAVAILABLECAPSHIFT

CDS View

Work Center Available Capacity Shift

P_WRKCTRAVAILABLECAPSHIFT is a CDS View in S/4HANA. Work Center Available Capacity Shift. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_WorkCenterCapacityShiftCalc view_entity left_outer COMPOSITE Work Center Capacity Shift Calculations

Fields (3)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
ShiftDefinition ShiftDefinition 1
WorkDayRule WorkDayRule 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_WrkCtrAvailableCapShift
  as select from I_AvailableCapacityShift
  association [1..1] to P_WorkCenterCapacityCalc       as _Capacity on  $projection.CapacityInternalID = _Capacity.CapacityInternalID

  association [1..1] to I_WorkCenterCapacityInterval_2 as _Interval on  $projection.CapacityInternalID    = _Interval.CapacityInternalID
                                                                    and $projection.AvailableCapacityType = _Interval.CapacityActiveVersion
                                                                    and $projection.ValidityEndDate       = _Interval.IntervalEndDate
{
  key CapacityInternalID,
  key AvailableCapacityType,
  key ValidityEndDate,
  key WeekDay,
  key AvailableCapacityShift,

      cast(coalesce(_Interval.WorkDayRule,'')as workdayrule preserving type ) as WorkDayRule,
      ShiftDefinition,

      CapacityNumberOfCapacities                                              as CapacityNumberOfCapacities,
      CapacityPlanUtilizationPercent                                          as CapacityPlanUtilizationPercent,

      cast(OperatingDurationInSeconds as abap.fltp)                           as OperatingDurationInSeconds,
      BreakDurationInSeconds                                                  as BreakDurationInSeconds,
      cast(TotOperatingDurationInSeconds as abap.fltp)                        as TotOperatingDurationInSeconds,
      _Interval.IntervalEndDate                                               as IntervalEndDate,
      _Interval.IntervalStartDate                                             as IntervalStartDate,
      _Capacity.ShiftGroup                                                    as ShiftGroup,
      _Capacity.ValidityEndDate                                               as CapacityEndDate,
      _Capacity.ValidityStartDate                                             as CapacityStartDate,
      CapacityStartTimeID                                                     as CapacityStartTimeID,
      CapacityEndTimeID                                                       as CapacityEndTimeID,
      _Capacity,
      _Interval
}

Learn More