P_WorkCenterAllCapacity

All Capacities of Work Center | view: PWORKCTRALLCAP | Extraction: Not supported | Component: Capacity Evaluation
Tables used: KAKOCRTXCRHDCRCA
Column Name Description
WorkCenterInternalID FK Object ID of the resource
WorkCenterTypeCode Object types of the CIM resource
CapacityInternalID FK Capacity ID
CapacityCategoryAllocation Capacity Category Allocation
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
WorkCenter Work Center ARBPL
WorkCenterDesc Work Center Text TEXT40
Master Data Relations Join Conditions
Capacity Category
  • Client
  • Capacity Category
  • P_WORKCENTERALLCAPACITY.MANDT == TC26.MANDT
  • P_WORKCENTERALLCAPACITY.CAPACITYCATEGORYCODE == TC26.KAPAR
Capacity ID
  • Client
  • Capacity ID
  • P_WORKCENTERALLCAPACITY.MANDT == KAKO.MANDT
  • P_WORKCENTERALLCAPACITY.CAPACITYINTERNALID == KAKO.KAPID
Plant
  • Client
  • Plant
  • P_WORKCENTERALLCAPACITY.MANDT == T001W.MANDT
  • P_WORKCENTERALLCAPACITY.PLANT == T001W.WERKS
Production Supply Area
  • Client
  • Production Supply Area
  • Plant
  • P_WORKCENTERALLCAPACITY.MANDT == PVBE.MANDT
  • P_WORKCENTERALLCAPACITY.SUPPLYAREA == PVBE.PRVBE
  • P_WORKCENTERALLCAPACITY.PLANT == PVBE.WERKS
Work Center Category
  • Client
  • Work Center Category
  • P_WORKCENTERALLCAPACITY.MANDT == TC30.MANDT
  • P_WORKCENTERALLCAPACITY.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Object ID of the resource
  • Client
  • Object types of the CIM resource
  • P_WORKCENTERALLCAPACITY.WORKCENTERINTERNALID == CRID.OBJID
  • P_WORKCENTERALLCAPACITY.MANDT == CRID.MANDT
  • P_WORKCENTERALLCAPACITY.WORKCENTERTYPECODE == CRID.OBJTY
Work Center Usage in Bill of Operations
  • Work Center Usage in Bill of Operations
  • Client
  • P_WORKCENTERALLCAPACITY.WORKCENTERUSAGE == TC23.PLANV
  • P_WORKCENTERALLCAPACITY.MANDT == TC23.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Client
  • Plant
  • P_WORKCENTERALLCAPACITY.WORKCENTERRESPONSIBLE == TC24.VERAN
  • P_WORKCENTERALLCAPACITY.MANDT == TC24.MANDT
  • P_WORKCENTERALLCAPACITY.PLANT == TC24.WERKS