I_MaintOrderHistTechObj

Maintenance Order History w/ Techn. Obj. | view: IMNTORDHISTECOBJ | TRAN | Extraction: Not supported | Component: Maintenance Orders

Tables used: HIKO, EQUI, EQUZ, ILOA, IHPA, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (7)
☰ Categorical (6)
Other (10)
🔗 Relations (23)

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
MaintOrdBasicStartDate	Basic start date
MaintOrdBasicEndDate	Basic finish date
ActualStartDate	Actual start date
ConfirmedEndDate	Confirmed Order Finish Date
MaintOrderReferenceDate	PM Order: Reference Date

Column Name	Description
TechObjIsEquipOrFuncnlLoc	Technical Object Type	Show values
IsMarkedForDeletion	Deletion Flag	Show values
MaintenanceProcessingPhase	Maintenance Processing Phase	Show values
MaintenanceOrderCategory	Order Category	Show values
WorkCenterTypeCode	Object Type of CIM Resources for Work Center	Show values
MaintenanceOrderPlanningCode	Maintenance order planning indicator	Show values

Column Name	Description	Domain name
TechnicalObject	Technical Object	EAMS_TEC_OBJ
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
MaintOrdMainWorkCenter	Work Center	ARBPL
MaintOrdPersonResponsible	Partner	I_PARNR

Master Data Relations	Join Conditions
Assembly Client Assembly	`I_MAINTORDERHISTTECHOBJ.MANDT == MARA.MANDT` `I_MAINTORDERHISTTECHOBJ.ASSEMBLY == MARA.MATNR`
Technical Object Authorization Group Client Technical Object Authorization Group	`I_MAINTORDERHISTTECHOBJ.MANDT == T370B.MANDT` `I_MAINTORDERHISTTECHOBJ.AUTHORIZATIONGROUP == T370B.BEGRU`
Bill of Operations Type Client Bill of Operations Type	`I_MAINTORDERHISTTECHOBJ.MANDT == TCA01.MANDT` `I_MAINTORDERHISTTECHOBJ.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Business Area Client Business Area	`I_MAINTORDERHISTTECHOBJ.MANDT == TGSB.MANDT` `I_MAINTORDERHISTTECHOBJ.BUSINESSAREA == TGSB.GSBER`
Controlling Area Client Controlling Area	`I_MAINTORDERHISTTECHOBJ.MANDT == TKA01.MANDT` `I_MAINTORDERHISTTECHOBJ.CONTROLLINGAREA == TKA01.KOKRS`
Equipment Number Equipment Number Client	`I_MAINTORDERHISTTECHOBJ.EQUIPMENT == EQUI.EQUNR` `I_MAINTORDERHISTTECHOBJ.MANDT == EQUI.MANDT`
Maintenance Activity Type Client Maintenance Activity Type	`I_MAINTORDERHISTTECHOBJ.MANDT == T353I.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEACTIVITYTYPE == T353I.ILART`
Order Type Client Order Type	`I_MAINTORDERHISTTECHOBJ.MANDT == T003O.CLIENT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEORDERTYPE == T003O.AUART`
Maintenance Plan Client Maintenance Plan	`I_MAINTORDERHISTTECHOBJ.MANDT == MPLA.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Planning Plant Maintenance Planning Plant Client	`I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLANNINGPLANT == T001W.WERKS` `I_MAINTORDERHISTTECHOBJ.MANDT == T001W.MANDT`
Maintenance Plant Client Maintenance Plant	`I_MAINTORDERHISTTECHOBJ.MANDT == T001W.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLANT == T001W.WERKS`
Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Client Revision for Plant Maintenance and Customer Service	`I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `I_MAINTORDERHISTTECHOBJ.MANDT == T352R.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEREVISION == T352R.REVNR`
Location and account assignment for technical object Client Location and account assignment for technical object	`I_MAINTORDERHISTTECHOBJ.MANDT == ILOA.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN`
Plant Client Plant Plant	`I_MAINTORDERHISTTECHOBJ.MANDT == T001W.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTORDMAINWORKCENTERPLANT == T001W.WERKS` `I_MAINTORDERHISTTECHOBJ.PLANT == T001W.WERKS`
Priority Priority Type Client Priority	`I_MAINTORDERHISTTECHOBJ.MAINTPRIORITYTYPE == T356.ARTPR` `I_MAINTORDERHISTTECHOBJ.MANDT == T356.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`I_MAINTORDERHISTTECHOBJ.MAINTPRIORITYTYPE == T356A.ARTPR` `I_MAINTORDERHISTTECHOBJ.MANDT == T356A.MANDT`
System Condition Client System Condition	`I_MAINTORDERHISTTECHOBJ.MANDT == T357M.MANDT` `I_MAINTORDERHISTTECHOBJ.OPERATIONSYSTEMCONDITION == T357M.ANLZU`
Plant Client Plant Plant	`I_MAINTORDERHISTTECHOBJ.MANDT == T001W.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTORDMAINWORKCENTERPLANT == T001W.WERKS` `I_MAINTORDERHISTTECHOBJ.PLANT == T001W.WERKS`
Object ID of the Work Center Client Object Type of CIM Resources for Work Center Object ID of the Work Center	`I_MAINTORDERHISTTECHOBJ.MANDT == CRID.MANDT` `I_MAINTORDERHISTTECHOBJ.WORKCENTERTYPECODE == CRID.OBJTY` `I_MAINTORDERHISTTECHOBJ.WORKCENTERINTERNALID == CRID.OBJID`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client Planner Group for Customer Service and Plant Maintenance	`I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `I_MAINTORDERHISTTECHOBJ.MANDT == T024I.MANDT` `I_MAINTORDERHISTTECHOBJ.MAINTENANCEPLANNERGROUP == T024I.INGRP`