I_MaintNotificationTaskData

Maintenance Notification Task Data | view: INOTIFTASKDATA | TRAN | Extraction: Full only | Component: Maintenance Notifications
Tables used: QMEL, QMFE, QMSM, QMIH, JSTO, JEST, ILOA
Column Name Description
MaintenanceNotificationTask Sequential Task Number
MaintenanceNotification FK Notification Number
Column Name Description
Column Name Description
Column Name Description
NotificationCreationDate Date of Notification
Column Name Description
NotificationOrigin Origin of Notification Show values
Column Name Description Domain name
MaintNotifTaskTxt Short Text for Task TEXT40
MaintNotifTaskCode Task Code QCODE
IsDeleted Delete Data Record CHAR1
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintNotificationDamageCode Damage Code QCODE
MaintNotifObjPrtCode Object Part Code QCODE
NumberOfMaintNotifTasks No. of Tasks INT4
NrOfMaintNotifSuccssflTasks No. of Tasks with Status Successful INT4
NrOfMaintNotifActiveTasks Number of Tasks with Status 'Outstanding' or 'Released' INT4
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Assembly
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONTASKDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == MARA.MANDT
Assembly
  • Assembly
  • Assembly
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONTASKDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == MARA.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.COSTCENTER == CSKS.KOSTL
  • I_MAINTNOTIFICATIONTASKDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTNOTIFICATIONTASKDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == CSKS.MANDT
Defect Class
  • Defect Class
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TQ17.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.EQUIPMENT == EQUI.EQUNR
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == IFLOT.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == T001W.MANDT
  • I_MAINTNOTIFICATIONTASKDATA.MAINTENANCEPLANT == T001W.WERKS
Damage Code Catalog
  • Damage Code Catalog
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TQ15.MANDT
Damage Code Group
  • Damage Code Catalog
  • Damage Code Group
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == QPGR.MANDT
Object Part Code Catalog
  • Object Part Code Catalog
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TQ15.MANDT
Object Part Code Group
  • Object Part Code Catalog
  • Client
  • Object Part Code Group
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE
Catalog Type - Tasks
  • Catalog Type - Tasks
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFTASKCODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TQ15.MANDT
Code Group - Tasks
  • Code Group - Tasks
  • Catalog Type - Tasks
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFTASKCODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONTASKDATA.MAINTNOTIFTASKCODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == QPGR.MANDT
Notification Type
  • Notification Type
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == TQ80.MANDT
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
  • I_MAINTNOTIFICATIONTASKDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTNOTIFICATIONTASKDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTNOTIFICATIONTASKDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTNOTIFICATIONTASKDATA.MANDT == T399I.MANDT