ESH_S_MAINTENANCEORDER

Search view -MAINTENANCEORDER | view: ESH_U_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
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical
Other (18)
🔗 Relations (21)

Column Name	Description

Column Name	Description

Column Name	Description

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

Column Name	Description

Column Name	Description	Domain name
FunctionalLocation	Functional Location
EquipmentName	Description of technical object	TEXT40
WorkCenter	Work Center
OperationSystemConditionText	Text on Operating Condition
MaintenancePlannerGroupName	Name of the Maintenance Planner Group	TEXT18
MaintPriorityDesc	Priority Text	TEXT20
OrderTypeName	Name of an Order Type
MaintenanceActivityTypeName	Description of maintenance activity type
FuncnlLocPrimaryLabelName	Functional Location Label
FuncLocLabel	null
FunctionalLocationName	Description of functional location
MaintenanceOrderDesc	Description	TEXT40
MaintenanceProcessingPhase	Maintenance Processing Phase
MaintenanceProcessingPhaseDesc	Short Text for Fixed Values
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_S_MAINTENANCEORDER.ABCINDICATOR == T370C.ABCKZ` `ESH_S_MAINTENANCEORDER.MANDT == T370C.MANDT`
Assembly Assembly Client	`ESH_S_MAINTENANCEORDER.ASSEMBLY == MARA.MATNR` `ESH_S_MAINTENANCEORDER.MANDT == MARA.MANDT`
Technical Object Authorization Group Client Technical Object Authorization Group Technical Object Authorization Group	`ESH_S_MAINTENANCEORDER.MANDT == T370B.MANDT` `ESH_S_MAINTENANCEORDER.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_S_MAINTENANCEORDER.AUTHORIZATIONGROUPFL == T370B.BEGRU`
Technical Object Authorization Group Client Technical Object Authorization Group Technical Object Authorization Group	`ESH_S_MAINTENANCEORDER.MANDT == T370B.MANDT` `ESH_S_MAINTENANCEORDER.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_S_MAINTENANCEORDER.AUTHORIZATIONGROUPFL == T370B.BEGRU`
Controlling Area Controlling Area Client	`ESH_S_MAINTENANCEORDER.CONTROLLINGAREA == TKA01.KOKRS` `ESH_S_MAINTENANCEORDER.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`ESH_S_MAINTENANCEORDER.[column in domain "DATBI"] == CSKS.DATBI` `ESH_S_MAINTENANCEORDER.CONTROLLINGAREA == CSKS.KOKRS` `ESH_S_MAINTENANCEORDER.COSTCENTER == CSKS.KOSTL` `ESH_S_MAINTENANCEORDER.MANDT == CSKS.MANDT`
Equipment Number Equipment Number Client	`ESH_S_MAINTENANCEORDER.EQUIPMENT == EQUI.EQUNR` `ESH_S_MAINTENANCEORDER.MANDT == EQUI.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`ESH_S_MAINTENANCEORDER.MAINTENANCEACTIVITYTYPE == T353I.ILART` `ESH_S_MAINTENANCEORDER.MANDT == T353I.MANDT`
Location of maintenance object Client Maintenance Plant Location of maintenance object	`ESH_S_MAINTENANCEORDER.MANDT == T499S.MANDT` `ESH_S_MAINTENANCEORDER.MAINTENANCEPLANT == T499S.WERKS` `ESH_S_MAINTENANCEORDER.MAINTENANCEOBJECTLOCATION == T499S.STAND`
Order Number Client Order Number	`ESH_S_MAINTENANCEORDER.MANDT == AUFK.MANDT` `ESH_S_MAINTENANCEORDER.MAINTENANCEORDER == AUFK.AUFNR`
Order Type Client Order Type	`ESH_S_MAINTENANCEORDER.MANDT == T003O.CLIENT` `ESH_S_MAINTENANCEORDER.MAINTENANCEORDERTYPE == T003O.AUART`
Maintenance Plan Client Maintenance Plan	`ESH_S_MAINTENANCEORDER.MANDT == MPLA.MANDT` `ESH_S_MAINTENANCEORDER.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Plant Client Maintenance Plant	`ESH_S_MAINTENANCEORDER.MANDT == T001W.MANDT` `ESH_S_MAINTENANCEORDER.MAINTENANCEPLANT == T001W.WERKS`
Revision for Plant Maintenance and Customer Service Client Maintenance Planning Plant Revision for Plant Maintenance and Customer Service	`ESH_S_MAINTENANCEORDER.MANDT == T352R.MANDT` `ESH_S_MAINTENANCEORDER.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `ESH_S_MAINTENANCEORDER.MAINTENANCEREVISION == T352R.REVNR`
Priority Priority Type Client Priority	`ESH_S_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356.ARTPR` `ESH_S_MAINTENANCEORDER.MANDT == T356.MANDT` `ESH_S_MAINTENANCEORDER.MAINTPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`ESH_S_MAINTENANCEORDER.MAINTPRIORITYTYPE == T356A.ARTPR` `ESH_S_MAINTENANCEORDER.MANDT == T356A.MANDT`
System Condition System Condition Client	`ESH_S_MAINTENANCEORDER.OPERATIONSYSTEMCONDITION == T357M.ANLZU` `ESH_S_MAINTENANCEORDER.MANDT == T357M.MANDT`
Plant Section Client Plant Section Maintenance Plant	`ESH_S_MAINTENANCEORDER.MANDT == T357.MANDT` `ESH_S_MAINTENANCEORDER.PLANTSECTION == T357.BEBER` `ESH_S_MAINTENANCEORDER.MAINTENANCEPLANT == T357.WERKS`

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