I_MaintNotificationCauseData

Maintenance Notification Cause Data | view: INOTIFCAUSEDATA | TRAN | Extraction: Full only | Component: Maintenance Notifications
Tables used: QMEL, QMUR, QMFE, QMIH, ILOA
Column Name Description
MaintenanceNotificationCause Sequential Number for Cause
MaintenanceNotification FK Notification Number
MaintenanceNotificationItem FK Item Number in Item Record
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
MaintNotifCauseText Cause Text TEXT40
MaintNotificationCauseCode Cause 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
NumberOfMaintNotifCauses No. of causes INT4
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Client
  • Assembly
  • Assembly
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == MARA.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONCAUSEDATA.ASSEMBLY == MARA.MATNR
Assembly
  • Client
  • Assembly
  • Assembly
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == MARA.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONCAUSEDATA.ASSEMBLY == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TKA01.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == CSKS.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.COSTCENTER == CSKS.KOSTL
  • I_MAINTNOTIFICATIONCAUSEDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTNOTIFICATIONCAUSEDATA.CONTROLLINGAREA == CSKS.KOKRS
Defect Class
  • Client
  • Defect Class
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TQ17.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.DEFECTCLASS == TQ17.FEHLKLASSE
Equipment Number
  • Client
  • Equipment Number
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == EQUI.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == IFLOT.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == T001W.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTENANCEPLANT == T001W.WERKS
Cause Code Catalog
  • Client
  • Cause Code Catalog
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFCAUSECODECATALOG == TQ15.KATALOGART
Cause Code Group
  • Client
  • Cause Code Group
  • Cause Code Catalog
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFCAUSECODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFCAUSECODECATALOG == QPGR.KATALOGART
Damage Code Catalog
  • Client
  • Damage Code Catalog
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART
Damage Code Group
  • Client
  • Damage Code Catalog
  • Damage Code Group
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE
Object Part Code Catalog
  • Client
  • Object Part Code Catalog
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TQ15.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART
Object Part Code Group
  • Client
  • Object Part Code Group
  • Object Part Code Catalog
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART
Notification Type
  • Client
  • Notification Type
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == TQ80.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.NOTIFICATIONTYPE == TQ80.QMART
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == T024I.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTNOTIFICATIONCAUSEDATA.MANDT == T399I.MANDT
  • I_MAINTNOTIFICATIONCAUSEDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK