C_WorkCenterCapOverviewTP

Manage WorkCenter Capacity | view: CWCCAPOVWTP | Extraction: Not supported | Component: Capacity Evaluation
Tables used: MARAADCPADRCPLPOMAPLPLASKAKOTC26TC26TKAKTMARCT430T001WCRTXMKALCRHDCRCAMKAL_AENDSDM_AOR
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
Column Name Description
Column Name Description
Column Name Description
WorkCenterCapFirstOverLoadDte Date
WorkCenterCapFirstCritlLoadDte Date
CurrentPlantDate null
HorizonStartDate Field of type DATS
HorizonEndDate Field of type DATS
CapEvalStartDate Field of type DATS
CapacityEvaluationHorizonDate Field of type DATS
CapacityEvaluationOverdueDate Field of type DATS
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityIsPooled Pooled Capacity Indicator Show values
ShiftTableHasChanged Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
WorkCenterEvaluationHorizon Undefined range (can be used for patch levels) CHAR4
WorkCenterDesc Work Center Text
WorkCenterCumltvLoadInTmePerd Minimum time in microseconds
WorkCenterMaxUtilznInTimePerd Minimum time in microseconds
WorkCenterCapFirstOverloadWk Character Field of Length 12
WorkCenterCapacityBacklogInHrs Minimum time in microseconds
WorkCenterTotCapInTimePeriod Minimum time in microseconds
Capacity Capacity Short Text
WorkCenterMinUtilznInTmePeriod Minimum time in microseconds
WorkCenterCapFirstCritlLoadWk Character Field of Length 12
WorkCenterAvgUtilznInTimePerd Minimum time in microseconds
WorkCenterTotAvailCapInTmePerd Minimum time in microseconds
WorkCenterTotUtilznInTmePerd Minimum time in microseconds
CapacityEvaluationTimePeriod Two digit number NUMC2
WorkCenterAvailableCapacity Minimum time in microseconds DEC10_2
WorkCenterCapacityRequirement Minimum time in microseconds DEC10_2
WorkCenter Work Center
CapacityRequirementOrigin Values for Domains: Single Value/Lower Limit
OperationPlanningStatusCode Values for Domains: Single Value/Lower Limit
OrderStatusCode R/2 table
Criticality null
WorkCenterAvgUtilznCriticality null
PlantName Plant Name TEXT30
CapacityCategoryName Description of a Capacity Category TEXT20
WrkCtrIsUndrMaintInTmePerd General Flag
WrkCtrMaintOrdAvailabilityTxt Character Field with Length 10
WorkCenterFltrCodeInTmePerd 3-Byte field
WorkCenterGroup Name of Hierarchy
WorkCenterGroupType Work Center Group Type
WorkCenterGroupDescription null
CapEvalBucketType Single-Character Flag
Master Data Relations Join Conditions
Capacity Category
  • Capacity Category
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.CAPACITYCATEGORYCODE == TC26.KAPAR
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == TC26.MANDT
Capacity ID
  • Capacity ID
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.CAPACITYINTERNALID == KAKO.KAPID
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == KAKO.MANDT
Capacity Responsible Planner Group
  • Capacity Responsible Planner Group
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == TC27.MANDT
Plant
  • Plant
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.PLANT == T001W.WERKS
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == T001W.MANDT
Work Center Category
  • Work Center Category
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.WORKCENTERCATEGORYCODE == TC30.VERWE
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == TC30.MANDT
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.WORKCENTERINTERNALID == CRID.OBJID
  • C_WORKCENTERCAPOVERVIEWTP.WORKCENTERTYPECODE == CRID.OBJTY
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == CRID.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Plant
  • Client
  • C_WORKCENTERCAPOVERVIEWTP.WORKCENTERRESPONSIBLE == TC24.VERAN
  • C_WORKCENTERCAPOVERVIEWTP.PLANT == TC24.WERKS
  • C_WORKCENTERCAPOVERVIEWTP.MANDT == TC24.MANDT