I_MaintNotificationTP

Maintenance Notification Tech. Object | view: IMAINTNTFTETP | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, QMIH, JSTO, JEST, BUT000, ILOA, ADCP, ADR6, ADRC, ADRP, USR21, CRHD, ADR2, ADR2
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
CompletionTime Completion Time of Notification
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionStartTime Start of Malfunction (Time)
MalfunctionEndDate End of Malfunction (Date)
MalfunctionEndTime End of Malfunction (Time)
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
NotifProcessingPhase Notification Processing Phase Show values
WorkCenterTypeCode Object types of the CIM resource Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
MaintNotifSourceApplication Source Application Show values
Column Name Description Domain name
MaintNotificationForEdit Notification Number QMNUM
TechnicalObject Technical Object EAMS_TEC_OBJ
TechnicalObjectForEdit Technical Object Identifier EAMS_TECH_OBJ_CONV
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
PersonResponsible Person Responsible ID I_PARNR
NotificationText Short Text TEXT40
MaintenanceWorkCenter Work Center ARBPL
MaintNotificationCode Coding QCODE
IsDeleted Object is deleted CHAR1
IsCompleted Object is completed CHAR1
LocationDescription Description of Current Location PM_LOC_DESC
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintObjectDowntimeDuration Breakdown Duration FLTP
NotificationHasLongText Object Long Text Available CHAR1
ReporterFullName Full Name of Person TEXT80
MaintenanceItem null
MaintenancePlanItemIntID Maintenance item POSNU
HierarchyNodeLevel null
Master Data Relations Join Conditions
Catalog Profile
  • Client
  • Catalog Profile
  • I_MAINTNOTIFICATIONTP.MANDT == T352B.MANDT
  • I_MAINTNOTIFICATIONTP.CATALOGPROFILE == T352B.RBNR
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTNOTIFICATIONTP.EQUIPMENT == EQUI.EQUNR
  • I_MAINTNOTIFICATIONTP.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • I_MAINTNOTIFICATIONTP.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_MAINTNOTIFICATIONTP.MANDT == IFLOT.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTNOTIFICATIONTP.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTNOTIFICATIONTP.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • I_MAINTNOTIFICATIONTP.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTNOTIFICATIONTP.MANDT == AUFK.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_MAINTNOTIFICATIONTP.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • I_MAINTNOTIFICATIONTP.MANDT == T001W.MANDT
Catalog Type - Coding
  • Client
  • Catalog Type - Coding
  • I_MAINTNOTIFICATIONTP.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
Code Group - Coding
  • Code Group - Coding
  • Client
  • Catalog Type - Coding
  • I_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONTP.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
Unit for Breakdown Duration
  • Client
  • Unit for Breakdown Duration
  • I_MAINTNOTIFICATIONTP.MANDT == T006.MANDT
  • I_MAINTNOTIFICATIONTP.MAINTOBJDOWNTIMEDURATIONUNIT == T006.MSEHI
Priority
  • Priority Type
  • Priority
  • Client
  • I_MAINTNOTIFICATIONTP.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTNOTIFICATIONTP.MAINTPRIORITY == T356.PRIOK
  • I_MAINTNOTIFICATIONTP.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • I_MAINTNOTIFICATIONTP.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTNOTIFICATIONTP.MANDT == T356A.MANDT
Effect on Operation
  • Effect on Operation
  • Client
  • I_MAINTNOTIFICATIONTP.MALFUNCTIONEFFECT == T357A.AUSWK
  • I_MAINTNOTIFICATIONTP.MANDT == T357A.MANDT
Time Zone for Notification
  • Time Zone for Notification
  • Client
  • I_MAINTNOTIFICATIONTP.NOTIFICATIONTIMEZONE == TTZZ.TZONE
  • I_MAINTNOTIFICATIONTP.MANDT == TTZZ.CLIENT
Notification Type
  • Notification Type
  • Client
  • I_MAINTNOTIFICATIONTP.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTNOTIFICATIONTP.MANDT == TQ80.MANDT
Foreign key work center
  • ?
  • Work Center
  • Object ID of the Work Center
  • Client
  • I_MAINTNOTIFICATIONTP.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTNOTIFICATIONTP.MAINTENANCEWORKCENTER == CRID.OBJID
  • I_MAINTNOTIFICATIONTP.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTNOTIFICATIONTP.MANDT == CRID.MANDT