ESH_N_MAINTNOTIFICATION

Anchor view -MAINTNOTIFICATION | view: ESH_L_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
RequiredStartDate Required Start Date
RequiredEndDate Required End Date
NotificationReferenceDate Notification Reference Date
LatestAcceptableCompletionDate Final Due Date
Column Name Description
NotifProcessingPhase Notification Processing Phase Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
Column Name Description Domain name
FuncnlLocPrimaryLabelName Functional Location Label ILOM_STRNO
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ReportedByUser Name of Person Reporting Notification USNAM
NotificationText Short Text TEXT40
NotificationHasLongText Object Long Text Available CHAR1
MaintNotificationCode Coding QCODE
MaintNotifItemText Notification Item Short Text TEXT40
MaintNotifCauseText Cause Text TEXT40
MaintNotifActyTxt Activity Text TEXT40
MaintNotifTaskTxt Short Text for Task TEXT40
NotifProcessingPhaseDesc Short Text for Fixed Values DDTEXT
MaintPriorityDesc Priority Text TEXT20
NotificationTypeName Notification Type Text TEXT20
SerialNumber Serial Number GERNR
MaintenanceRevision Revision for Plant Maintenance and Customer Service REVNI
WorkCenter Work Center ARBPL
MaintenanceActivityTypeName Description of maintenance activity type TXT30
PlainLongText Long Text
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • ESH_N_MAINTNOTIFICATION.ASSEMBLY == MARA.MATNR
  • ESH_N_MAINTNOTIFICATION.MANDT == MARA.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_N_MAINTNOTIFICATION.AUTHGROUPFL == T370B.BEGRU
  • ESH_N_MAINTNOTIFICATION.AUTHGROUPEQ == T370B.BEGRU
  • ESH_N_MAINTNOTIFICATION.MANDT == T370B.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_N_MAINTNOTIFICATION.AUTHGROUPFL == T370B.BEGRU
  • ESH_N_MAINTNOTIFICATION.AUTHGROUPEQ == T370B.BEGRU
  • ESH_N_MAINTNOTIFICATION.MANDT == T370B.MANDT
Controlling Area
  • Controlling Area
  • Client
  • ESH_N_MAINTNOTIFICATION.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_N_MAINTNOTIFICATION.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • ESH_N_MAINTNOTIFICATION.CONTROLLINGAREA == CSKS.KOKRS
  • ESH_N_MAINTNOTIFICATION.COSTCENTER == CSKS.KOSTL
  • ESH_N_MAINTNOTIFICATION.[column in domain "DATBI"] == CSKS.DATBI
  • ESH_N_MAINTNOTIFICATION.MANDT == CSKS.MANDT
Equipment Number
  • Equipment Number
  • Client
  • ESH_N_MAINTNOTIFICATION.EQUIPMENT == EQUI.EQUNR
  • ESH_N_MAINTNOTIFICATION.MANDT == EQUI.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • ESH_N_MAINTNOTIFICATION.MANDT == T353I.MANDT
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • ESH_N_MAINTNOTIFICATION.MANDT == T499S.MANDT
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEPLANT == T499S.WERKS
Order Number
  • Order Number
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEORDER == AUFK.AUFNR
  • ESH_N_MAINTNOTIFICATION.MANDT == AUFK.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • ESH_N_MAINTNOTIFICATION.MANDT == T001W.MANDT
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEPLANT == T001W.WERKS
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
  • ESH_N_MAINTNOTIFICATION.MANDT == TQ15.MANDT
Code Group - Coding
  • Code Group - Coding
  • Catalog Type - Coding
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • ESH_N_MAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
  • ESH_N_MAINTNOTIFICATION.MANDT == QPGR.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • ESH_N_MAINTNOTIFICATION.MAINTPRIORITYTYPE == T356.ARTPR
  • ESH_N_MAINTNOTIFICATION.MANDT == T356.MANDT
  • ESH_N_MAINTNOTIFICATION.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTPRIORITYTYPE == T356A.ARTPR
  • ESH_N_MAINTNOTIFICATION.MANDT == T356A.MANDT
Notification Type
  • Client
  • Notification Type
  • ESH_N_MAINTNOTIFICATION.MANDT == TQ80.MANDT
  • ESH_N_MAINTNOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • ESH_N_MAINTNOTIFICATION.PLANTSECTION == T357.BEBER
  • ESH_N_MAINTNOTIFICATION.MANDT == T357.MANDT
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEPLANT == T357.WERKS
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_MAINTNOTIFICATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • ESH_N_MAINTNOTIFICATION.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • ESH_N_MAINTNOTIFICATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • ESH_N_MAINTNOTIFICATION.MANDT == T399I.MANDT