A_WorkCenterCapPplineOp

Queued Operations Capacity | view: AWCCAPPPLINEOP | 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
OrderCategory Order Category Show values
Column Name Description Domain name
WorkCenterDesc Work Center Text TEXT40
OrderTypeName Planned Order Type Name TEXT60
OrderCategoryName Planned Order Category Name DDTEXT
OperationPlanningStatusCode null
OperationPlanningStatusText Short Text for Fixed Values DDTEXT
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
OrderStatusCode null
OrderStatusText Object status TEXT30
OrderStatusShortText Individual status of an object (short form) TEXT4
OrderFirmingStatusCode Single-Character Flag CHAR1
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
RemainingCapReqExecutionDurn null
OrderInternalID Order Internal ID AUFPL
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • A_WORKCENTERCAPPPLINEOP.BASEUNIT == T006.MSEHI
  • A_WORKCENTERCAPPPLINEOP.MANDT == T006.MANDT
Capacity ID
  • Client
  • Capacity ID
  • A_WORKCENTERCAPPPLINEOP.MANDT == KAKO.MANDT
  • A_WORKCENTERCAPPPLINEOP.CAPACITYINTERNALID == KAKO.KAPID
Material Number for Order
  • Material Number for Order
  • Client
  • A_WORKCENTERCAPPPLINEOP.MATERIAL == MARA.MATNR
  • A_WORKCENTERCAPPPLINEOP.MANDT == MARA.MANDT
MRP Controller Group
  • MRP controller for the order
  • Plant
  • Client
  • A_WORKCENTERCAPPPLINEOP.MRPCONTROLLER == T024D.DISPO
  • A_WORKCENTERCAPPPLINEOP.PLANT == T024D.WERKS
  • A_WORKCENTERCAPPPLINEOP.MANDT == T024D.MANDT
Order Type
  • Order Type
  • Client
  • A_WORKCENTERCAPPPLINEOP.ORDERTYPE == T003O.AUART
  • A_WORKCENTERCAPPPLINEOP.MANDT == T003O.CLIENT
Plant
  • Plant
  • Client
  • A_WORKCENTERCAPPPLINEOP.PLANT == T001W.WERKS
  • A_WORKCENTERCAPPPLINEOP.MANDT == T001W.MANDT
Production Version
  • Material Number for Order
  • ?
  • Production Version
  • Client
  • A_WORKCENTERCAPPPLINEOP.MATERIAL == MKAL.MATNR
  • A_WORKCENTERCAPPPLINEOP.[column in domain "WERKS_D"] == MKAL.WERKS
  • A_WORKCENTERCAPPPLINEOP.PRODUCTIONVERSION == MKAL.VERID
  • A_WORKCENTERCAPPPLINEOP.MANDT == MKAL.MANDT
Work Center Category
  • Client
  • Work Center Category
  • A_WORKCENTERCAPPPLINEOP.MANDT == TC30.MANDT
  • A_WORKCENTERCAPPPLINEOP.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • A_WORKCENTERCAPPPLINEOP.MANDT == CRID.MANDT
  • A_WORKCENTERCAPPPLINEOP.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • A_WORKCENTERCAPPPLINEOP.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Plant
  • Client
  • Person Responsible for the Work Center
  • A_WORKCENTERCAPPPLINEOP.PLANT == TC24.WERKS
  • A_WORKCENTERCAPPPLINEOP.MANDT == TC24.MANDT
  • A_WORKCENTERCAPPPLINEOP.WORKCENTERRESPONSIBLE == TC24.VERAN