A_Defect

Defects | view: ADEFECT | TRAN | Extraction: Not supported | Component: Defects Recording
Tables used: QALSQMFEAFVCTQDEFECTCONFIGCRHD
Column Name Description
DefectInternalID FK Notification Number
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
WorkCenterTypeCode Object types of the CIM resource Show values
IsDeleted Is Deleted Show values
DefectOrigin Origin of Item Record Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
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
DefectObjectCode Defect Location Code QCODE
ManufacturingOrder Order Number (Production Order) AUFNR
OrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
ManufacturingOrderOperation Operation or Phase Number VDM_VORNR
ManufacturingOrderSequence Sequence PLNFOLGE
NumberOfDefects Number of Defect Occurrences QANZAHL4
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
MainWorkCenter Work Center ARBPL
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
InspectionLot Inspection Lot Number QPLOS
CatalogProfile Catalog Profile RBNR
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Defect Category
  • Client
  • Defect Category
  • A_DEFECT.MANDT == TQDEFCAT.MANDANT
  • A_DEFECT.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Defect Class
  • Client
  • Defect Class
  • A_DEFECT.MANDT == TQ17.MANDT
  • A_DEFECT.DEFECTCLASS == TQ17.FEHLKLASSE
Catalog Type - Problems/Defects
  • Client
  • Catalog Type - Problems/Defects
  • A_DEFECT.MANDT == TQ15.MANDT
  • A_DEFECT.DEFECTCODECATALOG == TQ15.KATALOGART
Defect Code Group
  • Client
  • Defect Code Group
  • Catalog Type - Problems/Defects
  • A_DEFECT.MANDT == QPGR.MANDT
  • A_DEFECT.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • A_DEFECT.DEFECTCODECATALOG == QPGR.KATALOGART
Unit of Measure for Item
  • Client
  • Unit of Measure for Item
  • A_DEFECT.MANDT == T006.MANDT
  • A_DEFECT.DEFECTIVEQUANTITYUNIT == T006.MSEHI
Defect Location Catalog
  • Client
  • Defect Location Catalog
  • A_DEFECT.MANDT == TQ15.MANDT
  • A_DEFECT.DEFECTOBJECTCODECATALOG == TQ15.KATALOGART
Defect Location Code Group
  • Client
  • Defect Location Catalog
  • Defect Location Code Group
  • A_DEFECT.MANDT == QPGR.MANDT
  • A_DEFECT.DEFECTOBJECTCODECATALOG == QPGR.KATALOGART
  • A_DEFECT.DEFECTOBJECTCODEGROUP == QPGR.CODEGRUPPE
Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • Object ID of the Work Center
  • Work Center
  • A_DEFECT.WORKCENTERTYPECODE == CRID.OBJTY
  • A_DEFECT.MANDT == CRID.MANDT
  • A_DEFECT.MAINWORKCENTERINTERNALID == CRID.OBJID
  • A_DEFECT.MAINWORKCENTER == CRID.OBJID
Plant for Work Center
  • Client
  • Plant for Work Center
  • A_DEFECT.MANDT == T001W.MANDT
  • A_DEFECT.MAINWORKCENTERPLANT == T001W.WERKS
Defective Material
  • Client
  • Defective Material
  • A_DEFECT.MANDT == MARA.MANDT
  • A_DEFECT.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • A_DEFECT.MANDT == T001W.MANDT
  • A_DEFECT.PLANT == T001W.WERKS