A_WorkCenterCapacityShift

DDL: A_WORKCENTERCAPACITYSHIFT SQL: AWRKCTRCAPSHIFT Type: view COMPOSITE

Capacity Shift

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

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityShift Shift from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAPSHIFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Capacity Shift view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityShift WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacityShift WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacityShift CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityShift CapacityInternalID
KEY CapacityActiveVersion I_WorkCenterCapacityShift CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityShift IntervalEndDate
KEY WeekDay I_WorkCenterCapacityShift WeekDay
KEY AvailableCapacityShift I_WorkCenterCapacityShift AvailableCapacityShift
WorkCenter I_WorkCenterCapacityShift WorkCenter
Plant I_WorkCenterCapacityShift Plant
IntervalStartDate I_WorkCenterCapacityShift IntervalStartDate
ShiftName I_WorkCenterCapacityShift ShiftName
ShiftDefValidityStart I_WorkCenterCapacityShift ShiftDefValidityStart
ShiftDefValidityEnd I_WorkCenterCapacityShift ShiftDefValidityEnd
ShiftStartTime I_WorkCenterCapacityShift ShiftStartTime
ShiftEndTime I_WorkCenterCapacityShift ShiftEndTime
CapacityBreakDuration I_WorkCenterCapacityShift CapacityBreakDuration
CapacityPlanUtilizationPercent I_WorkCenterCapacityShift CapacityPlanUtilizationPercent
CapacityNumberOfCapacities I_WorkCenterCapacityShift CapacityNumberOfCapacities
TotOperatingDurationInHours I_WorkCenterCapacityShift TotOperatingDurationInHours
TotOperationDurationUnit I_WorkCenterCapacityShift TotOperationDurationUnit 
@AbapCatalog.sqlViewName: 'AWRKCTRCAPSHIFT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Capacity Shift'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true

define view A_WorkCenterCapacityShift
  as select from I_WorkCenterCapacityShift as Shift

{

  key Shift.WorkCenterInternalID                                                                         as WorkCenterInternalID,
  key Shift.WorkCenterTypeCode                                                                           as WorkCenterTypeCode,
  key Shift.CapacityCategoryAllocation                                                                   as CapacityCategoryAllocation,
  key Shift.CapacityInternalID                                                                           as CapacityInternalID,
  key Shift.CapacityActiveVersion                                                                        as CapacityActiveVersion,
  key Shift.IntervalEndDate                                                                              as IntervalEndDate,
  key Shift.WeekDay                                                                                      as WeekDay,
  key Shift.AvailableCapacityShift                                                                       as AvailableCapacityShift,
      Shift.WorkCenter                                                                                   as WorkCenter,
      Shift.Plant                                                                                        as Plant,
      Shift.IntervalStartDate                                                                            as IntervalStartDate,
      Shift.ShiftName                                                                                    as ShiftName,
      Shift.ShiftDefValidityStart                                                                        as ShiftDefValidityStart,
      Shift.ShiftDefValidityEnd                                                                          as ShiftDefValidityEnd,
      Shift.ShiftStartTime                                                                               as ShiftStartTime,
      Shift.ShiftEndTime                                                                                 as ShiftEndTime,
      Shift.CapacityBreakDuration                                                                        as CapacityBreakDuration,
      Shift.CapacityPlanUtilizationPercent                                                               as CapacityPlanUtilizationPercent,
      Shift.CapacityNumberOfCapacities                                                                   as CapacityNumberOfCapacities,
      @Semantics.quantity.unitOfMeasure: 'TotOperationDurationUnit'
      Shift.TotOperatingDurationInHours                                                                  as TotOperatingDurationInHours,
      @Semantics.unitOfMeasure: true      
      Shift.TotOperationDurationUnit                                                                     as TotOperationDurationUnit
}
where
  IntervalEndDate >= $session.system_date

Learn More