I_WorkCenterCapacity_2

Work Center Capacity | view: IWRKCTRCAP | Extraction: Not supported | Component: Work Center
Tables used: KAKO, KAKT, CRTX, CRHD, CRCA
Column Name Description
WorkCenterInternalID FK Object ID of the resource
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityCategoryAllocation Capacity Category Allocation
CapacityInternalID Capacity ID
Column Name Description
Column Name Description
Column Name Description
LastChangeDate Changed on
ValidityStartDate Start Date
ValidityEndDate End Date
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityIsFinite Indicator: Capacity Relevant to Finite Scheduling Show values
CapacityIsPooled Pooled Capacity Indicator Show values
CapacityHasIndivCapacities Has Individual Capacities Show values
CapacityIsExcldFrmLongTermPlng Indicator: Capacity Excluded From Long-Term Planning Show values
CapIsUsedInMultiOperations Indicator: Several Operations Can Use Capacity Show values
Column Name Description Domain name
LastChangedByUser User Name CHAR12
WorkCenter Work Center ARBPL
ObjectDescription Work Center Text TEXT40
WorkCenterLastChangeDateTime Date and Time of Last Change TZNTSTMPL
Capacity Capacity name KAPNAME
CapacityNumberOfCapacities Number of Individual Capacities KAPANZAHL
CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent NUM3
CapacityBreakDuration Cumulative Break Duration in Seconds (internal) INT4
AuthorizationGroup Authorization Group BRGRU
CapacityStartTimeID Start Time in Seconds (Internal) INT4
CapacityEndTimeID End Time in Seconds (Internal) INT4
CapOverloadThresholdInPercent Overload NUM3
CapacityText Capacity Short Text TEXT40
CapacityLastChangeDateTime Capacity Last Change Date Time TZNTSTMPL
Master Data Relations Join Conditions
Active Version of Available Capacity
  • Client
  • Active Version of Available Capacity
  • I_WORKCENTERCAPACITY_2.MANDT == TC36.MANDT
  • I_WORKCENTERCAPACITY_2.CAPACITYACTIVEVERSION == TC36.VERSN
Capacity Base Unit of Measure
  • Client
  • Capacity Base Unit of Measure
  • I_WORKCENTERCAPACITY_2.MANDT == T006.MANDT
  • I_WORKCENTERCAPACITY_2.CAPACITYBASEQTYUNIT == T006.MSEHI
Capacity Category
  • Capacity Category
  • Client
  • I_WORKCENTERCAPACITY_2.CAPACITYCATEGORYCODE == TC26.KAPAR
  • I_WORKCENTERCAPACITY_2.MANDT == TC26.MANDT
Capacity Unit of Measure
  • Capacity Unit of Measure
  • Client
  • I_WORKCENTERCAPACITY_2.CAPACITYQUANTITYUNIT == T006.MSEHI
  • I_WORKCENTERCAPACITY_2.MANDT == T006.MANDT
Capacity Responsible Planner Group
  • Client
  • Capacity Responsible Planner Group
  • I_WORKCENTERCAPACITY_2.MANDT == TC27.MANDT
  • I_WORKCENTERCAPACITY_2.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
Factory Calendar ID I_WORKCENTERCAPACITY_2.FACTORYCALENDAR == TFACD.IDENT
Formula for Other Capacity Requirements
  • Formula for Other Capacity Requirements
  • Client
  • I_WORKCENTERCAPACITY_2.OTHERCAPREQUIREMENTFORMULA == TC25.IDENT
  • I_WORKCENTERCAPACITY_2.MANDT == TC25.MANDT
Plant
  • Plant
  • Client
  • I_WORKCENTERCAPACITY_2.PLANT == T001W.WERKS
  • I_WORKCENTERCAPACITY_2.MANDT == T001W.MANDT
Formula for Processing Capacity Requirements
  • Client
  • Formula for Processing Capacity Requirements
  • I_WORKCENTERCAPACITY_2.MANDT == TC25.MANDT
  • I_WORKCENTERCAPACITY_2.PROCGCAPREQUIREMENTFORMULA == TC25.IDENT
Referenced Capacity ID
  • Referenced Capacity ID
  • Client
  • I_WORKCENTERCAPACITY_2.REFERENCEDCAPACITYINTERNALID == KAKO.KAPID
  • I_WORKCENTERCAPACITY_2.MANDT == KAKO.MANDT
Formula for Setup Capacity Requirements
  • Formula for Setup Capacity Requirements
  • Client
  • I_WORKCENTERCAPACITY_2.SETUPCAPREQUIREMENTFORMULA == TC25.IDENT
  • I_WORKCENTERCAPACITY_2.MANDT == TC25.MANDT
Grouping for Shift Definitions and Shift Sequences
  • Grouping for Shift Definitions and Shift Sequences
  • Client
  • I_WORKCENTERCAPACITY_2.SHIFTGROUP == TC39A.SCHGRUP
  • I_WORKCENTERCAPACITY_2.MANDT == TC39A.MANDT
Formula for Teardown Capacity Requirements
  • Formula for Teardown Capacity Requirements
  • Client
  • I_WORKCENTERCAPACITY_2.TEARDOWNCAPREQUIREMENTFORMULA == TC25.IDENT
  • I_WORKCENTERCAPACITY_2.MANDT == TC25.MANDT
Work Center Category
  • Work Center Category
  • Client
  • I_WORKCENTERCAPACITY_2.WORKCENTERCATEGORYCODE == TC30.VERWE
  • I_WORKCENTERCAPACITY_2.MANDT == TC30.MANDT
Object ID of the resource
  • Object types of the CIM resource
  • Client
  • Object ID of the resource
  • I_WORKCENTERCAPACITY_2.WORKCENTERTYPECODE == CRID.OBJTY
  • I_WORKCENTERCAPACITY_2.MANDT == CRID.MANDT
  • I_WORKCENTERCAPACITY_2.WORKCENTERINTERNALID == CRID.OBJID