I_WorkCenterCapacityInterval_2

DDL: I_WORKCENTERCAPACITYINTERVAL_2 Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API

Work Center Capacity Intervals 2

I_WorkCenterCapacityInterval_2 is a Composite CDS View that provides data about "Work Center Capacity Intervals 2" in SAP S/4HANA. It reads from 2 data sources (I_Capacity, I_AvailableCapacityType) and exposes 9 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate. It has 3 associations to related views. Part of development package ODATA_PP_WORKCENTER_API.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Capacity _CapHeader from
I_AvailableCapacityType _Version cross

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Capacity _Capacity $projection.CapacityInternalID = _Capacity.CapacityInternalID
[1..1] I_AvailableCapacityType _AvailableCapacityType $projection.CapacityActiveVersion = _AvailableCapacityType.AvailableCapacityType
[0..1] I_WorkDayRule _WorkDayRule $projection.WorkDayRule = _WorkDayRule.WorkDayRule

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Capacity Intervals 2 view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_Capacity CapacityInternalID
KEY CapacityActiveVersion
KEY IntervalEndDate
ShiftSequence
WorkDayRule
CapacityNumberOfShifts
_Capacity _Capacity
_AvailableCapacityType _AvailableCapacityType
_WorkDayRule _WorkDayRule 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Capacity Intervals 2'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
define view entity I_WorkCenterCapacityInterval_2
  as select from            I_Capacity                   as _CapHeader
    cross join              I_AvailableCapacityType      as _Version
    left outer to many join P_WrkCtrAvailableCapInterval as _Interval on  _Interval.CapacityInternalID    = _CapHeader.CapacityInternalID
                                                                      and _Interval.AvailableCapacityType = _Version.AvailableCapacityType
  association [1..1] to I_Capacity              as _Capacity              on $projection.CapacityInternalID = _Capacity.CapacityInternalID
  association [1..1] to I_AvailableCapacityType as _AvailableCapacityType on $projection.CapacityActiveVersion = _AvailableCapacityType.AvailableCapacityType
  association [0..1] to I_WorkDayRule           as _WorkDayRule           on $projection.WorkDayRule = _WorkDayRule.WorkDayRule
{
  key _CapHeader.CapacityInternalID,
  key cast(coalesce(_Interval.AvailableCapacityType, _Version.AvailableCapacityType ) as kapversion preserving type ) as CapacityActiveVersion,
  key cast(coalesce(_Interval.ValidityEndDate, '99991231' )  as datub preserving type )                         as IntervalEndDate,

      case when _Interval.ValidityBeginDate is null
      then '00010102'
      else
      cast(dats_add_days(_Interval.ValidityBeginDate,1,'FAIL')as datuv preserving type )
      end                                                                        as IntervalStartDate,

      case when _Interval.StdAvailableCapacityIsValid is null
      then 'X'
      else _Interval.StdAvailableCapacityIsValid
      end                                                                        as StdAvailableCapacityIsValid,
      //      cast( coalesce(_Interval.StdAvailableCapacityIsValid, true ) as boole_d preserving type )  as StdAvailableCapacityIsValid,

      //      _Interval.StdAvailableCapacityIsValid as StdAvailableCapacityIsValid,


      cast(coalesce(_Interval.ShiftSequence, ' ' )  as  schprog preserving type )    as ShiftSequence,

      cast(coalesce(_Interval.WorkDayRule, ' ') as  workdayrule)                      as WorkDayRule,

      cast(coalesce(_Interval.CapacityNumberOfShifts, '1' )  as anzschicht preserving type )    as CapacityNumberOfShifts,

      case
      when _Interval.AvailableCapacityIntervalDurn is null
      then '01'
      when _Interval.AvailableCapacityIntervalDurn is initial
      then '01'
      else
      _Interval.AvailableCapacityIntervalDurn
      end                                                                        as AvailableCapacityIntervalDurn,

      case
      when _Interval.StdAvailableCapacityIsValid is null
      then
      cast(_CapHeader.CapacityNumberOfCapacities as kapanzahl preserving type)
      when _Interval.StdAvailableCapacityIsValid is initial
      then
      cast(_Interval.CapacityNumberOfCapacities as kapanzahl preserving type)
      else
      cast(_Capacity.CapacityNumberOfCapacities as kapanzahl preserving type)
      end                                                                        as CapacityNumberOfCapacities,

      case
      when _Interval.StdAvailableCapacityIsValid is null
      then
       _CapHeader.CapacityPlanUtilizationPercent
      when _Interval.StdAvailableCapacityIsValid is initial
      then
      _Interval.CapacityPlanUtilizationPercent
      else
       _Capacity.CapacityPlanUtilizationPercent
      end                                                                        as CapacityPlanUtilizationPercent,

      case when _Capacity.CapacityLastChangeDateTime is null then
           cast('20190101120000' as kap_lastchange_datetime)
      else _Capacity.CapacityLastChangeDateTime end                              as CapacityLastChangeDateTime,

      _Capacity,
      _AvailableCapacityType,
      _WorkDayRule
}

Learn More