I_MaintenanceOrderOperation

Maintenance Order Operation | view: IMAINTORDOP | TRAN | Extraction: Not supported | Component: Maintenance Orders
Tables used: AFKO, AFVC, AUFK
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Operation/Activity Number
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Price
Column Name Description
Column Name Description
Column Name Description
OperationCalculationControl Key for calculation Show values
OperationHasLongText Checkbox Show values
MaintOrdOpProcessPhaseCode Process Phase Show values
Column Name Description Domain name
MaintenanceOrderSubOperation null
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter General counter for order CO_APLZL
OperationWorkCenterTypeCode null
OperationDescription Operation Short Text TEXT40
NumberOfTimeTickets Number of Time Tickets LOHNANZ
OperationPurgInfoRecdSearchTxt Sort Term for Non-Stock Info Records CHAR10
OpExternalProcessingPriceUnit Price unit PACK3
OperationRequisitionerName Name of requisitioner/requester AFNAM
OperationTrackingNumber Requirement Tracking Number CHAR10
NumberOfCapacities Number of capacities required INT1
OperationWorkPercent Work percentage INT1
OperationGoodsRecipientName Goods Recipient WEMPF
OperationUnloadingPointName Unloading Point TEXT25
OperationPersonResponsible Personnel number PERNR
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
CostingSheet Costing Sheet KALSM
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
CapacityRequirement ID of the Capacity Requirements Record BEDID
CapacityRequirementItem Internal counter CIM_COUNT
PurchaseRequisition Purchase Requisition Number BANFN
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
MaintOrderConfCntrValue Confirmation counter CIM_COUNT
MaintOrdOpProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
DfsMaintOrdOpObjectNmbr Object number J_OBJNR
Master Data Relations Join Conditions
Activity Type
  • ?
  • Activity Type
  • Activity Type
  • Client
  • Controlling area of the requesting cost center
  • I_MAINTENANCEORDEROPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTENANCEORDEROPERATION.ACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTENANCEORDEROPERATION.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTENANCEORDEROPERATION.MANDT == CSLA.MANDT
  • I_MAINTENANCEORDEROPERATION.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEORDEROPERATION.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEORDEROPERATION.MANDT == MARA.MANDT
Business Area
  • Business Area
  • Client
  • I_MAINTENANCEORDEROPERATION.BUSINESSAREA == TGSB.GSBER
  • I_MAINTENANCEORDEROPERATION.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTENANCEORDEROPERATION.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTENANCEORDEROPERATION.MANDT == TKA01.MANDT
Activity Type
  • ?
  • Activity Type
  • Activity Type
  • Client
  • Controlling area of the requesting cost center
  • I_MAINTENANCEORDEROPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTENANCEORDEROPERATION.ACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTENANCEORDEROPERATION.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTENANCEORDEROPERATION.MANDT == CSLA.MANDT
  • I_MAINTENANCEORDEROPERATION.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS
Cost Element
  • Cost Element
  • ?
  • Client
  • I_MAINTENANCEORDEROPERATION.COSTELEMENT == CSKA.KSTAR
  • I_MAINTENANCEORDEROPERATION.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_MAINTENANCEORDEROPERATION.MANDT == CSKA.MANDT
Functional Area
  • Functional Area
  • Client
  • I_MAINTENANCEORDEROPERATION.FUNCTIONALAREA == TFKB.FKBER
  • I_MAINTENANCEORDEROPERATION.MANDT == TFKB.MANDT
Language Key I_MAINTENANCEORDEROPERATION.LANGUAGE == T002.SPRAS
Order Number
  • Client
  • Order Number
  • I_MAINTENANCEORDEROPERATION.MANDT == AUFK.MANDT
  • I_MAINTENANCEORDEROPERATION.MAINTENANCEORDER == AUFK.AUFNR
Material Group
  • Material Group
  • Client
  • I_MAINTENANCEORDEROPERATION.MATERIALGROUP == T023.MATKL
  • I_MAINTENANCEORDEROPERATION.MANDT == T023.MANDT
Control key
  • ?
  • Control key
  • Client
  • I_MAINTENANCEORDEROPERATION.[column in domain "PLNAW"] == T430.PLNAW
  • I_MAINTENANCEORDEROPERATION.OPERATIONCONTROLKEY == T430.STEUS
  • I_MAINTENANCEORDEROPERATION.MANDT == T430.MANDT
Usage
  • Usage
  • Client
  • I_MAINTENANCEORDEROPERATION.OPERATIONMILESTONEUSAGECODE == T433.MLSTN
  • I_MAINTENANCEORDEROPERATION.MANDT == T433.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_MAINTENANCEORDEROPERATION.OPERATIONPURCHASINGINFORECORD == EINA.INFNR
  • I_MAINTENANCEORDEROPERATION.MANDT == EINA.MANDT
Standard text key
  • Client
  • Standard text key
  • I_MAINTENANCEORDEROPERATION.MANDT == T435.MANDT
  • I_MAINTENANCEORDEROPERATION.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_MAINTENANCEORDEROPERATION.OPERATIONSUPPLIER == LFA1.LIFNR
  • I_MAINTENANCEORDEROPERATION.MANDT == LFA1.MANDT
System Condition
  • System Condition
  • Client
  • I_MAINTENANCEORDEROPERATION.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_MAINTENANCEORDEROPERATION.MANDT == T357M.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • I_MAINTENANCEORDEROPERATION.OPERATIONWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCEORDEROPERATION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTENANCEORDEROPERATION.MANDT == CRID.MANDT
Currency Key
  • Currency Key
  • Client
  • I_MAINTENANCEORDEROPERATION.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
  • I_MAINTENANCEORDEROPERATION.MANDT == TCURC.MANDT
Plant
  • Plant
  • Client
  • I_MAINTENANCEORDEROPERATION.PLANT == T001W.WERKS
  • I_MAINTENANCEORDEROPERATION.MANDT == T001W.MANDT
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • I_MAINTENANCEORDEROPERATION.MANDT == CEPC.MANDT
  • I_MAINTENANCEORDEROPERATION.PROFITCENTER == CEPC.PRCTR
  • I_MAINTENANCEORDEROPERATION.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_MAINTENANCEORDEROPERATION.[column in domain "DATBI"] == CEPC.DATBI
Purchasing Group for External Processing Activity
  • Client
  • Purchasing Group for External Processing Activity
  • I_MAINTENANCEORDEROPERATION.MANDT == T024.MANDT
  • I_MAINTENANCEORDEROPERATION.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_MAINTENANCEORDEROPERATION.MANDT == T024E.MANDT
  • I_MAINTENANCEORDEROPERATION.PURCHASINGORGANIZATION == T024E.EKORG
Controlling area of the requesting cost center
  • Client
  • Controlling area of the requesting cost center
  • I_MAINTENANCEORDEROPERATION.MANDT == TKA01.MANDT
  • I_MAINTENANCEORDEROPERATION.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
Tax Jurisdiction
  • Tax Jurisdiction
  • Costing Sheet
  • Client
  • I_MAINTENANCEORDEROPERATION.TAXJURISDICTION == TTXJ.TXJCD
  • I_MAINTENANCEORDEROPERATION.COSTINGSHEET == TTXJ.KALSM
  • I_MAINTENANCEORDEROPERATION.MANDT == TTXJ.MANDT