I_WorkCenterAvailableCapacity

Total Available Capacity of Work Center | view: IWRKCTRAVAILCAP | TRAN | Extraction: Not supported | Component: Capacity Evaluation
Tables used: KAZYKAPAKAKOTC26TC26TT001WTC37ATC37TTC37PCRHDCRCA
Column Name Description
WorkCenterInternalID FK Object ID of the resource
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityCategoryAllocation Capacity Category Allocation
CapacityInternalID FK Capacity ID
CapacityActiveVersion Active Version of Available Capacity
ValidityEndDate Field of type DATS
WeekDay Single-Character Flag
AvailableCapacityShift Single-Character Flag
CalendarDate null
Column Name Description
Column Name Description
TotOperatingDurationInHours Capacity expressed in a specific unit of measure
Column Name Description
ValidityEndDate Field of type DATS
CalendarDate null
ShiftStartDate Valid-to date
ShiftStartTime Start Time
ShiftEndDate Valid-to date
ShiftEndTime Start Time
ValidityBeginDate Valid-to date
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
WorkDayRule Indicator: Workdays Show values
Column Name Description Domain name
CapacityBreakDuration Break duration in hours DEC2_2
CalendarMonth Calendar Month NUM2
CalendarYear Calendar Year NUM4
CalendarWeek Calendar Week NUM2
WorkDays null
ShiftName Undefined range (can be used for patch levels) CHAR4
ShiftDefinition Shift Definition KAPTPROG
ShiftDefinitionName Text for Shift Definition TEXT15
FactoryCalendar Factory Calendar ID WFCID
CapacityStartTime Start time in seconds (internal) INT4
CapacityEndTime End Time in Seconds (internal) INT4
CapacityNumberOfCapacities Number of Individual Capacities KAPANZAHL
CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent NUM3
OperatingCapacityDurationInHrs Capacity in hours KAPAZIT_H
Master Data Relations Join Conditions
Capacity ID
  • Capacity ID
  • Client
  • I_WORKCENTERAVAILABLECAPACITY.CAPACITYINTERNALID == KAKO.KAPID
  • I_WORKCENTERAVAILABLECAPACITY.MANDT == KAKO.MANDT
Grouping for Shift Definitions and Shift Sequences
  • Client
  • Grouping for Shift Definitions and Shift Sequences
  • I_WORKCENTERAVAILABLECAPACITY.MANDT == TC39A.MANDT
  • I_WORKCENTERAVAILABLECAPACITY.SHIFTGROUPING == TC39A.SCHGRUP
Object ID of the resource
  • Object ID of the resource
  • Client
  • Object types of the CIM resource
  • I_WORKCENTERAVAILABLECAPACITY.WORKCENTERINTERNALID == CRID.OBJID
  • I_WORKCENTERAVAILABLECAPACITY.MANDT == CRID.MANDT
  • I_WORKCENTERAVAILABLECAPACITY.WORKCENTERTYPECODE == CRID.OBJTY