I_MaintNotificationItemData

Maintenance Notification Item Data | view: INOTIFITEMDATA | TRAN | Extraction: Full only | Component: Maintenance Notifications
Tables used: QMEL, QMFE, QMIH, EAML_D_LFE_DATA, ILOA
Column Name Description
MaintenanceNotificationItem Item Number in Item Record
MaintenanceNotification FK Notification Number
Column Name Description
Column Name Description
📏 Unit of Measurement for Linear Data (LinearDataUnitOfMeasure):
LinearDataLength null
Column Name Description
NotificationCreationDate Date of Notification
Column Name Description
NotificationOrigin Origin of Notification Show values
Column Name Description Domain name
MaintNotifItemText Notification Item Short Text TEXT40
MaintNotificationDamageCode Damage Code QCODE
IsDeleted Delete Data Record CHAR1
MaintNotifObjPrtCode Object Part Code QCODE
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LinearDataStartPoint Start Point EAML_POINT
LinearDataEndPoint End Point EAML_POINT
NumberOfDefects Problem Frequency INT4
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Client
  • Assembly
  • Assembly
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == MARA.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONITEMDATA.ASSEMBLYHEADER == MARA.MATNR
Assembly
  • Client
  • Assembly
  • Assembly
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == MARA.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONITEMDATA.ASSEMBLYHEADER == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == TKA01.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_MAINTNOTIFICATIONITEMDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == CSKS.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTNOTIFICATIONITEMDATA.COSTCENTER == CSKS.KOSTL
Defect Class
  • Client
  • Defect Class
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == TQ17.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.DEFECTCLASS == TQ17.FEHLKLASSE
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTNOTIFICATIONITEMDATA.EQUIPMENT == EQUI.EQUNR
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == IFLOT.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == T001W.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTENANCEPLANT == T001W.WERKS
Damage Code Catalog
  • Client
  • Damage Code Catalog
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART
Damage Code Group
  • Client
  • Damage Code Group
  • Damage Code Catalog
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART
Object Part Code Catalog
  • Client
  • Object Part Code Catalog
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART
Object Part Code Group
  • Client
  • Object Part Code Catalog
  • Object Part Code Group
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONITEMDATA.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE
Notification Type
  • Client
  • Notification Type
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == TQ80.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.NOTIFICATIONTYPE == TQ80.QMART
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == T024I.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTNOTIFICATIONITEMDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTNOTIFICATIONITEMDATA.MANDT == T399I.MANDT
  • I_MAINTNOTIFICATIONITEMDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK