C_WrkCtrMntrOrderDetails

Work Center Monitor Order Details | view: CORDERDETAILS | Extraction: Not supported | Component: Gantt
Tables used: AFKO, KBKO, KBED, KBEZ, AFPO, AFVC, AFFL, JSTO, JEST, PPH_CFS_UTZ_ASG, AFVU, AFVV, MARA, ADCP, ADRC, PLPO, TCA01, MAPL, MARC, KAKO, TC26T, AUFK, MDMA, T438A, PLAF, T001W, CRTX, MKAL, MAKT, PPSCH_USER_SIM, T006, T006A, CRHD, MKAL_AEND, SDM_AOR
Column Name Description
SimulationSessionID Simulation Session ID
OrderID FK Order Number
CapacityRequirementItem Capacity Requirement Item
CapacityRqmtItemCapacity Individual Capacity of a Capacity Requirement Item
OrderCategory Order Category Show values
WorkCenter Work Center
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Total planned quantity of an order
Column Name Description
OperationLatestStartDate Latest Start Date
OperationLatestStartTime Latest Start Time
OperationLatestEndDate Latest End Date
OperationLatestEndTime Latest End Time
Column Name Description
OrderCategory Order Category Show values
WorkCenterTypeCode Object types of the CIM resource Show values
OrderStatusCode Order types based on order statuses Show values
WorkCenterIsPacemaker Checkbox Show values
Column Name Description Domain name
MRPArea MRP Area BERID
WorkCenterText Work Center Text TEXT40
OrderCategoryName Short Text for Fixed Values DDTEXT
ProductDescription Product Description TEXT40
Operation Operation/Activity Number VORNR
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MainWorkCenter Work Center ARBPL
CapacityCategoryName Description of a Capacity Category TEXT20
ProductionVersion Production Version VERID
ProductionVersionText Short Text for Production Version TEXT40
ProductionLine Production Line for Repetitive Manufacturing ARBPL
MainProductionLine Production Line for Repetitive Manufacturing ARBPL
LtstSchedldExecStrtDteTme Latest Start Datetime TZNTSTMPS
OrderOperationStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OrderOperationEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RequirementDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UnitOfMeasure_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
RemainingCapReqExecutionDurn Required Capacity in Float PPH_CFS_SCH_REQUIRED_CAP_FLTP
SchedldOrdStartDteTme Latest Start Datetime TZNTSTMPS
SchedldOrdEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProductionVersIsChgd null
WorkCenterIsAlternate null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_WRKCTRMNTRORDERDETAILS.BASEUNIT == T006.MSEHI
  • C_WRKCTRMNTRORDERDETAILS.MANDT == T006.MANDT
Capacity Category
  • Capacity Category
  • Client
  • C_WRKCTRMNTRORDERDETAILS.CAPACITYCATEGORYCODE == TC26.KAPAR
  • C_WRKCTRMNTRORDERDETAILS.MANDT == TC26.MANDT
Capacity ID
  • Capacity ID
  • Client
  • C_WRKCTRMNTRORDERDETAILS.CAPACITYINTERNALID == KAKO.KAPID
  • C_WRKCTRMNTRORDERDETAILS.MANDT == KAKO.MANDT
Capacity Responsible Planner Group
  • Client
  • Capacity Responsible Planner Group
  • C_WRKCTRMNTRORDERDETAILS.MANDT == TC27.MANDT
  • C_WRKCTRMNTRORDERDETAILS.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
Order Number
  • Order Number
  • Order Number
  • Client
  • C_WRKCTRMNTRORDERDETAILS.ORDERID == AUFK.AUFNR
  • C_WRKCTRMNTRORDERDETAILS.MANUFACTURINGORDER == AUFK.AUFNR
  • C_WRKCTRMNTRORDERDETAILS.MANDT == AUFK.MANDT
MRP Controller Group
  • MRP Controller
  • Plant
  • Client
  • C_WRKCTRMNTRORDERDETAILS.MRPCONTROLLER == T024D.DISPO
  • C_WRKCTRMNTRORDERDETAILS.PLANT == T024D.WERKS
  • C_WRKCTRMNTRORDERDETAILS.MANDT == T024D.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • C_WRKCTRMNTRORDERDETAILS.ORDERID == AUFK.AUFNR
  • C_WRKCTRMNTRORDERDETAILS.MANUFACTURINGORDER == AUFK.AUFNR
  • C_WRKCTRMNTRORDERDETAILS.MANDT == AUFK.MANDT
Planned Order
  • Planned Order
  • Client
  • C_WRKCTRMNTRORDERDETAILS.PLANNEDORDER == PLAF.PLNUM
  • C_WRKCTRMNTRORDERDETAILS.MANDT == PLAF.MANDT
Plant
  • Plant
  • Client
  • C_WRKCTRMNTRORDERDETAILS.PLANT == T001W.WERKS
  • C_WRKCTRMNTRORDERDETAILS.MANDT == T001W.MANDT
Product Number
  • Client
  • Product Number
  • C_WRKCTRMNTRORDERDETAILS.MANDT == MARA.MANDT
  • C_WRKCTRMNTRORDERDETAILS.PRODUCT == MARA.MATNR
Material Group
  • Product Group
  • Client
  • C_WRKCTRMNTRORDERDETAILS.PRODUCTGROUP == T023.MATKL
  • C_WRKCTRMNTRORDERDETAILS.MANDT == T023.MANDT
Work Center Category
  • Work Center Category
  • Client
  • C_WRKCTRMNTRORDERDETAILS.WORKCENTERCATEGORYCODE == TC30.VERWE
  • C_WRKCTRMNTRORDERDETAILS.MANDT == TC30.MANDT
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • C_WRKCTRMNTRORDERDETAILS.MANDT == CRID.MANDT
  • C_WRKCTRMNTRORDERDETAILS.WORKCENTERINTERNALID == CRID.OBJID
  • C_WRKCTRMNTRORDERDETAILS.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Plant
  • Client
  • C_WRKCTRMNTRORDERDETAILS.WORKCENTERRESPONSIBLE == TC24.VERAN
  • C_WRKCTRMNTRORDERDETAILS.PLANT == TC24.WERKS
  • C_WRKCTRMNTRORDERDETAILS.MANDT == TC24.MANDT