I_DefectUnion

Defects and Notification Items | view: IDEFECTUNI | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QALSQMELQMFEAFVCTQDEFECTCONFIGCRHD
Column Name Description
DefectInternalID FK Internal Defect ID
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime System Time of Creation
LastChangeDate Last Changed On
LastChangeTime System Time of Change
Column Name Description
DefectLifecycleStatus Defect Status Show values
WorkCenterTypeCode Object types of the CIM resource Show values
IsDeleted Is Deleted Show values
DefectOrigin Origin of Item Record Show values
Column Name Description Domain name
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
NotificationItemExternalID Notification Item Sort Number QFELFD
Defect Defect Number QDEFECTID
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
DefectText Defect Text TEXT40
DefectCode Defect Code QCODE
DefectCodeVersion Version Number QVERSNR
NumberOfDefects Number of Defect Occurrences QANZAHL4
ReferencedDefect Defect Key QDEFREFNUM
Batch Batch Number CHARG
InspectionLot Inspection Lot Number QPLOS
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
Supplier Vendor's account number LIFNR
Customer Customer (Ship-To Party) KUNNR
ProductionOrder Order Number (Production Order) AUFNR
ProductionOrderOperation Operation/Activity Number VORNR
ProductionOrderSequence Sequence PLNFOLGE
MainWorkCenter Work Center ARBPL
StorageLocation Storage location LGORT
ProductionSupplyArea Production Supply Area PRVBE
Warehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
StorageType Source Storage Type /SCWM/LGTYP
SourceStorageBin Source Storage Bin /SCWM/LGPLA
DefectCausedBy Defect Caused By QDEFECTCAUSEDBY
Master Data Relations Join Conditions
Defect Category
  • Client
  • Defect Category
  • I_DEFECTUNION.MANDT == TQDEFCAT.MANDANT
  • I_DEFECTUNION.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Defect Class
  • Defect Class
  • Client
  • I_DEFECTUNION.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_DEFECTUNION.MANDT == TQ17.MANDT
Catalog Type - Problems/Defects
  • Catalog Type - Problems/Defects
  • Client
  • I_DEFECTUNION.DEFECTCODECATALOG == TQ15.KATALOGART
  • I_DEFECTUNION.MANDT == TQ15.MANDT
Defect Code Group
  • Defect Code Group
  • Catalog Type - Problems/Defects
  • Client
  • I_DEFECTUNION.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_DEFECTUNION.DEFECTCODECATALOG == QPGR.KATALOGART
  • I_DEFECTUNION.MANDT == QPGR.MANDT
Object ID of the Work Center
  • Work Center
  • Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • I_DEFECTUNION.MAINWORKCENTER == CRID.OBJID
  • I_DEFECTUNION.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_DEFECTUNION.WORKCENTERTYPECODE == CRID.OBJTY
  • I_DEFECTUNION.MANDT == CRID.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_DEFECTUNION.MAINWORKCENTERPLANT == T001W.WERKS
  • I_DEFECTUNION.MANDT == T001W.MANDT
Defective Material
  • Client
  • Defective Material
  • I_DEFECTUNION.MANDT == MARA.MANDT
  • I_DEFECTUNION.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_DEFECTUNION.MANDT == T001W.MANDT
  • I_DEFECTUNION.PLANT == T001W.WERKS