I_MaintenanceNotification

Maintenance Notification | view: IMAINTNOTIF | TRAN | Extraction: Not supported | Component: Maintenance Notifications
Tables used: QMEL
Column Name Description
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeTime Time of Change
LastChangeDate Last Changed On
CreationTime Time at Which Record Was Added
RequiredStartDate Required Start Date
RequiredStartTime Required Start Time
RequiredEndDate Required End Date
RequiredEndTime Required End Time
NotificationCreationDate Date of Notification
NotificationCreationTime Time of Notification
NotificationReferenceDate Notification Reference Date
NotificationReferenceTime Notification Reference Time
NotificationCompletionDate Date for Notification Completion
NotificationCompletionTime Completion Time of Notification
Column Name Description
NotifProcessingPhase Notification Processing Phase Show values
WorkCenterTypeCode Object types of the CIM resource Show values
NotificationOrigin Origin of Notification Show values
Column Name Description Domain name
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
CreationDateTime Creation Time Stamp EAM_TIMESTAMP
NotificationText Short Text TEXT40
LongTextLanguage Primary language indicator for text segment CHAR1
NotificationHasLongText Object Long Text Available CHAR1
MaintNotificationCode Coding QCODE
IsDeleted Object is deleted CHAR1
IsCompleted Object is completed CHAR1
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SerialNumber Serial Number GERNR
AdditionalDeviceData Additional Device Data DEVICEID
MaintNotifExtReferenceNumber External Reference Number CHAR020
MasterLanguage Master Language SPRAS
DfsMaintNotificationObjectNmbr Object number J_OBJNR
Master Data Relations Join Conditions
Catalog Profile
  • Client
  • Catalog Profile
  • I_MAINTENANCENOTIFICATION.MANDT == T352B.MANDT
  • I_MAINTENANCENOTIFICATION.CATALOGPROFILE == T352B.RBNR
Order Number
  • Order Number
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTENANCENOTIFICATION.MANDT == AUFK.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • I_MAINTENANCENOTIFICATION.MANDT == T001W.MANDT
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
  • I_MAINTENANCENOTIFICATION.MANDT == TQ15.MANDT
Code Group - Coding
  • Code Group - Coding
  • Catalog Type - Coding
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTENANCENOTIFICATION.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
  • I_MAINTENANCENOTIFICATION.MANDT == QPGR.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTENANCENOTIFICATION.MAINTPRIORITY == T356.PRIOK
  • I_MAINTENANCENOTIFICATION.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • I_MAINTENANCENOTIFICATION.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTENANCENOTIFICATION.MANDT == T356A.MANDT
Material Number
  • Material Number
  • Client
  • I_MAINTENANCENOTIFICATION.MATERIAL == MARA.MATNR
  • I_MAINTENANCENOTIFICATION.MANDT == MARA.MANDT
Time Zone for Notification
  • Time Zone for Notification
  • Client
  • I_MAINTENANCENOTIFICATION.NOTIFICATIONTIMEZONE == TTZZ.TZONE
  • I_MAINTENANCENOTIFICATION.MANDT == TTZZ.CLIENT
Notification Type
  • Notification Type
  • Client
  • I_MAINTENANCENOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTENANCENOTIFICATION.MANDT == TQ80.MANDT
Foreign key work center
  • Object ID of the Work Center
  • ?
  • Client
  • I_MAINTENANCENOTIFICATION.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCENOTIFICATION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTENANCENOTIFICATION.MANDT == CRID.MANDT