ESH_N_MAINTENANCEITEM

Anchor view -MAINTENANCEITEM | view: ESH_L_MAINTITEM | Extraction: Not supported | Component: Plant Maintenance

Tables used: QMEL, ESH_SR_LTXT, PLKZ, PLKO, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, T353I, T353I_T, MPOS, T399W, T351, T351T, T357M, T357M_T, NRIV, TQ80, EAPL, TAPL, CRHD, ITOBCUST, IFLOUSR, T024I, T350, TPAER

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

Column Name	Description
MaintenanceItem	Maintenance item

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
MaintenancePlanCallObject	Call object for maintenance plan	Show values

Column Name	Description	Domain name
EquipmentName	Description of technical object	TEXT40
OperationSystemConditionText	Text on Operating Condition	TEXT40
WorkCenter	Work Center	ARBPL
FuncnlLocPrimaryLabelName	Functional Location Label	ILOM_STRNO
FunctionalLocationName	Description of functional location	TEXT40
TaskListGroupCounter	Group Counter	ALTNR
TaskListGroup	Key for Task List Group	PLNNR
OperationSystemCondition	System Condition	ANLZU
MaintenanceItemDescription	Item Short Text	TEXT40
LastChangedByUser	Name of Person Who Changed Object	USNAM
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
MaintenanceActivityTypeName	Description of maintenance activity type	TXT30
NotificationText	Short Text	TEXT40
MaintenancePlannerGroupName	Name of the Maintenance Planner Group	TEXT18
MaintenanceStrategyDesc	Description of maintenance strategy	TXT30
TaskListDesc	Routing Description	TEXT40
PlainLongText	Long Text

Master Data Relations \| to Other Relations ↓	Join Conditions
Assembly Assembly Client	`ESH_N_MAINTENANCEITEM.ASSEMBLY == MARA.MATNR` `ESH_N_MAINTENANCEITEM.MANDT == MARA.MANDT`
Technical Object Authorization Group Client Technical Object Authorization Group Technical Object Authorization Group	`ESH_N_MAINTENANCEITEM.MANDT == T370B.MANDT` `ESH_N_MAINTENANCEITEM.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_N_MAINTENANCEITEM.AUTHORIZATIONGROUPFL == T370B.BEGRU`
Technical Object Authorization Group Client Technical Object Authorization Group Technical Object Authorization Group	`ESH_N_MAINTENANCEITEM.MANDT == T370B.MANDT` `ESH_N_MAINTENANCEITEM.AUTHORIZATIONGROUPEQ == T370B.BEGRU` `ESH_N_MAINTENANCEITEM.AUTHORIZATIONGROUPFL == T370B.BEGRU`
Controlling Area Client Controlling Area	`ESH_N_MAINTENANCEITEM.MANDT == TKA01.MANDT` `ESH_N_MAINTENANCEITEM.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Cost Center Client ? Controlling Area	`ESH_N_MAINTENANCEITEM.COSTCENTER == CSKS.KOSTL` `ESH_N_MAINTENANCEITEM.MANDT == CSKS.MANDT` `ESH_N_MAINTENANCEITEM.[column in domain "DATBI"] == CSKS.DATBI` `ESH_N_MAINTENANCEITEM.CONTROLLINGAREA == CSKS.KOKRS`
Equipment number Equipment Number Client	`ESH_N_MAINTENANCEITEM.EQUIPMENT == EQUI.EQUNR` `ESH_N_MAINTENANCEITEM.MANDT == EQUI.MANDT`
Functional Location Functional Location Client	`ESH_N_MAINTENANCEITEM.FUNCTIONALLOCATION == IFLOT.TPLNR` `ESH_N_MAINTENANCEITEM.MANDT == IFLOT.MANDT`
Maintenance activity type Maintenance activity type Client	`ESH_N_MAINTENANCEITEM.MAINTENANCEACTIVITYTYPE == T353I.ILART` `ESH_N_MAINTENANCEITEM.MANDT == T353I.MANDT`
Order number Client Order number	`ESH_N_MAINTENANCEITEM.MANDT == AUFK.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEORDER == AUFK.AUFNR`
Maintenance plan Client Maintenance Plan	`ESH_N_MAINTENANCEITEM.MANDT == MPLA.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Plant Client Maintenance Plant	`ESH_N_MAINTENANCEITEM.MANDT == T001W.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEPLANT == T001W.WERKS`
Maintenance strategy Client Maintenance Strategy	`ESH_N_MAINTENANCEITEM.MANDT == T351.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCESTRATEGY == T351.STRAT`
Priority ? Client Priority	`ESH_N_MAINTENANCEITEM.[column in domain "ARTPR"] == T356.ARTPR` `ESH_N_MAINTENANCEITEM.MANDT == T356.MANDT` `ESH_N_MAINTENANCEITEM.MAINTPRIORITY == T356.PRIOK`
Plant Client Plant	`ESH_N_MAINTENANCEITEM.MANDT == T001W.MANDT` `ESH_N_MAINTENANCEITEM.MAINWORKCENTERPLANT == T001W.WERKS`
Material number Material Number Client	`ESH_N_MAINTENANCEITEM.MATERIAL == MARA.MATNR` `ESH_N_MAINTENANCEITEM.MANDT == MARA.MANDT`
TASK LIST TYPE Client Task List Type	`ESH_N_MAINTENANCEITEM.MANDT == TCA01.MANDT` `ESH_N_MAINTENANCEITEM.TASKLISTTYPE == TCA01.PLNTY`

Other Relations \| to Master Data Relations ↑	Join Conditions
Maintenance plan category Client Maintenance plan category Maintenance item category	`ESH_N_MAINTENANCEITEM.MANDT == T399P.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEPLANCATEGORY == T399P.MITYP` `ESH_N_MAINTENANCEITEM.MAINTOBJECTCATEGORY == T399P.MITYP`
Maintenance planner group Maintenance Planning Plant Client Planner Group for Customer Service and Plant Maintenance	`ESH_N_MAINTENANCEITEM.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `ESH_N_MAINTENANCEITEM.MANDT == T024I.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEPLANNERGROUP == T024I.INGRP`
Maintenance Planning Plant Maintenance Planning Plant Client	`ESH_N_MAINTENANCEITEM.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `ESH_N_MAINTENANCEITEM.MANDT == T399I.MANDT`
Maintenance item category Client Maintenance plan category Maintenance item category	`ESH_N_MAINTENANCEITEM.MANDT == T399P.MANDT` `ESH_N_MAINTENANCEITEM.MAINTENANCEPLANCATEGORY == T399P.MITYP` `ESH_N_MAINTENANCEITEM.MAINTOBJECTCATEGORY == T399P.MITYP`