I_MntrWrkCtrOrderOperations

Monitor Work Centers - Order Operations | view: IMWCORDOP | TRAN | Extraction: Not supported | Component: Capacity Evaluation

Tables used: AFKO, KBKO, KBED, KBEZ, AFPO, JSTO, JEST, PPH_CFS_UTZ_ASG, AFVC, AFVU, AFVV, MARA, ADCP, ADRC, PLPO, TCA01, KAKO, AUFK, PLAF, T001W, CRTX, MKAL, PPSCH_USER_SIM, T006, T006A, CRHD, MKAL_AEND

🔑 Keys (5)
💰 Amounts
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (4)
Other (22)
🔗 Relations (20)

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

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty	Total planned quantity of an order

Column Name	Description
OperationLatestStartDate	Latest Start Date
OperationLatestStartTime	Latest Start Time
RequirementDate	Basic finish date
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
OperationPlanningStatusCode	Scheduling Status	Show values
OrderStatusCode	Order types based on order statuses	Show values

Column Name	Description	Domain name
Operation	Operation/Activity Number	VORNR
MRPArea	MRP Area	BERID
LastChangeDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
WorkCenter	Work Center	ARBPL
MainWorkCenter	Work Center	ARBPL
ProductionVersion	Production Version	VERID
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
IndustryType	Application of the task list	PLNAW
MainProductionLine	Production Line for Repetitive Manufacturing	ARBPL
LtstSchedldExecStrtDteTme	Latest Start Datetime	TZNTSTMPS
OrderOperationStartDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
OrderOperationEndDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
LtstSchedldExecEndDteTme	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
OrderInternalID	Order Internal ID	AUFPL
NumberOfSOS	Number of Source of Supply	PPH_CFS_SCH_NUMBER_OF_SOS
OrderIsChangedInSimulation	null
ProductionVersIsChgd	null
PlantCurrentDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T006.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.BASEUNIT == T006.MSEHI`
Capacity Category Client Capacity Category	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == TC26.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.CAPACITYCATEGORYCODE == TC26.KAPAR`
Capacity ID Client Capacity ID	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == KAKO.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.CAPACITYINTERNALID == KAKO.KAPID`
Capacity Responsible Planner Group Client Capacity Responsible Planner Group	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == TC27.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR`
Order Number Order Number Order Number Order Number Client	`I_MNTRWRKCTRORDEROPERATIONS.ORDERIDFORUSRINTERFACE == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.ORDERID == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANUFACTURINGORDER == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANDT == AUFK.MANDT`
MRP Controller Group MRP Controller Client Plant	`I_MNTRWRKCTRORDEROPERATIONS.MRPCONTROLLER == T024D.DISPO` `I_MNTRWRKCTRORDEROPERATIONS.MANDT == T024D.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == T024D.WERKS`
Setup group key Client Plant Setup group category Setup group key	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T425.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == T425.WERKS` `I_MNTRWRKCTRORDEROPERATIONS.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP` `I_MNTRWRKCTRORDEROPERATIONS.OPERATIONSETUPGROUP == T425.RFSCH`
Setup group category Client Plant Setup group category	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T426.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == T426.WERKS` `I_MNTRWRKCTRORDEROPERATIONS.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP`
Setup Type Key Client Plant Setup Type Key	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T428.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == T428.WERKS` `I_MNTRWRKCTRORDEROPERATIONS.OPERATIONSETUPTYPE == T428.RASCH`
Order Number Order Number Order Number Order Number Client	`I_MNTRWRKCTRORDEROPERATIONS.ORDERIDFORUSRINTERFACE == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.ORDERID == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANUFACTURINGORDER == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANDT == AUFK.MANDT`
Order Number Order Number Order Number Order Number Client	`I_MNTRWRKCTRORDEROPERATIONS.ORDERIDFORUSRINTERFACE == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.ORDERID == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANUFACTURINGORDER == AUFK.AUFNR` `I_MNTRWRKCTRORDEROPERATIONS.MANDT == AUFK.MANDT`
Planned Order Client Planned Order	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == PLAF.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANNEDORDER == PLAF.PLNUM`
Plant Client Plant	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T001W.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == T001W.WERKS`
Product Number Client Product Number	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == MARA.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PRODUCT == MARA.MATNR`
Material Group Client Product Group	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == T023.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PRODUCTGROUP == T023.MATKL`
Work Center Category Client Work Center Category	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == TC30.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.WORKCENTERCATEGORYCODE == TC30.VERWE`
Object ID of the resource Client Object ID of the resource ?	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == CRID.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.WORKCENTERINTERNALID == CRID.OBJID` `I_MNTRWRKCTRORDEROPERATIONS.[column in domain "CR_OBJTY"] == CRID.OBJTY`

Other Relations \| to Master Data Relations ↑	Join Conditions
Person Responsible for the Work Center Client Plant Person Responsible for the Work Center	`I_MNTRWRKCTRORDEROPERATIONS.MANDT == TC24.MANDT` `I_MNTRWRKCTRORDEROPERATIONS.PLANT == TC24.WERKS` `I_MNTRWRKCTRORDEROPERATIONS.WORKCENTERRESPONSIBLE == TC24.VERAN`