R_WorkCenterCapacityShiftTP

DDL: R_WORKCENTERCAPACITYSHIFTTP SQL: RWKCCAPSHIFTTP Type: view_entity TRANSACTIONAL

Capacity Shift

R_WorkCenterCapacityShiftTP is a Transactional CDS View that provides data about "Capacity Shift" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacityShift_3) and exposes 23 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityShift_3 I_WorkCenterCapacityShift_3 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Shift view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY CapacityCategoryAllocation CapacityCategoryAllocation
KEY CapacityInternalID CapacityInternalID
KEY CapacityActiveVersion CapacityActiveVersion
KEY IntervalEndDate IntervalEndDate
KEY WeekDay WeekDay
KEY AvailableCapacityShift
IntervalStartDate IntervalStartDate
WorkDayRule WorkDayRule
ShiftDefinition ShiftDefinition
ShiftStartTime ShiftStartTime
ShiftEndTime ShiftEndTime
ShiftDefValidityStartDate ShiftDefValidityStartDate
ShiftDefValidityEndDate ShiftDefValidityEndDate
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
OperatingDurationInSeconds OperatingDurationInSeconds
TotOperatingDurationInSeconds TotOperatingDurationInSeconds
CapacityLastChangeDateTime CapacityLastChangeDateTime
_Interval _Interval
_Header _Header 
//@AbapCatalog.sqlViewName: 'RWKCCAPSHIFTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Shift'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity R_WorkCenterCapacityShiftTP
  as select from I_WorkCenterCapacityShift_3
  association to parent R_WorkCenterCapacityIntervalTP as _Interval on  $projection.CapacityInternalID         = _Interval.CapacityInternalID
                                                                    and $projection.CapacityActiveVersion      = _Interval.CapacityActiveVersion
                                                                    and $projection.CapacityCategoryAllocation = _Interval.CapacityCategoryAllocation
                                                                    and $projection.IntervalEndDate            = _Interval.IntervalEndDate
                                                                    and $projection.WorkCenterInternalID       = _Interval.WorkCenterInternalID
                                                                    and $projection.WorkCenterTypeCode         = _Interval.WorkCenterTypeCode
  /*Association To Header*/
  association to R_WorkCenterTP                        as _Header   on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                                    and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode

{
      //I_WorkCenterCapacityShift_3

  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CapacityCategoryAllocation,
  key CapacityInternalID,
  key CapacityActiveVersion,
  key IntervalEndDate,
  key WeekDay,
  key cast(coalesce(AvailableCapacityShift,'0')as schichtnr preserving type ) as AvailableCapacityShift,
      IntervalStartDate,
      WorkDayRule,
      ShiftDefinition,
      ShiftStartTime,
      ShiftEndTime,
      ShiftDefValidityStartDate,
      ShiftDefValidityEndDate,
      CapacityNumberOfCapacities,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,
      OperatingDurationInSeconds,
      TotOperatingDurationInSeconds,
      CapacityLastChangeDateTime,

      /* Associations */
      @Consumption.hidden: true
      _Interval,
      _Header
}

Learn More