I_MaintenanceOrder

Maintenance Order | view: IMAINTORDER | TRAN | Extraction: Not supported | Component: Maintenance Orders
Tables used: AFIH, AFKO, AUFK
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
MaintOrderReferenceDate PM Order: Reference Date
MaintOrderReferenceTime Time of Reference Date
TechnicalCompletionDate Technical Completion Date
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicStartTime Basic Start (Time)
MaintOrdBasicEndDate Basic finish date
MaintOrdBasicEndTime Basic Finish (Time)
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
CreationDate Created On
CreationTime Time created
LatestAcceptableCompletionDate Final Due Date
Column Name Description
MaintenanceProcessingPhase Maintenance Processing Phase Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
MaintenanceOrderCategory Order category Show values
ControllingObjectClass Controlling Object Class Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
OrderHasLongText Order Has Long Text Show values
MaintOrdProcessPhaseCode Process Phase Show values
Column Name Description Domain name
SerialNumber Serial Number GERNR
MaintenanceItem Maintenance item POSNU
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
PersonnelNumber Name of Person Reponsible for System USNAM
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderDesc Description TEXT40
MaintOrdPersonResponsible Person Responsible ID I_PARNR
TaskListGroup Bill of Operations ID PLNNR
TaskListType Bill of Operations Type PLNTY
TaskListGroupCounter Bill of Operations Variant ALTNR
CreatedByUser Entered By USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
AdditionalDeviceData Additional Device Data DEVICEID
SuperiorProjectNetwork Number of superior network AUFNR
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
MaintOrdProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
DfsMaintOrderObjectNmbr Object number J_OBJNR
DfsMaintSuperordinateEquipNmbr Master Equipment EQUNR
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEORDER.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEORDER.MANDT == MARA.MANDT
Scheduling type
  • Scheduling type
  • Client
  • I_MAINTENANCEORDER.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_MAINTENANCEORDER.MANDT == T482.MANDT
Business Area
  • Business Area
  • Client
  • I_MAINTENANCEORDER.BUSINESSAREA == TGSB.GSBER
  • I_MAINTENANCEORDER.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_MAINTENANCEORDER.COMPANYCODE == T001.BUKRS
  • I_MAINTENANCEORDER.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTENANCEORDER.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTENANCEORDER.MANDT == TKA01.MANDT
Order Currency
  • Order Currency
  • Client
  • I_MAINTENANCEORDER.CURRENCY == TCURC.WAERS
  • I_MAINTENANCEORDER.MANDT == TCURC.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTENANCEORDER.EQUIPMENT == EQUI.EQUNR
  • I_MAINTENANCEORDER.MANDT == EQUI.MANDT
Functional Area
  • Functional Area
  • Client
  • I_MAINTENANCEORDER.FUNCTIONALAREA == TFKB.FKBER
  • I_MAINTENANCEORDER.MANDT == TFKB.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTENANCEORDER.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTENANCEORDER.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTENANCEORDER.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEORDER.MANDT == MPLA.MANDT
  • I_MAINTENANCEORDER.MAINTENANCEPLAN == MPLA.WARPL
Location Plant
  • Location Plant
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEPLANT == T001W.WERKS
  • I_MAINTENANCEORDER.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEREVISION == T352R.REVNR
  • I_MAINTENANCEORDER.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTENANCEORDER.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_MAINTENANCEORDER.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_MAINTENANCEORDER.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • I_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTENANCEORDER.MAINTPRIORITY == T356.PRIOK
  • I_MAINTENANCEORDER.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • I_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTENANCEORDER.MANDT == T356A.MANDT
Material Number
  • Material Number
  • Client
  • I_MAINTENANCEORDER.MATERIAL == MARA.MATNR
  • I_MAINTENANCEORDER.MANDT == MARA.MANDT
System Condition
  • System Condition
  • Client
  • I_MAINTENANCEORDER.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_MAINTENANCEORDER.MANDT == T357M.MANDT
Processing group
  • Processing group
  • Controlling Area
  • Client
  • I_MAINTENANCEORDER.ORDERPROCESSINGGROUP == TKO08.ABKRS
  • I_MAINTENANCEORDER.CONTROLLINGAREA == TKO08.KOKRS
  • I_MAINTENANCEORDER.MANDT == TKO08.CLIENT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • I_MAINTENANCEORDER.PROFITCENTER == CEPC.PRCTR
  • I_MAINTENANCEORDER.[column in domain "DATBI"] == CEPC.DATBI
  • I_MAINTENANCEORDER.CONTROLLINGAREA == CEPC.KOKRS
  • I_MAINTENANCEORDER.MANDT == CEPC.MANDT
Project definition
  • Project definition
  • Client
  • I_MAINTENANCEORDER.PROJECTINTERNALID == PROJ.PSPNR
  • I_MAINTENANCEORDER.MANDT == PROJ.MANDT
Responsible Cost Center
  • Responsible Cost Center
  • ?
  • Controlling Area
  • Client
  • I_MAINTENANCEORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MAINTENANCEORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTENANCEORDER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTENANCEORDER.MANDT == CSKS.MANDT
Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • Client
  • I_MAINTENANCEORDER.WORKCENTERTYPECODE == CRID.OBJTY
  • I_MAINTENANCEORDER.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCEORDER.MANDT == CRID.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
  • Maintenance Planning Plant
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTENANCEORDER.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEORDER.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTENANCEORDER.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTENANCEORDER.MANDT == T399I.MANDT