P_WrkCtrAvailableCapInterval

Work Center Active Capacity Interval | view: PWRKCTRCAPINTVL | Extraction: Not supported | Component: Capacity Evaluation
Tables used: KAZY
Column Name Description
CapacityInternalID FK Capacity ID
AvailableCapacityType FK Available capacity version
ValidityEndDate Valid-to date
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Valid-to date
ValidityBeginDate null
Column Name Description
WorkDayRule Workday Rule Code Show values
StdAvailableCapacityIsValid Ind.: Standard Available Capacity is Valid for this Interval Show values
Column Name Description Domain name
CapacityNumberOfCapacities Number of Individual Capacities KAPANZAHL
AvailableCapacityIntervalDurn Duration of an Available Capacity Interval NUM02
CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent NUM3
CapacityNumberOfShifts Number of Shifts in a Day NUM01
Master Data Relations Join Conditions
Available capacity version
  • Client
  • Available capacity version
  • P_WRKCTRAVAILABLECAPINTERVAL.MANDT == TC36.MANDT
  • P_WRKCTRAVAILABLECAPINTERVAL.AVAILABLECAPACITYTYPE == TC36.VERSN
Capacity ID
  • Capacity ID
  • Client
  • P_WRKCTRAVAILABLECAPINTERVAL.CAPACITYINTERNALID == KAKO.KAPID
  • P_WRKCTRAVAILABLECAPINTERVAL.MANDT == KAKO.MANDT
Key for the Shift Sequence
  • Client
  • ?
  • ?
  • Key for the Shift Sequence
  • P_WRKCTRAVAILABLECAPINTERVAL.MANDT == TC38A.MANDT
  • P_WRKCTRAVAILABLECAPINTERVAL.[column in domain "SCHGRUP"] == TC38A.SCHGRUP
  • P_WRKCTRAVAILABLECAPINTERVAL.[column in domain "SCHICHTNR"] == TC38A.SCHNR
  • P_WRKCTRAVAILABLECAPINTERVAL.SHIFTSEQUENCE == TC38A.SPROG