C_WrkCtrAvailableCapacityTP

Total Available Capacity of Work Center | view: CWCAVAILCAPTP | 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
CalendarDate null
ValidityEndDate Field of type DATS
CapacityActiveVersion Active Version of Available Capacity
WeekDay Single-Character Flag
AvailableCapacityShift Single-Character Flag
Column Name Description
Column Name Description
📏 Unit (WorkCenterCapacityUnit):
TotOperatingDurationInHours Capacity expressed in a specific unit of measure
Column Name Description
CalendarDate null
ValidityEndDate Field of type DATS
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
ShiftStatusCode Change Status for an Interval/Shift Show values
Column Name Description Domain name
ShiftName Undefined range (can be used for patch levels)
CapacityBreakDuration Break duration in hours
CalendarMonth Calendar Month NUM2
CalendarYear Calendar Year NUM4
CalendarWeek Calendar Week NUM2
WorkDays null
ShiftDefinitionName Text for Shift Definition TEXT15
ShiftDefinition Shift Definition KAPTPROG
FactoryCalendar Factory Calendar ID WFCID
CapacityStartTime Start time in seconds (internal) INT4
CapacityEndTime End Time in Seconds (internal) INT4
CapacityNumberOfCapacities Number of Individual Capacities
CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent
ShiftStatusText Character Field with Length 10 CHAR10
OperatingCapacityDurationInHrs Capacity in hours
Master Data Relations Join Conditions
Capacity ID
  • Capacity ID
  • Client
  • C_WRKCTRAVAILABLECAPACITYTP.CAPACITYINTERNALID == KAKO.KAPID
  • C_WRKCTRAVAILABLECAPACITYTP.MANDT == KAKO.MANDT
Grouping for Shift Definitions and Shift Sequences
  • Grouping for Shift Definitions and Shift Sequences
  • Client
  • C_WRKCTRAVAILABLECAPACITYTP.SHIFTGROUPING == TC39A.SCHGRUP
  • C_WRKCTRAVAILABLECAPACITYTP.MANDT == TC39A.MANDT
Object ID of the resource
  • Object types of the CIM resource
  • Object ID of the resource
  • Client
  • C_WRKCTRAVAILABLECAPACITYTP.WORKCENTERTYPECODE == CRID.OBJTY
  • C_WRKCTRAVAILABLECAPACITYTP.WORKCENTERINTERNALID == CRID.OBJID
  • C_WRKCTRAVAILABLECAPACITYTP.MANDT == CRID.MANDT