I_MaintNotificationActyData

Maintenance Notification Activity Data | view: INOTIFACTYDATA | TRAN | Extraction: Full only | Component: Maintenance Notifications
Tables used: QMEL, QMFE, QMMA, QMIH, ILOA
Column Name Description
MaintNotificationActivity Consecutive Number of Activity
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
MaintNotifActyTxt Activity Text TEXT40
MaintNotificationActivityCode Activity 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
NumberOfMaintNotifActivities No. of activities INT4
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Assembly
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONACTYDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == MARA.MANDT
Assembly
  • Assembly
  • Assembly
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTNOTIFICATIONACTYDATA.ASSEMBLYHEADER == MARA.MATNR
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == MARA.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == TKA01.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • Controlling Area
  • I_MAINTNOTIFICATIONACTYDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTNOTIFICATIONACTYDATA.COSTCENTER == CSKS.KOSTL
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == CSKS.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.CONTROLLINGAREA == CSKS.KOKRS
Defect Class
  • Defect Class
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == TQ17.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.EQUIPMENT == EQUI.EQUNR
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == IFLOT.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == T001W.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.MAINTENANCEPLANT == T001W.WERKS
Activity Code Catalog
  • Activity Code Catalog
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFACTIVITYCODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == TQ15.MANDT
Activity Code Group
  • Activity Code Catalog
  • Client
  • Activity Code Group
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFACTIVITYCODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFACTIVITYCODEGROUP == QPGR.CODEGRUPPE
Damage Code Catalog
  • Damage Code Catalog
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == TQ15.MANDT
Damage Code Group
  • Damage Code Group
  • Damage Code Catalog
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == QPGR.MANDT
Object Part Code Catalog
  • Object Part Code Catalog
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == TQ15.MANDT
Object Part Code Group
  • Object Part Code Catalog
  • Client
  • Object Part Code Group
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == QPGR.MANDT
  • I_MAINTNOTIFICATIONACTYDATA.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE
Notification Type
  • Notification Type
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTNOTIFICATIONACTYDATA.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_MAINTNOTIFICATIONACTYDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTNOTIFICATIONACTYDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTNOTIFICATIONACTYDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTNOTIFICATIONACTYDATA.MANDT == T399I.MANDT