P_WrkCtrAvailableCapShift

DDL: P_WRKCTRAVAILABLECAPSHIFT Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API

Work Center Available Capacity Shift

P_WrkCtrAvailableCapShift is a Composite CDS View that provides data about "Work Center Available Capacity Shift" in SAP S/4HANA. It reads from 1 data source (I_AvailableCapacityShift) and exposes 21 fields with key fields CapacityInternalID, AvailableCapacityType, ValidityEndDate, WeekDay, AvailableCapacityShift. It has 2 associations to related views. Part of development package ODATA_PP_WORKCENTER_API.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_AvailableCapacityShift I_AvailableCapacityShift from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_WorkCenterCapacityCalc _Capacity $projection.CapacityInternalID = _Capacity.CapacityInternalID
[1..1] I_WorkCenterCapacityInterval_2 _Interval $projection.CapacityInternalID = _Interval.CapacityInternalID and $projection.AvailableCapacityType = _Interval.CapacityActiveVersion and $projection.ValidityEndDate = _Interval.IntervalEndDate

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
KEY AvailableCapacityType AvailableCapacityType
KEY ValidityEndDate ValidityEndDate
KEY WeekDay WeekDay
KEY AvailableCapacityShift AvailableCapacityShift
WorkDayRule
ShiftDefinition ShiftDefinition
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
OperatingDurationInSeconds
BreakDurationInSeconds BreakDurationInSeconds
TotOperatingDurationInSeconds
IntervalEndDate _Interval IntervalEndDate
IntervalStartDate _Interval IntervalStartDate
ShiftGroup _Capacity ShiftGroup
CapacityEndDate _Capacity ValidityEndDate
CapacityStartDate _Capacity ValidityStartDate
CapacityStartTimeID CapacityStartTimeID
CapacityEndTimeID CapacityEndTimeID
_Capacity _Capacity
_Interval _Interval 
@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