C_MaintNotificationTP

Maintenance Notification | view: CMAINTNOTIFTP | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, QMIH, JSTO, JEST, BUT000, ILOA, ADCP, ADR6, ADRC, ADRP, USR21, T356, 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
MaintNotifSourceApplication Source Application Show values
MaintenanceObjectIsDown Breakdown Indicator Show values
Column Name Description Domain name
MaintNotificationForEdit Notification Number QMNUM
TechnicalObject Technical Object EAMS_TEC_OBJ
HierarchyNodeLevel null
TechnicalObjectForEdit Technical Object Identifier EAMS_TECH_OBJ_CONV
MaintPriorityColorCode null
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
NotificationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintNotificationCode Coding
IsDeleted Object is deleted CHAR1
IsCompleted Object is completed CHAR1
LocationDescription Description of Current Location PM_LOC_DESC
MaintObjectDowntimeDuration Breakdown Duration FLTP
ReporterFullName Full Name of Person TEXT80
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PersonResponsible Person Responsible ID I_PARNR
Master Data Relations Join Conditions
Catalog Profile
  • Client
  • Catalog Profile
  • C_MAINTNOTIFICATIONTP.MANDT == T352B.MANDT
  • C_MAINTNOTIFICATIONTP.CATALOGPROFILE == T352B.RBNR
Equipment Number
  • Equipment Number
  • Client
  • C_MAINTNOTIFICATIONTP.EQUIPMENT == EQUI.EQUNR
  • C_MAINTNOTIFICATIONTP.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • C_MAINTNOTIFICATIONTP.FUNCTIONALLOCATION == IFLOT.TPLNR
  • C_MAINTNOTIFICATIONTP.MANDT == IFLOT.MANDT
Order Number
  • Order Number
  • Client
  • C_MAINTNOTIFICATIONTP.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTNOTIFICATIONTP.MANDT == AUFK.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • C_MAINTNOTIFICATIONTP.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • C_MAINTNOTIFICATIONTP.MANDT == T001W.MANDT
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • C_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
  • C_MAINTNOTIFICATIONTP.MANDT == TQ15.MANDT
Code Group - Coding
  • Code Group - Coding
  • Catalog Type - Coding
  • Client
  • C_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • C_MAINTNOTIFICATIONTP.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
  • C_MAINTNOTIFICATIONTP.MANDT == QPGR.MANDT
Unit for Breakdown Duration
  • Client
  • Unit for Breakdown Duration
  • C_MAINTNOTIFICATIONTP.MANDT == T006.MANDT
  • C_MAINTNOTIFICATIONTP.MAINTOBJDOWNTIMEDURATIONUNIT == T006.MSEHI
Priority
  • Priority Type
  • Client
  • Priority
  • C_MAINTNOTIFICATIONTP.MAINTPRIORITYTYPE == T356.ARTPR
  • C_MAINTNOTIFICATIONTP.MANDT == T356.MANDT
  • C_MAINTNOTIFICATIONTP.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • C_MAINTNOTIFICATIONTP.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_MAINTNOTIFICATIONTP.MANDT == T356A.MANDT
Effect on Operation
  • Client
  • Effect on Operation
  • C_MAINTNOTIFICATIONTP.MANDT == T357A.MANDT
  • C_MAINTNOTIFICATIONTP.MALFUNCTIONEFFECT == T357A.AUSWK
Time Zone for Notification
  • Time Zone for Notification
  • Client
  • C_MAINTNOTIFICATIONTP.NOTIFICATIONTIMEZONE == TTZZ.TZONE
  • C_MAINTNOTIFICATIONTP.MANDT == TTZZ.CLIENT
Notification Type
  • Notification Type
  • Client
  • C_MAINTNOTIFICATIONTP.NOTIFICATIONTYPE == TQ80.QMART
  • C_MAINTNOTIFICATIONTP.MANDT == TQ80.MANDT
Foreign key work center
  • Object ID of the Work Center
  • ?
  • Client
  • C_MAINTNOTIFICATIONTP.WORKCENTERINTERNALID == CRID.OBJID
  • C_MAINTNOTIFICATIONTP.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MAINTNOTIFICATIONTP.MANDT == CRID.MANDT