I_MaintOrderOperAndSubOper

Maintenance Order Operation and Suboperation | view: IMTORDOPSOPR | TRAN | Extraction: Not supported | Component: Maintenance Orders
Tables used: AFKO, AFVC, AFVV, AUFK
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation null
MaintenanceOrderSubOperation Suboperation
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Price
Column Name Description
📏 Unit of measure for activity (OperationQuantityUnit):
OperationQuantity Base Quantity
📏 Normal duration/unit (MaintOrdOperationDurationUnit):
MaintOrderOperationDuration Normal duration of the activity
📏 Unit for work (MaintOrdOpWorkDurationUnit):
MaintOrdOperationWorkDuration Work involved in the activity
ForecastWorkQuantity Forecasted work (actual + remaining)
ActualWorkQuantity Actual work
📏 Unit of measure for activity (MaintOrdOperationQuantityUnit):
MaintOrderOperationQuantity Operation Total Quantity
Column Name Description
ConstraintDateForBscStartDate Constraint for activity start (Basic)
ConstraintTimeForBscStartTime Constraint for activity start time (Basic)
ConstraintDateForBscFinishDate Constraint for Finish of Activity (Basic)
ConstraintTimeForBscFinishTime Basic finish time of the activity
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
OpErlstSchedldExecStrtTme Earliest scheduled start: Execution (time)
OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date)
OpErlstSchedldExecEndTme Earliest scheduled finish: Execution (time)
OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date)
OpLtstSchedldExecStrtTme Latest scheduled start: Execution (time)
OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date)
OpLtstSchedldExecEndTme Latest scheduled finish: Execution (time)
OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime Actual Execution Start Time
OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime Actual Execution End Time
Column Name Description
OperationCalculationControl Key for calculation Show values
OperationHasLongText Checkbox Show values
OpBscStartDateConstraintType Constraint on the basic start date for the activity Show values
OpBscEndDateConstraintType Constraint on the finish date of the activity Show values
FldLogsDelivHdrIsHeldOnShore Hold On-Shore Show values
MaintOrdOperationIsMRPRelevant Reservation Relevance/Generation of Purchase Requisition Show values
IsMarkedForDeletion Deletion Flag Show values
MaintOrdOpProcessPhaseCode Process Phase Show values
Column Name Description Domain name
MaintOrderOperationForEdit Maintenance Order Operation CHAR4
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter General counter for order CO_APLZL
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
OperationDescription Operation Short Text TEXT40
NumberOfTimeTickets Number of Time Tickets LOHNANZ
OperationPersonResponsible Personnel number PERNR
OperationWorkCenterTypeCode null
NumberOfCapacities Number of capacities required INT1
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location
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
OperationWorkPercent Work percentage INT1
CapacityRequirement ID of the Capacity Requirements Record BEDID
PurchaseRequisition Purchase Requisition Number BANFN
EAMPlannedDeliveryDurnInDays Planned Delivery Time in Days DEC3
MaintOrdOperationExecutionRate Execution Factor AFAKT
CostingSheet Costing Sheet KALSM
MaintOrdOpFrameWorkOrder Framework Order EBELN
MaintOrdOpFrameWorkOrderItem Item of framework order EBELP
ExtProcgOperationHasSubcontrg Indicator: External Processing Operation with Subcontracting CHAR1
EmployeeWageType Wage type LOART
MaintControllingObjectClass Object Class
MaintOrdOperationOverheadCode Overhead key CHAR6
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
MaintOrderConfCntrValue Confirmation counter CIM_COUNT
MaintOrdOpProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
Master Data Relations Join Conditions
Activity Type
  • ?
  • Controlling area of the requesting cost center
  • Activity Type
  • Activity Type
  • Client
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTORDEROPERANDSUBOPER.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS
  • I_MAINTORDEROPERANDSUBOPER.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERANDSUBOPER.ACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERANDSUBOPER.MANDT == CSLA.MANDT
Assembly
  • Client
  • Assembly
  • I_MAINTORDEROPERANDSUBOPER.MANDT == MARA.MANDT
  • I_MAINTORDEROPERANDSUBOPER.ASSEMBLY == MARA.MATNR
Business Area
  • Client
  • Business Area
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TGSB.MANDT
  • I_MAINTORDEROPERANDSUBOPER.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTORDEROPERANDSUBOPER.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TKA01.MANDT
Activity Type
  • ?
  • Controlling area of the requesting cost center
  • Activity Type
  • Activity Type
  • Client
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "DATBI"] == CSLA.DATBI
  • I_MAINTORDEROPERANDSUBOPER.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS
  • I_MAINTORDEROPERANDSUBOPER.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERANDSUBOPER.ACTIVITYTYPE == CSLA.LSTAR
  • I_MAINTORDEROPERANDSUBOPER.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Cost Element
  • Client
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_MAINTORDEROPERANDSUBOPER.COSTELEMENT == CSKA.KSTAR
  • I_MAINTORDEROPERANDSUBOPER.MANDT == CSKA.MANDT
