P_MaintNotificationSearch

Maintenance Notification anchor view for CDS search model | view: PNOTIFSEARCH | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, QMIH
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
LatestAcceptableCompletionDate Final Due Date
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
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
Master Data Relations Join Conditions
Catalog Profile
  • Catalog Profile
  • Client
  • P_MAINTNOTIFICATIONSEARCH.CATALOGPROFILE == T352B.RBNR
  • P_MAINTNOTIFICATIONSEARCH.MANDT == T352B.MANDT
Order Number
  • Order Number
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTNOTIFICATIONSEARCH.MANDT == AUFK.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • P_MAINTNOTIFICATIONSEARCH.MANDT == T001W.MANDT
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
  • P_MAINTNOTIFICATIONSEARCH.MANDT == TQ15.MANDT
Code Group - Coding
  • Code Group - Coding
  • Catalog Type - Coding
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • P_MAINTNOTIFICATIONSEARCH.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
  • P_MAINTNOTIFICATIONSEARCH.MANDT == QPGR.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTNOTIFICATIONSEARCH.MAINTPRIORITY == T356.PRIOK
  • P_MAINTNOTIFICATIONSEARCH.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • P_MAINTNOTIFICATIONSEARCH.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_MAINTNOTIFICATIONSEARCH.MANDT == T356A.MANDT
Time Zone for Notification
  • Time Zone for Notification
  • Client
  • P_MAINTNOTIFICATIONSEARCH.NOTIFICATIONTIMEZONE == TTZZ.TZONE
  • P_MAINTNOTIFICATIONSEARCH.MANDT == TTZZ.CLIENT
Notification Type
  • Notification Type
  • Client
  • P_MAINTNOTIFICATIONSEARCH.NOTIFICATIONTYPE == TQ80.QMART
  • P_MAINTNOTIFICATIONSEARCH.MANDT == TQ80.MANDT
Foreign key work center
  • Object ID of the Work Center
  • ?
  • Client
  • P_MAINTNOTIFICATIONSEARCH.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTNOTIFICATIONSEARCH.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MAINTNOTIFICATIONSEARCH.MANDT == CRID.MANDT