ESH_S_MAINTENANCEITEM

Search view -MAINTENANCEITEM | view: ESH_U_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 (18)
🔗 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
OperationSystemConditionText	Text on Operating Condition
WorkCenter	Work Center	ARBPL
FuncnlLocPrimaryLabelName	Functional Location Label
FuncLocLabel	null
FunctionalLocationName	Description of functional location
TaskListGroupCounter	Group Counter	ALTNR
TaskListGroup	Key for Task List Group	PLNNR
OperationSystemCondition	System Condition	ANLZU
MaintenanceItemDescription	Item Short Text
LastChangedByUser	Name of Person Who Changed Object	USNAM
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
MaintenanceActivityTypeName	Description of maintenance activity type
NotificationText	Short Text	TEXT40
MaintenancePlannerGroupName	Name of the Maintenance Planner Group
MaintenanceStrategyDesc	Description of maintenance strategy
TaskListDesc	Routing Description
PlainLongText	Long Text

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

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