I_QualityDefectUnion

Quality Defect with Independent Defect | view: IQLTYDFCTUNION | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMEL, QMFE, CRHD
Column Name Description
Notification 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
WorkCenterTypeCode Object types of the CIM resource 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 Part of Object QCODE
IsDeleted Delete Data Record CHAR1
ReferencedDefect Defect Key QDEFREFNUM
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
InspectionLot Inspection Lot Number QPLOS
NumberOfDefects Number of Defect Occurrences QANZAHL4
MainWorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Defect Category
  • Client
  • Defect Category
  • I_QUALITYDEFECTUNION.MANDT == TQDEFCAT.MANDANT
  • I_QUALITYDEFECTUNION.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Catalog Type - Problems/Defects
  • Client
  • Catalog Type - Problems/Defects
  • I_QUALITYDEFECTUNION.MANDT == TQ15.MANDT
  • I_QUALITYDEFECTUNION.DEFECTCODECATALOG == TQ15.KATALOGART
Defect Code Group
  • Client
  • Defect Code Group
  • Catalog Type - Problems/Defects
  • I_QUALITYDEFECTUNION.MANDT == QPGR.MANDT
  • I_QUALITYDEFECTUNION.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_QUALITYDEFECTUNION.DEFECTCODECATALOG == QPGR.KATALOGART
Object ID of the Work Center
  • Client
  • Work Center
  • Object ID of the Work Center
  • Object types of the CIM resource
  • I_QUALITYDEFECTUNION.MANDT == CRID.MANDT
  • I_QUALITYDEFECTUNION.MAINWORKCENTER == CRID.OBJID
  • I_QUALITYDEFECTUNION.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_QUALITYDEFECTUNION.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • I_QUALITYDEFECTUNION.MANDT == T001W.MANDT
  • I_QUALITYDEFECTUNION.MAINWORKCENTERPLANT == T001W.WERKS
Catalog Type - Object Parts
  • Client
  • Catalog Type - Object Parts
  • I_QUALITYDEFECTUNION.MANDT == TQ15.MANDT
  • I_QUALITYDEFECTUNION.NOTIFITMOBJECTPARTCODECTLG == TQ15.KATALOGART
Code Group - Object Parts
  • Client
  • Catalog Type - Object Parts
  • Code Group - Object Parts
  • I_QUALITYDEFECTUNION.MANDT == QPGR.MANDT
  • I_QUALITYDEFECTUNION.NOTIFITMOBJECTPARTCODECTLG == QPGR.KATALOGART
  • I_QUALITYDEFECTUNION.NOTIFITMOBJECTPARTCODEGROUP == QPGR.CODEGRUPPE
Plant
  • Client
  • Plant
  • I_QUALITYDEFECTUNION.MANDT == T001W.MANDT
  • I_QUALITYDEFECTUNION.PLANT == T001W.WERKS