I_MaintOrderOperation_DEX

Maintenance Order Operation Data | view: IPMORDOPERDEX | TRAN | Extraction: Full or Incremental | Component: Maintenance Orders
Tables used: AFKO, AFIH, AFVC, AFVV, JSTO, JEST, ILOA, AUFK, CRHD
Column Name Description
MaintOrderRoutingNumber Routing number of operations in the order
MaintenanceOrderRoutingNode Internal Identifier of an Operation or Activity
Column Name Description
Column Name Description
📏 Unit for work (OperationPlannedWorkUnit):
OperationPlannedWork Work involved in the activity
ConfirmationTotalQuantity Actual work
📏 Base Unit of Measure (OperationQuantityUnit):
OperationQuantity Operation Quantity in Unit of Measure of Order
Column Name Description
CreationDate Created On
Column Name Description
Column Name Description Domain name
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintenanceOrderOperation null
MaintenanceOrderSubOperation Operation/Activity Number VORNR
OperationPersonResponsible Personnel number PERNR
OperationDescription Operation Short Text TEXT40
WorkCenter Work Center ARBPL
OperationUnloadingPointName Unloading Point TEXT25
PurchaseRequisition Purchase Requisition Number BANFN
IsDeleted Object is deleted CHAR1
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
OperationWorkCenterTypeCode null
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTORDEROPERATION_DEX.ASSEMBLY == MARA.MATNR
  • I_MAINTORDEROPERATION_DEX.MANDT == MARA.MANDT
Application of the task list
  • Application of the task list
  • Client
  • I_MAINTORDEROPERATION_DEX.BILLOFOPERATIONSAPPLICATION == TCA09.PLNAW
  • I_MAINTORDEROPERATION_DEX.MANDT == TCA09.MANDT
Activity Type
  • Activity Type
  • ?
  • ?
  • Client
  • I_MAINTORDEROPERATION_DEX.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERATION_DEX.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MAINTORDEROPERATION_DEX.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTORDEROPERATION_DEX.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Client
  • Cost Element
  • I_MAINTORDEROPERATION_DEX.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_MAINTORDEROPERATION_DEX.MANDT == CSKA.MANDT
  • I_MAINTORDEROPERATION_DEX.COSTELEMENT == CSKA.KSTAR
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDEROPERATION_DEX.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDEROPERATION_DEX.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTORDEROPERATION_DEX.MANDT == IFLOT.MANDT
  • I_MAINTORDEROPERATION_DEX.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTORDEROPERATION_DEX.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDEROPERATION_DEX.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDEROPERATION_DEX.MANDT == T003O.CLIENT
Location Plant
  • Location Plant
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEPLANT == T001W.WERKS
  • I_MAINTORDEROPERATION_DEX.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_MAINTORDEROPERATION_DEX.MANDT == ILOA.MANDT
Material Group
  • Material Group
  • Client
  • I_MAINTORDEROPERATION_DEX.MATERIALGROUP == T023.MATKL
  • I_MAINTORDEROPERATION_DEX.MANDT == T023.MANDT
Assembly
  • Assembly
  • Client
  • I_MAINTORDEROPERATION_DEX.OPERATIONASSEMBLY == MARA.MATNR
  • I_MAINTORDEROPERATION_DEX.MANDT == MARA.MANDT
Control key
  • Control key
  • Application of the task list
  • Client
  • I_MAINTORDEROPERATION_DEX.OPERATIONCONTROLKEY == T430.STEUS
  • I_MAINTORDEROPERATION_DEX.BILLOFOPERATIONSAPPLICATION == T430.PLNAW
  • I_MAINTORDEROPERATION_DEX.MANDT == T430.MANDT
Unit for work
  • Unit for work
  • Client
  • I_MAINTORDEROPERATION_DEX.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
  • I_MAINTORDEROPERATION_DEX.MANDT == T006.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MAINTORDEROPERATION_DEX.OPERATIONQUANTITYUNIT == T006.MSEHI
  • I_MAINTORDEROPERATION_DEX.MANDT == T006.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_MAINTORDEROPERATION_DEX.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDEROPERATION_DEX.OPERATIONWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDEROPERATION_DEX.MANDT == CRID.MANDT
Plant
  • Client
  • Plant
  • I_MAINTORDEROPERATION_DEX.MANDT == T001W.MANDT
  • I_MAINTORDEROPERATION_DEX.WORKCENTERPLANT == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDEROPERATION_DEX.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDEROPERATION_DEX.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDEROPERATION_DEX.MANDT == T399I.MANDT