I_WORKCENTERCAPACITYSHIFT_2

CDS View

Shifts of WorkCenter Capacity

I_WORKCENTERCAPACITYSHIFT_2 is a CDS View in S/4HANA. Shifts of WorkCenter Capacity. It contains 18 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 18 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_WorkCenterCapacityShift_2 view from COMPOSITE Capacity Shift Version 2
I_WorkCenterCapacityShift_3 view from COMPOSITE Capacity Shift Version 3
R_MassMaintCapIntervalShiftTP view_entity inner TRANSACTIONAL capacity Interval Shift Data
R_WorkCenterPooledCapShiftTP view_entity from TRANSACTIONAL Work Center Pooled Capacity Shift

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CapacityActiveVersion CapacityActiveVersion 2
KEY CapacityInternalID CapacityInternalID 2
KEY IntervalEndDate IntervalEndDate 2
KEY WeekDay WeekDay 2
CapacityBreakDuration CapacityBreakDuration 2
CapacityLastChangeDateTime CapacityLastChangeDateTime 2
CapacityNumberOfCapacities CapacityNumberOfCapacities 3
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 3
IntervalStartDate IntervalStartDate 2
OperatingDurationInSeconds OperatingDurationInSeconds 2
ShiftDefinition ShiftDefinition 2
ShiftDefValidityEndDate ShiftDefValidityEndDate 2
ShiftDefValidityStartDate ShiftDefValidityStartDate 2
ShiftEndTime ShiftEndTime 2
ShiftStartTime ShiftStartTime 2
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 2
WorkDayRule WorkDayRule 2 
@AbapCatalog.sqlViewName: 'IWRKCTRCAPSHIFT2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Shifts of WorkCenter Capacity'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
define view I_WorkCenterCapacityShift_2
  as select from P_WorkCenterCapacityShiftCalc
  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 [1..1] to I_CalendarDate          as _EndDate               on $projection.IntervalEndDate = _EndDate.CalendarDate
  association [1..1] to I_WeekDay               as _WeekDay               on $projection.WeekDay = _WeekDay.WeekDay
{
      @ObjectModel.foreignKey.association: '_Capacity'
  key CapacityInternalID,
      @ObjectModel.foreignKey.association: '_AvailableCapacityType'
  key CapacityActiveVersion,
      @ObjectModel.foreignKey.association: '_EndDate'
  key cast(ValidityEndDate as datub preserving type )                                                   as IntervalEndDate,
      @ObjectModel.foreignKey.association: '_WeekDay'
  key cast(WeekDay as vdm_weekday preserving type)                                                      as WeekDay,
  key AvailableCapacityShift,
      cast(ValidityStartDate as datuv preserving type )                                                 as IntervalStartDate,
      WorkDayRule,
      ShiftDefinition,
      cast(ShiftStartTime as kapbegzeit preserving type )                                               as ShiftStartTime,
      cast(ShiftEndTime as kapendzeit preserving type )                                                 as ShiftEndTime,
      cast(ShiftStartDate   as begda preserving type )                                                  as ShiftDefValidityStartDate,
      cast(ShiftEndDate as endda preserving type )                                                      as ShiftDefValidityEndDate,
      cast(CapacityNumberOfCapacities as kapanzahl preserving type )                                    as CapacityNumberOfCapacities,
      cast(CapacityPlanUtilizationPercent as nutzgrad preserving type )                                 as CapacityPlanUtilizationPercent,
      cast(BreakDurationInSeconds as kappause preserving type )                                         as CapacityBreakDuration,
      cast(ceil(fltp_to_dec(OperatingDurationInSeconds  as dec17_3)) as kapeinzt preserving type )      as OperatingDurationInSeconds,
      cast(ceil(fltp_to_dec(TotOperatingDurationInSeconds as dec17_3)) as pph_kapaz preserving type )   as TotOperatingDurationInSeconds,
      case when _Capacity.CapacityLastChangeDateTime is null then
           cast('20190101120000' as kap_lastchange_datetime)
      else _Capacity.CapacityLastChangeDateTime end                                                     as CapacityLastChangeDateTime,

      _Capacity,
      _AvailableCapacityType,
      _EndDate,
      _WeekDay
}
where
  CapacityInternalID != '00000000';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITY",
"P_WORKCENTERCAPACITYSHIFTCALC"
],
"ASSOCIATED":
[
"I_AVAILABLECAPACITYTYPE",
"I_CALENDARDATE",
"I_CAPACITY",
"I_WEEKDAY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More