P_WORKCENTERCAPREQS

Load day opr for manufacturing and planned order for Cap | view: PWCCAPREQS | Extraction: Not supported | Component: Capacity Evaluation
Tables used: AFKOKBKOKBEDKBEZJSTOJESTAFVCAFVUAFVVKAKOAUFKPLAFCRHDCRCA
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
OrderID null
Operation Operation/Activity Number
CapacityRequirement FK ID of the Capacity Requirements Record
Material FK Material Number
Column Name Description
Column Name Description
OrderPlannedTotalQty null
Column Name Description
OperationLatestStartDate Latest scheduled start: Execution (date)
OperationLatestStartTime Latest scheduled start: Execution (time)
OperationLatestEndDate Latest Scheduled Wait End Date
OperationLatestEndTime Latest Scheduled Wait End Time
OpLtstSchedldProcgStrtDte Latest Scheduled Start: Processing (Date)
OpLtstSchedldProcgStrtTme Latest Scheduled Start: Processing (Time)
OpLtstSchedldTrdwnStrtDte Latest Scheduled Start: Teardown (Date)
OpLtstSchedldTrdwnStrtTme Latest Scheduled Start: Teardown (Time)
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
CurrentDate null
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityRequirementOrigin Capacity Requirement Origin Show values
OrderCategory Order Category Show values
Column Name Description Domain name
Plant null
MRPController null
WorkCenter Work Center ARBPL
OrderInternalID Order Internal ID AUFPL
OrderType null
OperationPlanningStatusCode null
OpLtstSchedldExecStrtTme null
OpLtstSchedldExecEndTme null
CapacityRequirementsAreDtmnd null
RemainingCapReqOpSegSetupDurn null
RemainingCapReqOpSegProcgDurn null
RemainingCapReqOpSegTrdwnDurn null
OrderStatusCode null
OrderFirmingStatusCode null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_WORKCENTERCAPREQS.BASEUNIT == T006.MSEHI
  • P_WORKCENTERCAPREQS.MANDT == T006.MANDT
Capacity Base Unit of Measure
  • Client
  • Capacity Base Unit of Measure
  • P_WORKCENTERCAPREQS.MANDT == T006.MANDT
  • P_WORKCENTERCAPREQS.CAPACITYBASEQTYUNIT == T006.MSEHI
Capacity ID
  • Capacity ID
  • Client
  • P_WORKCENTERCAPREQS.CAPACITYINTERNALID == KAKO.KAPID
  • P_WORKCENTERCAPREQS.MANDT == KAKO.MANDT
Unit of Measure for Capacity Requirements
  • Client
  • Unit of Measure for Capacity Requirements
  • P_WORKCENTERCAPREQS.MANDT == T006.MANDT
  • P_WORKCENTERCAPREQS.CAPACITYREQUIREMENTUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • P_WORKCENTERCAPREQS.MANDT == MARA.MANDT
  • P_WORKCENTERCAPREQS.MATERIAL == MARA.MATNR
Production Version
  • ?
  • Client
  • ?
  • Production Version
  • P_WORKCENTERCAPREQS.[column in domain "WERKS_D"] == MKAL.WERKS
  • P_WORKCENTERCAPREQS.MANDT == MKAL.MANDT
  • P_WORKCENTERCAPREQS.[column in domain "MATNR"] == MKAL.MATNR
  • P_WORKCENTERCAPREQS.PRODUCTIONVERSION == MKAL.VERID
Work Center Category
  • Client
  • Work Center Category
  • P_WORKCENTERCAPREQS.MANDT == TC30.MANDT
  • P_WORKCENTERCAPREQS.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Object types of the CIM resource
  • Client
  • Object ID of the resource
  • P_WORKCENTERCAPREQS.WORKCENTERTYPECODE == CRID.OBJTY
  • P_WORKCENTERCAPREQS.MANDT == CRID.MANDT
  • P_WORKCENTERCAPREQS.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • ?
  • Client
  • P_WORKCENTERCAPREQS.WORKCENTERRESPONSIBLE == TC24.VERAN
  • P_WORKCENTERCAPREQS.[column in domain "WERKS_D"] == TC24.WERKS
  • P_WORKCENTERCAPREQS.MANDT == TC24.MANDT