I_QualityNotificationItem

Quality Notification Item | view: IQLTYNTFITM | ATTR | Extraction: Not supported | Component: Quality Notifications
Tables used: QMEL, QMFE, CRHD
Column Name Description
QualityNotification FK Notification Number
NotificationItem Item Number in Item Record
Column Name Description
Column Name Description
📏 Unit of Measure for Item (DefectiveQuantityUnit):
DefectiveQuantity Defective Quantity for Item (Internal)
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
NotifProcessingPhase Notification Processing Phase Show values
WorkCenterTypeCode Object types of the CIM resource Show values
DefectOrigin Origin of Item Record Show values
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
MasterLanguage Primary language indicator for text segment CHAR1
NumberOfDefects Number of Defect Occurrences QANZAHL4
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
DefectiveSingleUnit Single-Unit Number for Unit to Be Inspected QSERIALNR
MainWorkCenter Work Center ARBPL
IsDeleted Delete Data Record CHAR1
NotificationItemExternalID Quality Notification External Item Number QFELFD
ReferencedDefect Defect Key QDEFREFNUM
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • I_QUALITYNOTIFICATIONITEM.ASSEMBLY == MARA.MATNR
  • I_QUALITYNOTIFICATIONITEM.MANDT == MARA.MANDT
Defect Class
  • Defect Class
  • Client
  • I_QUALITYNOTIFICATIONITEM.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_QUALITYNOTIFICATIONITEM.MANDT == TQ17.MANDT
Catalog Type - Problems/Defects
  • Client
  • Catalog Type - Problems/Defects
  • I_QUALITYNOTIFICATIONITEM.MANDT == TQ15.MANDT
  • I_QUALITYNOTIFICATIONITEM.DEFECTCODECATALOG == TQ15.KATALOGART
Defect Code Group
  • Defect Code Group
  • Client
  • Catalog Type - Problems/Defects
  • I_QUALITYNOTIFICATIONITEM.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_QUALITYNOTIFICATIONITEM.MANDT == QPGR.MANDT
  • I_QUALITYNOTIFICATIONITEM.DEFECTCODECATALOG == QPGR.KATALOGART
Unit of Measure for Item
  • Unit of Measure for Item
  • Client
  • I_QUALITYNOTIFICATIONITEM.DEFECTIVEQUANTITYUNIT == T006.MSEHI
  • I_QUALITYNOTIFICATIONITEM.MANDT == T006.MANDT
Object ID of the Work Center
  • Work Center
  • Object ID of the Work Center
  • Client
  • Object types of the CIM resource
  • I_QUALITYNOTIFICATIONITEM.MAINWORKCENTER == CRID.OBJID
  • I_QUALITYNOTIFICATIONITEM.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_QUALITYNOTIFICATIONITEM.MANDT == CRID.MANDT
  • I_QUALITYNOTIFICATIONITEM.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_QUALITYNOTIFICATIONITEM.MAINWORKCENTERPLANT == T001W.WERKS
  • I_QUALITYNOTIFICATIONITEM.MANDT == T001W.MANDT
Defect Location Catalog
  • Defect Location Catalog
  • Client
  • I_QUALITYNOTIFICATIONITEM.NOTIFITMOBJECTPARTCODECTLG == TQ15.KATALOGART
  • I_QUALITYNOTIFICATIONITEM.MANDT == TQ15.MANDT
Defect Location Code Group
  • Defect Location Catalog
  • Client
  • Defect Location Code Group
  • I_QUALITYNOTIFICATIONITEM.NOTIFITMOBJECTPARTCODECTLG == QPGR.KATALOGART
  • I_QUALITYNOTIFICATIONITEM.MANDT == QPGR.MANDT
  • I_QUALITYNOTIFICATIONITEM.NOTIFITMOBJECTPARTCODEGROUP == QPGR.CODEGRUPPE