ESH_S_MAINTNOTIFICATION

Search view -MAINTNOTIFICATION | view: ESH_U_MAINTNOTIF | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, QMUR, QMFE, QMSM, AFIH, AFKO, QMMA, QMIH, ESH_SR_LTXT, EQUI, EQUZ, IFLOS, IFLOT, ILOA, T353I, T353I_T, AUFK, T356, T356_T, NRIV, TQ80, TQ80_T, CRHD, ITOBCUST, IFLOUSR, TPAER
Column Name Description
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
Column Name Description
NotificationReferenceDate Notification Reference Date
RequiredEndDate Required End Date
RequiredStartDate Required Start Date
LatestAcceptableCompletionDate Final Due Date
Column Name Description
MaintenanceObjectIsDown Breakdown Indicator Show values
Column Name Description Domain name
PlainLongText Long Text
MaintenanceActivityTypeName Description of maintenance activity type
WorkCenter Work Center ARBPL
MaintenanceRevision Revision for Plant Maintenance and Customer Service REVNI
NotificationTypeName Notification Type Text TEXT20
MaintPriorityDesc Priority Text TEXT20
MaintNotifTaskTxt Short Text for Task TEXT40
MaintNotifActyTxt Activity Text TEXT40
MaintNotifCauseText Cause Text TEXT40
MaintNotifItemText Notification Item Short Text TEXT40
MaintNotificationCode Coding QCODE
NotificationText Short Text TEXT40
ReportedByUser Name of Person Reporting Notification USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
NotifProcessingPhase Notification Processing Phase
NotifProcessingPhaseDesc Short Text for Fixed Values
FuncnlLocPrimaryLabelName Functional Location Label
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • ESH_S_MAINTNOTIFICATION.ASSEMBLY == MARA.MATNR
  • ESH_S_MAINTNOTIFICATION.MANDT == MARA.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_S_MAINTNOTIFICATION.AUTHGROUPFL == T370B.BEGRU
  • ESH_S_MAINTNOTIFICATION.AUTHGROUPEQ == T370B.BEGRU
  • ESH_S_MAINTNOTIFICATION.MANDT == T370B.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_S_MAINTNOTIFICATION.AUTHGROUPFL == T370B.BEGRU
  • ESH_S_MAINTNOTIFICATION.AUTHGROUPEQ == T370B.BEGRU
  • ESH_S_MAINTNOTIFICATION.MANDT == T370B.MANDT
Controlling Area
  • Client
  • Controlling Area
  • ESH_S_MAINTNOTIFICATION.MANDT == TKA01.MANDT
  • ESH_S_MAINTNOTIFICATION.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • ?
  • Client
  • Controlling Area
  • ESH_S_MAINTNOTIFICATION.COSTCENTER == CSKS.KOSTL
  • ESH_S_MAINTNOTIFICATION.[column in domain "DATBI"] == CSKS.DATBI
  • ESH_S_MAINTNOTIFICATION.MANDT == CSKS.MANDT
  • ESH_S_MAINTNOTIFICATION.CONTROLLINGAREA == CSKS.KOKRS
Equipment Number
  • Client
  • Equipment Number
  • ESH_S_MAINTNOTIFICATION.MANDT == EQUI.MANDT
  • ESH_S_MAINTNOTIFICATION.EQUIPMENT == EQUI.EQUNR
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • ESH_S_MAINTNOTIFICATION.MANDT == T353I.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEACTIVITYTYPE == T353I.ILART
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • ESH_S_MAINTNOTIFICATION.MANDT == T499S.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANT == T499S.WERKS
Order Number
  • Order Number
  • Client
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEORDER == AUFK.AUFNR
  • ESH_S_MAINTNOTIFICATION.MANDT == AUFK.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • ESH_S_MAINTNOTIFICATION.MANDT == T001W.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANT == T001W.WERKS
Catalog Type - Coding
  • Client
  • Catalog Type - Coding
  • ESH_S_MAINTNOTIFICATION.MANDT == TQ15.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
Code Group - Coding
  • Code Group - Coding
  • Client
  • Catalog Type - Coding
  • ESH_S_MAINTNOTIFICATION.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • ESH_S_MAINTNOTIFICATION.MANDT == QPGR.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
Priority
  • Priority Type
  • Client
  • Priority
  • ESH_S_MAINTNOTIFICATION.MAINTPRIORITYTYPE == T356.ARTPR
  • ESH_S_MAINTNOTIFICATION.MANDT == T356.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • ESH_S_MAINTNOTIFICATION.MAINTPRIORITYTYPE == T356A.ARTPR
  • ESH_S_MAINTNOTIFICATION.MANDT == T356A.MANDT
Notification Type
  • Notification Type
  • Client
  • ESH_S_MAINTNOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
  • ESH_S_MAINTNOTIFICATION.MANDT == TQ80.MANDT
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • ESH_S_MAINTNOTIFICATION.PLANTSECTION == T357.BEBER
  • ESH_S_MAINTNOTIFICATION.MANDT == T357.MANDT
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANT == T357.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • ESH_S_MAINTNOTIFICATION.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • ESH_S_MAINTNOTIFICATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • ESH_S_MAINTNOTIFICATION.MANDT == T399I.MANDT