P_WorkCenterAvailableCapacity

Total Available Capacity of Work Center | view: PWRKCTRAVAILCAP | Extraction: Not supported | Component: Capacity Evaluation
Tables used: KAZYKAPAKAKOTC26TC26TT001WTC37ATC37PCRHDCRCA
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 null
ValidityEndDate Field of type DATS
WeekDay Single-Character Flag
AvailableCapacityShift null
CalendarDate null
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Field of type DATS
CalendarDate null
ShiftStartDate Field of type DATS
ShiftStartTime null
ShiftEndDate Field of type DATS
ShiftEndTime null
ValidityBeginDate Field of type DATS
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
CapacityBreakDuration null
CalendarMonth Calendar Month NUM2
CalendarYear Calendar Year NUM4
CalendarWeek Calendar Week NUM2
WorkDays null
ShiftName Shift Definition KAPTPROG
ShiftDefinition Shift Definition KAPTPROG
WorkDayRule null
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
TotOperatingDurationInHours null
CapacityOperatingDuration null
Master Data Relations Join Conditions
Capacity Category
  • Capacity Category
  • Client
  • P_WORKCENTERAVAILABLECAPACITY.CAPACITYCATEGORYCODE == TC26.KAPAR
  • P_WORKCENTERAVAILABLECAPACITY.MANDT == TC26.MANDT
Capacity ID
  • Capacity ID
  • Client
  • P_WORKCENTERAVAILABLECAPACITY.CAPACITYINTERNALID == KAKO.KAPID
  • P_WORKCENTERAVAILABLECAPACITY.MANDT == KAKO.MANDT
Grouping for Shift Definitions and Shift Sequences
  • Client
  • Grouping for Shift Definitions and Shift Sequences
  • P_WORKCENTERAVAILABLECAPACITY.MANDT == TC39A.MANDT
  • P_WORKCENTERAVAILABLECAPACITY.SHIFTGROUPING == TC39A.SCHGRUP
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • P_WORKCENTERAVAILABLECAPACITY.WORKCENTERINTERNALID == CRID.OBJID
  • P_WORKCENTERAVAILABLECAPACITY.WORKCENTERTYPECODE == CRID.OBJTY
  • P_WORKCENTERAVAILABLECAPACITY.MANDT == CRID.MANDT
Plant
  • Plant
  • Client
  • P_WORKCENTERAVAILABLECAPACITY.WORKCENTERPLANT == T001W.WERKS
  • P_WORKCENTERAVAILABLECAPACITY.MANDT == T001W.MANDT