SAP Table QGEVAL_DEFECT
QM Evaluation: Data Structure for Defects or Items
QGEVAL_DEFECT (QM Evaluation: Data Structure for Defects or Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QGEVAL_DEFECT to other SAP tables.
Source: QGEVAL_DEFECT (QM Evaluation: Data Structure for Defects or Items)
QGEVAL_DEFECT table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | 0 | |||||||
QMNUM | Notification No | QMNUM | CHAR | 12 | 0 | |||||||
FENUM | Item Number in Item Record | FELFD | NUMC | 4 | 0 | |||||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||
FEHLBEW | Defect Valuation | QFEHLBEW | FLTP | 16 | 16 | |||||||
ANZFEHLER | Number of Defects Found | QANZFEHL4 | INT4 | 10 | 0 | |||||||
PROBENR | Sample Number (Based on an Inspection Point) | QPROBENRPP | NUMC | 6 | 0 | |||||||
TEILLOS | Partial lot number | QTLOS | NUMC | 6 | 0 | |||||||
FEKAT | Catalog Type - Problems/Defects | FEKAT | CHAR | 1 | 0 | |||||||
FEGRP | Code Group - Defect | QGEVAL_FEGRP | CHAR | 8 | 0 | |||||||
FECOD | Problem or Damage Code | FECOD | CHAR | 4 | 0 | |||||||
OTKAT | Catalog Type - Object Parts | OTKAT | CHAR | 1 | 0 | |||||||
OTGRP | Code Group - Object Parts | OTGRP | CHAR | 8 | 0 | |||||||
OTEIL | Part of Object | OTEIL | CHAR | 4 | 0 | |||||||
FEQKLAS | Defect Class | QFEHLKLAS | CHAR | 2 | 0 | |||||||
FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | 0 | |||||||
KZSYSFE | Systematic Defect | QKZSYSFE | CHAR | 1 | 0 |
Possible values
|
||||||
UNITFLBEW | Unit for Defect Valuation | QGEVAL_UNITFLBEW | UNIT | 3 | 0 | |||||||
LOCATION_TEXT | Short Text for Defect-Location Code | QGEVAL_LOCATION_TXT | CHAR | 40 | 0 | |||||||
MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | 0 | |||||||
WERK | Plant | WERKS_D | CHAR | 4 | 0 | |||||||
MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | 0 | |||||||
AUFNR | Order Number | AUFNR | CHAR | 12 | 0 | |||||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | 0 | |||||||
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | 0 | |||||||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | 0 | |||||||
QTXT | Short Text for Code (Up to 40 Characters in Length) | QTXT_CODE | CHAR | 40 | 0 | |||||||
FEKTXTCD | Code Text for Problem | FECODETEXT | CHAR | 80 | 0 | |||||||
FEKTXTGR | Code Group Text for Problem | FEGRPTEXT | CHAR | 40 | 0 | |||||||
OTKTXTCD | Code Text for Object Part | OTCODETEXT | CHAR | 80 | 0 | |||||||
OTKTXTGR | Code Group Text for Object Part | OTGRPTEXT | CHAR | 40 | 0 | |||||||
FMGEIN | Unit of Measure for Item | QMGEIN | UNIT | 3 | 0 | |||||||
FMGEIG | Defective Quantity for Item (Internal) | QMGEIG | QUAN | 13 | 3 | |||||||
BATCH_HIERARCHY | Batch Hierarchy | QGEVAL_BATCH_HIERARCHY | CHAR | 30 | 0 | |||||||
VERWMERKM | Master Inspection Characteristics | QMERKNR | CHAR | 8 | 0 | |||||||
QPMK_WERKS | Plant for Master Inspection Characteristic | QGEVAL_QPMK_WERKS | CHAR | 4 | 0 | |||||||
MKVERSION | Version Number of the Master Inspection Characteristic | QVERSNRMK | CHAR | 6 | 0 | |||||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | 0 | |||||||
CHARACT_ID1 | Characteristic Description for Quality Data Exchange | QCHARACT_ID1 | CHAR | 40 | 0 | |||||||
PMETHODE | Inspection Method | QPMETHODE | CHAR | 8 | 0 |