Suitability
  • Client
  • Suitability
  • Plant
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T423.MANDT
  • I_MAINTORDEROPERANDSUBOPER.EMPLOYEESUITABILITY == T423.QUALF
  • I_MAINTORDEROPERANDSUBOPER.PLANT == T423.WERKS
Wage Group
  • Client
  • Wage Group
  • Plant
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T421.MANDT
  • I_MAINTORDEROPERANDSUBOPER.EMPLOYEEWAGEGROUP == T421.LOGRP
  • I_MAINTORDEROPERANDSUBOPER.PLANT == T421.WERKS
Functional Area
  • Functional Area
  • Client
  • I_MAINTORDEROPERANDSUBOPER.FUNCTIONALAREA == TFKB.FKBER
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TFKB.MANDT
Language Key I_MAINTORDEROPERANDSUBOPER.LANGUAGE == T002.SPRAS
Order Number
  • Order Number
  • Client
  • I_MAINTORDEROPERANDSUBOPER.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDEROPERANDSUBOPER.MANDT == AUFK.MANDT
Normal duration/unit
  • Normal duration/unit
  • Client
  • I_MAINTORDEROPERANDSUBOPER.MAINTORDOPERATIONDURATIONUNIT == T006.MSEHI
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T006.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONQUANTITYUNIT == T006.MSEHI
  • I_MAINTORDEROPERANDSUBOPER.MAINTORDOPERATIONQUANTITYUNIT == T006.MSEHI
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T006.MANDT
Unit for work
  • Client
  • Unit for work
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T006.MANDT
  • I_MAINTORDEROPERANDSUBOPER.MAINTORDOPWORKDURATIONUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T023.MANDT
  • I_MAINTORDEROPERANDSUBOPER.MATERIALGROUP == T023.MATKL
Control key
  • Control key
  • Client
  • ?
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONCONTROLKEY == T430.STEUS
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T430.MANDT
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "PLNAW"] == T430.PLNAW
Usage
  • Usage
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONMILESTONEUSAGECODE == T433.MLSTN
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T433.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONPURCHASINGINFORECORD == EINA.INFNR
  • I_MAINTORDEROPERANDSUBOPER.MANDT == EINA.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONQUANTITYUNIT == T006.MSEHI
  • I_MAINTORDEROPERANDSUBOPER.MAINTORDOPERATIONQUANTITYUNIT == T006.MSEHI
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T006.MANDT
Standard text key
  • Standard text key
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T435.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_MAINTORDEROPERANDSUBOPER.MANDT == LFA1.MANDT
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONSUPPLIER == LFA1.LIFNR
System Condition
  • Client
  • System Condition
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T357M.MANDT
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONSYSTEMCONDITION == T357M.ANLZU
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDEROPERANDSUBOPER.OPERATIONWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDEROPERANDSUBOPER.MANDT == CRID.MANDT
Currency Key
  • Currency Key
  • Client
  • I_MAINTORDEROPERANDSUBOPER.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TCURC.MANDT
Plant
  • Client
  • Plant
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T001W.MANDT
  • I_MAINTORDEROPERANDSUBOPER.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_MAINTORDEROPERANDSUBOPER.[column in domain "DATBI"] == CEPC.DATBI
  • I_MAINTORDEROPERANDSUBOPER.MANDT == CEPC.MANDT
  • I_MAINTORDEROPERANDSUBOPER.PROFITCENTER == CEPC.PRCTR
Purchasing Group for External Processing Activity
  • Client
  • Purchasing Group for External Processing Activity
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T024.MANDT
  • I_MAINTORDEROPERANDSUBOPER.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_MAINTORDEROPERANDSUBOPER.PURCHASINGORGANIZATION == T024E.EKORG
  • I_MAINTORDEROPERANDSUBOPER.MANDT == T024E.MANDT
Controlling area of the requesting cost center
  • Controlling area of the requesting cost center
  • Client
  • I_MAINTORDEROPERANDSUBOPER.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TKA01.MANDT
Tax Jurisdiction
  • Costing Sheet
  • Client
  • Tax Jurisdiction
  • I_MAINTORDEROPERANDSUBOPER.COSTINGSHEET == TTXJ.KALSM
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TTXJ.MANDT
  • I_MAINTORDEROPERANDSUBOPER.TAXJURISDICTION == TTXJ.TXJCD
Distr.cap.reqmts (plant maint.,process order, network)
  • Client
  • Distr.cap.reqmts (plant maint.,process order, network)
  • I_MAINTORDEROPERANDSUBOPER.MANDT == TC29.MANDT
  • I_MAINTORDEROPERANDSUBOPER.WRKCTRINTCAPRQMTSDISTR == TC29.VERTL