I_MaintOrderOperationData

Maintenance Order Operation Data | view: IPMORDOPERDATA | TRAN | Extraction: Full or Incremental | Component: Maintenance Orders
Tables used: AFKO, AFIH, AFVC, AFVV, JSTO, JEST, ILOA, AUFK, CRHD
Column Name Description
MaintenanceOrder FK Order Number
MaintOrderOperationCounter 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
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderOperation null
MaintenanceOrderSubOperation Suboperation 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
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
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
  • Client
  • Assembly
  • I_MAINTORDEROPERATIONDATA.MANDT == MARA.MANDT
  • I_MAINTORDEROPERATIONDATA.ASSEMBLY == MARA.MATNR
Activity Type
  • Activity Type
  • ?
  • Client
  • ?
  • I_MAINTORDEROPERATIONDATA.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERATIONDATA.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTORDEROPERATIONDATA.MANDT == CSLA.MANDT
  • I_MAINTORDEROPERATIONDATA.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Element
  • Cost Element
  • Client
  • ?
  • I_MAINTORDEROPERATIONDATA.COSTELEMENT == CSKA.KSTAR
  • I_MAINTORDEROPERATIONDATA.MANDT == CSKA.MANDT
  • I_MAINTORDEROPERATIONDATA.[column in domain "KTOPL"] == CSKA.KTOPL
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDEROPERATIONDATA.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDEROPERATIONDATA.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTORDEROPERATIONDATA.MANDT == IFLOT.MANDT
  • I_MAINTORDEROPERATIONDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTORDEROPERATIONDATA.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDEROPERATIONDATA.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDEROPERATIONDATA.MANDT == T003O.CLIENT
Location Plant
  • Client
  • Location Plant
  • I_MAINTORDEROPERATIONDATA.MANDT == T001W.MANDT
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_MAINTORDEROPERATIONDATA.MANDT == ILOA.MANDT
  • I_MAINTORDEROPERATIONDATA.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Material Group
  • Material Group
  • Client
  • I_MAINTORDEROPERATIONDATA.MATERIALGROUP == T023.MATKL
  • I_MAINTORDEROPERATIONDATA.MANDT == T023.MANDT
Assembly
  • Assembly
  • Client
  • I_MAINTORDEROPERATIONDATA.OPERATIONASSEMBLY == MARA.MATNR
  • I_MAINTORDEROPERATIONDATA.MANDT == MARA.MANDT
Control key
  • ?
  • Client
  • Control key
  • I_MAINTORDEROPERATIONDATA.[column in domain "PLNAW"] == T430.PLNAW
  • I_MAINTORDEROPERATIONDATA.MANDT == T430.MANDT
  • I_MAINTORDEROPERATIONDATA.OPERATIONCONTROLKEY == T430.STEUS
Unit for work
  • Unit for work
  • Client
  • I_MAINTORDEROPERATIONDATA.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
  • I_MAINTORDEROPERATIONDATA.MANDT == T006.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MAINTORDEROPERATIONDATA.MANDT == T006.MANDT
  • I_MAINTORDEROPERATIONDATA.OPERATIONQUANTITYUNIT == T006.MSEHI
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • I_MAINTORDEROPERATIONDATA.OPERATIONWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDEROPERATIONDATA.MANDT == CRID.MANDT
  • I_MAINTORDEROPERATIONDATA.[column in domain "CR_OBJTY"] == CRID.OBJTY
Plant
  • Plant
  • Client
  • I_MAINTORDEROPERATIONDATA.WORKCENTERPLANT == T001W.WERKS
  • I_MAINTORDEROPERATIONDATA.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDEROPERATIONDATA.MANDT == T024I.MANDT
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTORDEROPERATIONDATA.MANDT == T399I.MANDT
  • I_MAINTORDEROPERATIONDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK