I_MaintenanceOrderHistory

Maintenance Order History | view: IMAINTORDERHS | TRAN | Extraction: Not supported | Component: Maintenance Orders
Tables used: HIKO, EQUI, EQUZ, ILOA
Column Name Description
MaintenanceOrder Order number historical
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
LastChangeDate Change Date for Order Master
MaintOrderReferenceDate PM Order: Reference Date
MaintOrdBasicStartDate Basic start date
MaintOrdBasicEndDate Basic finish date
ActualStartDate Actual start date
ConfirmedEndDate Confirmed Order Finish Date
Column Name Description
IsMarkedForDeletion Deletion Flag Show values
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
Column Name Description Domain name
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
MaintenanceItem Maintenance item POSNU
SerialNumber Serial Number GERNR
MaintenanceOrderDesc Order Description TEXT40
BillOfOperations Bill of Operations ID PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEORDERHISTORY.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEORDERHISTORY.MANDT == MARA.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_MAINTENANCEORDERHISTORY.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_MAINTENANCEORDERHISTORY.MANDT == T370B.MANDT
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_MAINTENANCEORDERHISTORY.MANDT == TCA01.MANDT
  • I_MAINTENANCEORDERHISTORY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Business Area
  • Business Area
  • Client
  • I_MAINTENANCEORDERHISTORY.BUSINESSAREA == TGSB.GSBER
  • I_MAINTENANCEORDERHISTORY.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • I_MAINTENANCEORDERHISTORY.MANDT == T001.MANDT
  • I_MAINTENANCEORDERHISTORY.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTENANCEORDERHISTORY.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTENANCEORDERHISTORY.MANDT == TKA01.MANDT
Order Currency
  • Client
  • Order Currency
  • I_MAINTENANCEORDERHISTORY.MANDT == TCURC.MANDT
  • I_MAINTENANCEORDERHISTORY.CURRENCY == TCURC.WAERS
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTENANCEORDERHISTORY.EQUIPMENT == EQUI.EQUNR
  • I_MAINTENANCEORDERHISTORY.MANDT == EQUI.MANDT
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • I_MAINTENANCEORDERHISTORY.MANDT == T353I.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order Type
  • Order Type
  • Client
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTENANCEORDERHISTORY.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEORDERHISTORY.MANDT == MPLA.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTENANCEORDERHISTORY.MANDT == T001W.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLANNINGPLANT == T001W.WERKS
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTENANCEORDERHISTORY.MANDT == T001W.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLANT == T001W.WERKS
Revision for Plant Maintenance and Customer Service
  • Client
  • Maintenance Planning Plant
  • Revision for Plant Maintenance and Customer Service
  • I_MAINTENANCEORDERHISTORY.MANDT == T352R.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_MAINTENANCEORDERHISTORY.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_MAINTENANCEORDERHISTORY.MANDT == ILOA.MANDT
Priority
  • Client
  • Priority Type
  • Priority
  • I_MAINTENANCEORDERHISTORY.MANDT == T356.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTENANCEORDERHISTORY.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • I_MAINTENANCEORDERHISTORY.MANDT == T356A.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTPRIORITYTYPE == T356A.ARTPR
System Condition
  • Client
  • System Condition
  • I_MAINTENANCEORDERHISTORY.MANDT == T357M.MANDT
  • I_MAINTENANCEORDERHISTORY.OPERATIONSYSTEMCONDITION == T357M.ANLZU
Plant
  • Client
  • Plant
  • I_MAINTENANCEORDERHISTORY.MANDT == T001W.MANDT
  • I_MAINTENANCEORDERHISTORY.PLANT == T001W.WERKS
Object ID of the Work Center
  • Client
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • I_MAINTENANCEORDERHISTORY.MANDT == CRID.MANDT
  • I_MAINTENANCEORDERHISTORY.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCEORDERHISTORY.WORKCENTERTYPECODE == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_MAINTENANCEORDERHISTORY.MANDT == T024I.MANDT
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEORDERHISTORY.MAINTENANCEPLANNERGROUP == T024I.INGRP