ESH_N_MAINTENANCEORDER

Anchor view -MAINTENANCEORDER | view: ESH_L_MAINTORDER | TRAN | Extraction: Not supported | Component: Plant Maintenance

Tables used: AFIH, AFKO, AFKO, AFVC, AUFK_TEXT, ESH_SR_LTXT, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, T353I, T353I_T, AUFK, AUFK, T357M, T357M_T, T003O, T003P, T356, T356_T, CRHD, ITOBCUST, IFLOUSR, T024I

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical (1)
Other (16)
🔗 Relations (21)

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
MaintOrdBasicEndDate	Basic finish date
MaintOrdBasicStartDate	Basic Start Date
LatestAcceptableCompletionDate	Final Due Date

Column Name	Description
MaintenanceProcessingPhase	Maintenance Processing Phase	Show values

Column Name	Description	Domain name
FunctionalLocation	Functional Location	TPLNR
EquipmentName	Description of technical object	TEXT40
WorkCenter	Work Center	ARBPL
OperationSystemConditionText	Text on Operating Condition	TEXT40
MaintenancePlannerGroupName	Name of the Maintenance Planner Group	TEXT18
MaintPriorityDesc	Priority Text	TEXT20
OrderTypeName	Name of an Order Type	TEXT40
MaintenanceActivityTypeName	Description of maintenance activity type	TXT30
FuncnlLocPrimaryLabelName	Functional Location Label	ILOM_STRNO
FunctionalLocationName	Description of functional location	TEXT40
MaintenanceOrderDesc	Description	TEXT40
MaintenanceProcessingPhaseDesc	Short Text for Fixed Values	DDTEXT
OperationDescription	Operation Short Text	TEXT40
AssetRoom	Room	CHAR8
MAINWORKCENTER	Work Center	ARBPL
PlainLongText	Long Text

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`ESH_N_MAINTENANCEORDER.ABCINDICATOR == T370C.ABCKZ` `ESH_N_MAINTENANCEORDER.MANDT == T370C.MANDT`
Assembly Assembly Client	`ESH_N_MAINTENANCEORDER.ASSEMBLY == MARA.MATNR` `ESH_N_MAINTENANCEORDER.MANDT == MARA.MANDT`
Technical Object Authorization Group Technical Object Authorization Group Technical Object Authorization Group Client	`ESH_N_MAINTENANCEORDER.AUTHORIZATIONGROUPFL == T370B.BEGRU` `ESH_N_MAINTENANCEORDER.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_N_MAINTENANCEORDER.MANDT == T370B.MANDT`
Technical Object Authorization Group Technical Object Authorization Group Technical Object Authorization Group Client	`ESH_N_MAINTENANCEORDER.AUTHORIZATIONGROUPFL == T370B.BEGRU` `ESH_N_MAINTENANCEORDER.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_N_MAINTENANCEORDER.MANDT == T370B.MANDT`
Controlling Area Controlling Area Client	`ESH_N_MAINTENANCEORDER.CONTROLLINGAREA == TKA01.KOKRS` `ESH_N_MAINTENANCEORDER.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`ESH_N_MAINTENANCEORDER.[column in domain "DATBI"] == CSKS.DATBI` `ESH_N_MAINTENANCEORDER.CONTROLLINGAREA == CSKS.KOKRS` `ESH_N_MAINTENANCEORDER.COSTCENTER == CSKS.KOSTL` `ESH_N_MAINTENANCEORDER.MANDT == CSKS.MANDT`
Equipment Number Equipment Number Client	`ESH_N_MAINTENANCEORDER.EQUIPMENT == EQUI.EQUNR` `ESH_N_MAINTENANCEORDER.MANDT == EQUI.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEACTIVITYTYPE == T353I.ILART` `ESH_N_MAINTENANCEORDER.MANDT == T353I.MANDT`
Location of maintenance object Maintenance Plant Location of maintenance object Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEPLANT == T499S.WERKS` `ESH_N_MAINTENANCEORDER.MAINTENANCEOBJECTLOCATION == T499S.STAND` `ESH_N_MAINTENANCEORDER.MANDT == T499S.MANDT`
Order Number Order Number Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEORDER == AUFK.AUFNR` `ESH_N_MAINTENANCEORDER.MANDT == AUFK.MANDT`
Order Type Order Type Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEORDERTYPE == T003O.AUART` `ESH_N_MAINTENANCEORDER.MANDT == T003O.CLIENT`
Maintenance Plan Maintenance Plan Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEPLAN == MPLA.WARPL` `ESH_N_MAINTENANCEORDER.MANDT == MPLA.MANDT`
Maintenance Plant Maintenance Plant Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEPLANT == T001W.WERKS` `ESH_N_MAINTENANCEORDER.MANDT == T001W.MANDT`
Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Revision for Plant Maintenance and Customer Service Client	`ESH_N_MAINTENANCEORDER.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `ESH_N_MAINTENANCEORDER.MAINTENANCEREVISION == T352R.REVNR` `ESH_N_MAINTENANCEORDER.MANDT == T352R.MANDT`
Priority Priority Type Priority Client	`ESH_N_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356.ARTPR` `ESH_N_MAINTENANCEORDER.MAINTPRIORITY == T356.PRIOK` `ESH_N_MAINTENANCEORDER.MANDT == T356.MANDT`
Priority Type Priority Type Client	`ESH_N_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356A.ARTPR` `ESH_N_MAINTENANCEORDER.MANDT == T356A.MANDT`
System Condition System Condition Client	`ESH_N_MAINTENANCEORDER.OPERATIONSYSTEMCONDITION == T357M.ANLZU` `ESH_N_MAINTENANCEORDER.MANDT == T357M.MANDT`
Plant Section Plant Section Maintenance Plant Client	`ESH_N_MAINTENANCEORDER.PLANTSECTION == T357.BEBER` `ESH_N_MAINTENANCEORDER.MAINTENANCEPLANT == T357.WERKS` `ESH_N_MAINTENANCEORDER.MANDT == T357.MANDT`

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