A_WorkCenterCapDayOp

Daily Operations Capacity | view: AWCCAPDAYOP | TRAN | Extraction: Not supported | Component: Work Center
Tables used: AFKOKBKOAFKOKBEDKBEZAFKOAFPOKBEDKBEZJSTOJESTAFVCAFVUAFVVKAKOAUFKT003PPLAFCRTXTJ02TCRHDCRCA
Column Name Description
Plant FK Plant
MRPController FK MRP controller for the order
WorkCenter Work Center
CapacityInternalID FK Capacity ID
CapacityRequirement FK ID of the Capacity Requirements Record
Material FK Material Number for Order
OrderID null
Operation Operation/Activity Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty Total Order Quantity
Column Name Description
Column Name Description
CapacityRequirementOrigin Capacity Requirement Origin Show values
Column Name Description Domain name
WorkCenterDesc Work Center Text TEXT40
OrderTypeName Planned Order Type Name TEXT60
OperationPlanningStatusText Short Text for Fixed Values DDTEXT
OperationPlanningStatusCode null
OperationLatestStartDate Character field, 8 characters long CHAR8
OperationLatestStartTime Character field of length 6 CHAR6
OperationLatestEndDate Character field, 8 characters long CHAR8
OperationLatestEndTime Character field of length 6 CHAR6
OrderStatusText Object status TEXT30
OrderStatusCode null
OrderFirmingStatusText Short Text for Fixed Values DDTEXT
OpLtstSchedldProcgStrtDte Character field, 8 characters long CHAR8
OpLtstSchedldProcgStrtTme Character field of length 6 CHAR6
OpLtstSchedldTrdwnStrtDte Character field, 8 characters long CHAR8
OpLtstSchedldTrdwnStrtTme Character field of length 6 CHAR6
RemainingCapReqOpSegSetupDurn null
RemainingCapReqOpSegProcgDurn null
RemainingCapReqOpSegTrdwnDurn null
CapacityRequirementsAreDtmnd null
OrderInternalID Order Internal ID AUFPL
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • A_WORKCENTERCAPDAYOP.MANDT == T006.MANDT
  • A_WORKCENTERCAPDAYOP.BASEUNIT == T006.MSEHI
Capacity ID
  • Client
  • Capacity ID
  • A_WORKCENTERCAPDAYOP.MANDT == KAKO.MANDT
  • A_WORKCENTERCAPDAYOP.CAPACITYINTERNALID == KAKO.KAPID
Material Number for Order
  • Client
  • Material Number for Order
  • A_WORKCENTERCAPDAYOP.MANDT == MARA.MANDT
  • A_WORKCENTERCAPDAYOP.MATERIAL == MARA.MATNR
MRP Controller Group
  • Client
  • MRP controller for the order
  • Plant
  • A_WORKCENTERCAPDAYOP.MANDT == T024D.MANDT
  • A_WORKCENTERCAPDAYOP.MRPCONTROLLER == T024D.DISPO
  • A_WORKCENTERCAPDAYOP.PLANT == T024D.WERKS
Order Type
  • Client
  • Order Type
  • A_WORKCENTERCAPDAYOP.MANDT == T003O.CLIENT
  • A_WORKCENTERCAPDAYOP.ORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • A_WORKCENTERCAPDAYOP.MANDT == T001W.MANDT
  • A_WORKCENTERCAPDAYOP.PLANT == T001W.WERKS
Production Version
  • Client
  • Material Number for Order
  • ?
  • Production Version
  • A_WORKCENTERCAPDAYOP.MANDT == MKAL.MANDT
  • A_WORKCENTERCAPDAYOP.MATERIAL == MKAL.MATNR
  • A_WORKCENTERCAPDAYOP.[column in domain "WERKS_D"] == MKAL.WERKS
  • A_WORKCENTERCAPDAYOP.PRODUCTIONVERSION == MKAL.VERID
Work Center Category
  • Client
  • Work Center Category
  • A_WORKCENTERCAPDAYOP.MANDT == TC30.MANDT
  • A_WORKCENTERCAPDAYOP.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • A_WORKCENTERCAPDAYOP.MANDT == CRID.MANDT
  • A_WORKCENTERCAPDAYOP.WORKCENTERINTERNALID == CRID.OBJID
  • A_WORKCENTERCAPDAYOP.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Client
  • Person Responsible for the Work Center
  • Plant
  • A_WORKCENTERCAPDAYOP.MANDT == TC24.MANDT
  • A_WORKCENTERCAPDAYOP.WORKCENTERRESPONSIBLE == TC24.VERAN
  • A_WORKCENTERCAPDAYOP.PLANT == TC24.WERKS