I_QualityNotificationItem_TP

Quality Notification Item | view: IQLTYNTFITMTP | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMELQMFECRHD
Column Name Description
QualityNotification FK Notification Number
NotificationItem Item Number in Item Record
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime System Time of Creation
LastChangeTime System Time of Change
Column Name Description
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
NotificationItemText Notification Item Short Text TEXT40
DefectCode Defect Code QCODE
NotifItmObjectPartCode Defect Location Code QCODE
IsDeleted Delete Data Record CHAR1
ReferencedDefect Defect Key QDEFREFNUM
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Catalog Type - Problems/Defects
  • Catalog Type - Problems/Defects
  • Client
  • I_QUALITYNOTIFICATIONITEM_TP.DEFECTCODECATALOG == TQ15.KATALOGART
  • I_QUALITYNOTIFICATIONITEM_TP.MANDT == TQ15.MANDT
Defect Code Group
  • Defect Code Group
  • Catalog Type - Problems/Defects
  • Client
  • I_QUALITYNOTIFICATIONITEM_TP.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_QUALITYNOTIFICATIONITEM_TP.DEFECTCODECATALOG == QPGR.KATALOGART
  • I_QUALITYNOTIFICATIONITEM_TP.MANDT == QPGR.MANDT
Defect Location Catalog
  • Client
  • Defect Location Catalog
  • I_QUALITYNOTIFICATIONITEM_TP.MANDT == TQ15.MANDT
  • I_QUALITYNOTIFICATIONITEM_TP.NOTIFITMOBJECTPARTCODECTLG == TQ15.KATALOGART
Defect Location Code Group
  • Client
  • Defect Location Code Group
  • Defect Location Catalog
  • I_QUALITYNOTIFICATIONITEM_TP.MANDT == QPGR.MANDT
  • I_QUALITYNOTIFICATIONITEM_TP.NOTIFITMOBJECTPARTCODEGROUP == QPGR.CODEGRUPPE
  • I_QUALITYNOTIFICATIONITEM_TP.NOTIFITMOBJECTPARTCODECTLG == QPGR.KATALOGART