P_WrkCtrAvailableCapShift

Work Center Available Capacity Shift | view: PWCAVLCAPSHFT | Extraction: Not supported | Component: Work Center
Tables used: KAZYKAPATC36KAKO
Column Name Description
CapacityInternalID FK Capacity ID
AvailableCapacityType FK Available capacity version
ValidityEndDate End Date
WeekDay Week Day
AvailableCapacityShift Shift Number of an Available Capacity
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate End Date
IntervalEndDate null
IntervalStartDate Valid-From Date
CapacityEndDate Field of type DATS
CapacityStartDate Field of type DATS
Column Name Description
WorkDayRule Workday Rule Code Show values
Column Name Description Domain name
CapacityNumberOfCapacities Number of Individual Capacities KAPANZAHL
CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent NUM3
OperatingDurationInSeconds null
BreakDurationInSeconds Cumulative Break Duration in Seconds (internal) INT4
TotOperatingDurationInSeconds null
CapacityStartTimeID Start time in seconds (internal) INT4
CapacityEndTimeID End Time in Seconds (internal) INT4
Master Data Relations Join Conditions
Available capacity version
  • Available capacity version
  • Client
  • P_WRKCTRAVAILABLECAPSHIFT.AVAILABLECAPACITYTYPE == TC36.VERSN
  • P_WRKCTRAVAILABLECAPSHIFT.MANDT == TC36.MANDT
Capacity ID
  • Capacity ID
  • Client
  • P_WRKCTRAVAILABLECAPSHIFT.CAPACITYINTERNALID == KAKO.KAPID
  • P_WRKCTRAVAILABLECAPSHIFT.MANDT == KAKO.MANDT
Grouping for Shift Definitions and Shift Sequences
  • Client
  • Grouping for Shift Definitions and Shift Sequences
  • P_WRKCTRAVAILABLECAPSHIFT.MANDT == TC39A.MANDT
  • P_WRKCTRAVAILABLECAPSHIFT.SHIFTGROUP == TC39A.SCHGRUP