Sample Results for Inspection Characteristics — the per-partial-sample measured-value record for one inspection characteristic within an inspection lot (statistics, defect counts, valuation, defect-code assignment), keyed one level finer than QAMR by PROBENR. One of the two measured-value tables alongside QAMR (characteristic-level results); rolls up to the usage decision in QAVE.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| ISP_NUM key | inspectio numerus | Inspection Lot Number | QPLOS | NUMC 12 | QALS |
| NUM_MND_NMR key | numerus mandatum numerator | Current Node Number from Order Counter APLZL | QLFNKN | NUMC 8 | — |
| NIS_NUM key | nota inspectionis numerus | Inspection Characteristic Number | QMERKNRP | NUMC 4 | — |
| NUM_EXM key | numerus exemplum | Number of the Partial Sample | QSTIPRONR | NUMC 6 | QASV |
| TBL_STA | tabula status | Results Record Status | QBEASTATUS | CHAR 1 | TQ76 |
| TBL | tabula | Attribute of the Results Record (Valid, Invalid,...) | QATTRIBUT | CHAR 1 | — |
| ORG | origo | Origin of Results Data | QERGDATH | CHAR 2 | TQ73 |
| NOM_USR_CRE | nomen usor creatus | Name of User Who Created the Data Record | QERSTELLER | CHAR 12 | — |
| DIE_TBL_CRE | dies tabula creatus | Date on Which the Data Record Was Created | QDATUMERST | DATS 8 | — |
| NOM_USR_MUT | nomen usor mutatus | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR 12 | — |
| DIE_TBL_MUT | dies tabula mutatus | Date on Which Data Record Was Changed | QDATUMAEND | DATS 8 | — |
| ISP_EFC_AES | inspectio effectus aestimatio | Inspection Result Valuation | QMBEWERTG | CHAR 1 | — |
| AES_NOT | aestimatio nota | Valuation of the Characteristic for Dynamic Modification | QDBEWERTG | CHAR 1 | — |
| NOM | nomen | Name of the Inspector | QPRUEFER | CHAR 12 | — |
| ISP_INI_DIE | inspectio initium dies | Inspection Start Date | QPRUEFDATV | DATS 8 | — |
| FIN_DIE_ISP | finis dies inspectio | End Date of the Inspection | QPRUEFDATB | DATS 8 | — |
| TMP_ISP | tempus inspectio | Starting Time of the Inspection | QPRUEFZTV | TIMS 6 | — |
| FIN_TMP_ISP | finis tempus inspectio | End Time of the Inspection | QPRUEFZTB | TIMS 6 | — |
| TXT | textus | Short Text | QKURZTEXT | CHAR 40 | — |
| NIS_TXT | nota inspectionis textus | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR 1 | — |
| LNG_CLV | lingua clavis | Language Key | SPRAS | LANG 1 | T002 |
| NUM_EXM2 | numerus exemplum | Number of Recorded Sample Units | QISTSTPUMF | INT4 10 | — |
| NUM_EXM3 | numerus exemplum | Number of Nonconforming Sample Units | QANZFEHEH2 | INT2 5 | — |
| ANTEILNI | Not Initialized for Fraction | QNIANTEIL | CHAR 1 | — | |
| EXM | exemplum | Estimated Fraction of Nonconforming Sample Units | QANTEIL | FLTP 16,16 | — |
| NUM | numerus | Number of Defects Found | QANZFEHL2 | INT2 5 | — |
| NUM2 | numerus | Number of Measured Values Above the Tolerance Range | QANZWERTO2 | INT2 5 | — |
| NUM3 | numerus | Number of Measured Values Below the Tolerance Range | QANZWERTU2 | INT2 5 | — |
| NUM_EXM4 | numerus exemplum | Number of Inspected Sample Units | QANZWERTG2 | INT2 5 | — |
| VAL | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL2 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL3 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL4 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL5 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL6 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL7 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL8 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL9 | valor | Value Not Initial if Set | QNINITIAL | CHAR 1 | — |
| VAL10 | valor | Maximum Value of the Valid Measured Values | QMAXWERT | FLTP 16,16 | — |
| MEDIANWERT | Median of Valid Measured Values | QMEDIANWRT | FLTP 16,16 | — | |
| VAL11 | valor | Minimum Value of the Valid Measured Values | QMINWERT | FLTP 16,16 | — |
| MITTELWERT | Arithmetic Mean of Valid Measured Values | QMITTELWRT | FLTP 16,16 | — | |
| VARIANZ | Dispersion (Variance) of Valid Measured Values | QVARIANZ | FLTP 16,16 | — | |
| MOMENT3 | Third Central Moment of Valid Measured Values | QMOMENT3 | FLTP 16,16 | — | |
| MOMENT4 | Fourth Central Moment of Valid Measured Values | QMOMENT4 | FLTP 16,16 | — | |
| ANTEILO | Estimated Fraction Above the Tolerance Range | QANTEILO | FLTP 16,16 | — | |
| ANTEILU | Estimated Fraction Below the Tolerance Range | QANTEILU | FLTP 16,16 | — | |
| GEN_COD_CTS | genus codex coetus | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR 1 | TQ15 |
| COD_CTS | codex coetus | Code Group | QCODEGRP | CHAR 8 | — |
| COD | codex | Code | QCODE | CHAR 4 | — |
| VRS_NUM | versio numerus | Version Number | QVERSNR | CHAR 6 | — |
| GEN_COD_CTS2 | genus codex coetus | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR 1 | TQ15 |
| COD_CTS2 | codex coetus | Code Group | QCODEGRP | CHAR 8 | — |
| COD2 | codex | Code | QCODE | CHAR 4 | — |
| VRS_NUM2 | versio numerus | Version Number | QVERSNR | CHAR 6 | — |
| GEN_COD_CTS3 | genus codex coetus | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR 1 | TQ15 |
| COD_CTS3 | codex coetus | Code Group | QCODEGRP | CHAR 8 | — |
| COD3 | codex | Code | QCODE | CHAR 4 | — |
| VRS_NUM3 | versio numerus | Version Number | QVERSNR | CHAR 6 | — |
| GEN_COD_CTS4 | genus codex coetus | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR 1 | TQ15 |
| COD_CTS4 | codex coetus | Code Group | QCODEGRP | CHAR 8 | — |
| COD4 | codex | Code | QCODE | CHAR 4 | — |
| VRS_NUM4 | versio numerus | Version Number | QVERSNR | CHAR 6 | — |
| GEN_COD_CTS5 | genus codex coetus | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR 1 | TQ15 |
| COD_CTS5 | codex coetus | Code Group | QCODEGRP | CHAR 8 | — |
| COD5 | codex | Code | QCODE | CHAR 4 | — |
| VRS_NUM5 | versio numerus | Version Number | QVERSNR | CHAR 6 | — |
| CLS | classis | Defect Class | QFEHLKLAS | CHAR 2 | TQ17 |
| NOT_EFC_CNF | nota effectus confirmatio | Characteristic Result Confirmation from Control Station | QSENDEFLAG | CHAR 1 | — |
| MASCHINE | General Information | QMASCHINE | CHAR 18 | — | |
| MNU | munus | Test Position | QPRPOS | NUMC 4 | — |
| AENDBELEG | Create Change Documents During Results Recording | QKZAENBEL | CHAR 1 | — | |
| AES | aestimatio | Valuation Copied or Forced | QKZBEWERTG | CHAR 1 | — |
| TMP_TBL_CRE | tempus tabula creatus | Time at which data record was created | QZEITERSTL | TIMS 6 | — |
| TMP_TBL_ULT | tempus tabula ultimus | Time at which data record was last changed | QZEITAEND | TIMS 6 | — |
| VAL12 | valor | Original Value Before Input Processing | QORIGINAL_INPUT | CHAR 25 | — |
| NUM4 | numerus | Different Number of Decimal Places | QDIFF_DEC_PLACES | INT2 5 | — |
| INPPROC_READY | Input Processing Successfully Completed | QINPPROC_READY | CHAR 1 | — | |
| SIGN_ID | Digital Signature for Process | SIGN_GUID_22_CHG | CHAR 22 | — | |
| STA | status | Status of Signature Process | SIGN_STATE | CHAR 1 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDANT | T000 | MANDT |
PRUEFLOS | QALS | MANDANT |
PRUEFLOS | QALS | PRUEFLOS |
PROBENR | QASV | MANDANT |
PROBENR | QASV | PRUEFLOS |
PROBENR | QASV | VORGLFNR |
PROBENR | QASV | MERKNR |
PROBENR | QASV | PROBENR |
SATZSTATUS | TQ76 | STATUS |
QERGDATH | TQ73 | MANDT |
QERGDATH | TQ73 | QERGDATH |
LTEXTSPR | T002 | SPRAS |
KATALGART1 | TQ15 | MANDT |
KATALGART1 | TQ15 | KATALOGART |
KATALGART2 | TQ15 | MANDT |
KATALGART2 | TQ15 | KATALOGART |
KATALGART3 | TQ15 | MANDT |
KATALGART3 | TQ15 | KATALOGART |
KATALGART4 | TQ15 | MANDT |
KATALGART4 | TQ15 | KATALOGART |
KATALGART5 | TQ15 | MANDT |
KATALGART5 | TQ15 | KATALOGART |
FEHLKLAS | TQ17 | MANDT |
FEHLKLAS | TQ17 | FEHLKLASSE |