I_MaintOrderOperationTP

MaintOrder Operation w/ Technical Object | view: IMAINTORDOPTP | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: EAM_OSTOBJSTS, AFKO, OBJK, AFIH, AFKO, AFKO, AFVC, OPROL, AFVV, QMIH, JSTO, JEST, ILOA, AUFK, AUFK, AUFK, CRHD
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Operation/Activity Number
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Price
Column Name Description
📏 Unit for work (OperationPlannedWorkUnit):
OperationPlannedWork Work involved in the activity
ConfirmationTotalQuantity Total of Actual Work
📏 Normal duration/unit (OperationDurationUnit):
OperationDuration Normal duration of the activity
Column Name Description
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
OperationCalculationControl Key for calculation Show values
OperationHasLongText Checkbox Show values
IsFinallyConfirmed Finally Confirmed Show values
MaintOrdOpProcessPhaseCode Process Phase Show values
Column Name Description Domain name
MaintOrderOperationForEdit Operation/Activity Number VORNR
TechnicalObject Technical Object EAMS_TEC_OBJ
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter General counter for order CO_APLZL
OperationDescription Operation Short Text TEXT40
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
OperationWorkCenterTypeCode null
OperationPurgInfoRecdSearchTxt Sort Term for Non-Stock Info Records CHAR10
OperationRequisitionerName Name of requisitioner/requester AFNAM
OperationGoodsRecipientName Goods Recipient WEMPF
OpExternalProcessingPriceUnit Price unit PACK3
OperationTrackingNumber Requirement Tracking Number CHAR10
OperationUnloadingPointName Unloading Point TEXT25
OperationPersonResponsible Personnel number PERNR
OperationWorkPercent Work percentage INT1
CapacityRequirement ID of the Capacity Requirements Record BEDID
CapacityRequirementItem Internal counter CIM_COUNT
PurchaseRequisition Purchase Requisition Number BANFN
NumberOfCapacities Number of capacities required INT1
OperationWorkCenter Work Center ARBPL
IsDeleted null
MaintenanceOrderSubOperation Suboperation VORNR
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
MaintOrdOpProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTORDEROPERATIONTP.ASSEMBLY == MARA.MATNR
  • I_MAINTORDEROPERATIONTP.MANDT == MARA.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTORDEROPERATIONTP.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDEROPERATIONTP.MANDT == TKA01.MANDT
Activity Type
  • Controlling area of the requesting cost center
  • Activity Type
  • ?
  • Client
  • I_MAINTORDEROPERATIONTP.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS
  • I_MAINTORDEROPERATIONTP.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Element
  • Cost Element
  • ?
  • Client
  • I_MAINTORDEROPERATIONTP.COSTELEMENT == CSKA.KSTAR
  • I_MAINTORDEROPERATIONTP.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_MAINTORDEROPERATIONTP.MANDT == CSKA.MANDT
Overall Status
  • Overall Status
  • Client
  • Profile for Overall Status
  • I_MAINTORDEROPERATIONTP.EAMOVERALLOBJECTSTATUS == EAM_OSTAT.OVERALL_STATUS
  • I_MAINTORDEROPERATIONTP.MANDT == EAM_OSTAT.MANDT
  • I_MAINTORDEROPERATIONTP.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTAT.OVERALL_STATUS_PROFILE
Profile for Overall Status
  • Client
  • Profile for Overall Status
  • I_MAINTORDEROPERATIONTP.MANDT == EAM_OSTPROF.MANDT
  • I_MAINTORDEROPERATIONTP.EAMOVERALLOBJECTSTATUSPROFILE == EAM_OSTPROF.OVERALL_STATUS_PROFILE
Language Key I_MAINTORDEROPERATIONTP.LANGUAGE == T002.SPRAS
Order Number
  • Order Number
  • Client
  • I_MAINTORDEROPERATIONTP.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDEROPERATIONTP.MANDT == AUFK.MANDT
Material Group
  • Material Group
  • Client
  • I_MAINTORDEROPERATIONTP.MATERIALGROUP == T023.MATKL
  • I_MAINTORDEROPERATIONTP.MANDT == T023.MANDT
Control key
  • Control key
  • Client
  • ?
  • I_MAINTORDEROPERATIONTP.OPERATIONCONTROLKEY == T430.STEUS
  • I_MAINTORDEROPERATIONTP.MANDT == T430.MANDT
  • I_MAINTORDEROPERATIONTP.[column in domain "PLNAW"] == T430.PLNAW
Normal duration/unit
  • Normal duration/unit
  • Client
  • I_MAINTORDEROPERATIONTP.OPERATIONDURATIONUNIT == T006.MSEHI
  • I_MAINTORDEROPERATIONTP.MANDT == T006.MANDT
Unit for work
  • Unit for work
  • Client
  • I_MAINTORDEROPERATIONTP.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
  • I_MAINTORDEROPERATIONTP.MANDT == T006.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_MAINTORDEROPERATIONTP.OPERATIONPURCHASINGINFORECORD == EINA.INFNR
  • I_MAINTORDEROPERATIONTP.MANDT == EINA.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_MAINTORDEROPERATIONTP.OPERATIONSUPPLIER == LFA1.LIFNR
  • I_MAINTORDEROPERATIONTP.MANDT == LFA1.MANDT
System Condition
  • System Condition
  • Client
  • I_MAINTORDEROPERATIONTP.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_MAINTORDEROPERATIONTP.MANDT == T357M.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_MAINTORDEROPERATIONTP.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDEROPERATIONTP.OPERATIONWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDEROPERATIONTP.MANDT == CRID.MANDT
Currency Key
  • Currency Key
  • Client
  • I_MAINTORDEROPERATIONTP.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
  • I_MAINTORDEROPERATIONTP.MANDT == TCURC.MANDT
Plant
  • Plant
  • Client
  • I_MAINTORDEROPERATIONTP.PLANT == T001W.WERKS
  • I_MAINTORDEROPERATIONTP.MANDT == T001W.MANDT
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • I_MAINTORDEROPERATIONTP.PURCHASINGGROUP == T024.EKGRP
  • I_MAINTORDEROPERATIONTP.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_MAINTORDEROPERATIONTP.PURCHASINGORGANIZATION == T024E.EKORG
  • I_MAINTORDEROPERATIONTP.MANDT == T024E.MANDT
Controlling area of the requesting cost center
  • Controlling area of the requesting cost center
  • Client
  • I_MAINTORDEROPERATIONTP.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDEROPERATIONTP.MANDT == TKA01.MANDT