SAP table QASV (Sample specifications for inspection processing)
SAP table QASV has 5 primary key fields being MANDANT,PRUEFLOS,VORGLFNR,MERKNR,PROBENR.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDANT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PRUEFLOS | Inspection Lot Number | NUMC | 12 | 0 | QALS | QPLOS | |
| VORGLFNR | Current Node Number from Order Counter | NUMC | 8 | 0 | QLFNKN | ||
| MERKNR | Inspection Characteristic Number | NUMC | 4 | 0 | QMERKNRP | ||
| PROBENR | Inspection Sample Number | NUMC | 6 | 0 | QPROBENR | ||
| ERSTELLER | Name of User Who Created the Data Record | CHAR | 12 | 0 | QERSTELLER | ||
| ERSTELLDAT | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||
| AENDERER | Name of User Who Last Changed Data Record | CHAR | 12 | 0 | QAENDERER | ||
| AENDERDAT | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND | ||
| SATZSTATUS | Specification Record Status | CHAR | 1 | 0 | TQ76 | QSTATUS | |
| ANNAHMEZ | Acceptance Number | INT2 | 5 | 0 | QANNAHMEZ | ||
| RUECKWEZ | Rejection Number | INT2 | 5 | 0 | QRUECKWEZ | ||
| KFAKTORNI | Value Not Initial if Set | CHAR | 1 | 0 | QNINITIAL | ||
| KFAKTOR | K-Factor for a Variable Inspection | FLTP | 16 | 16 | QKFAKTOR | ||
| ANTVERF | Fraction Calculation | CHAR | 2 | 0 | TQ72 | QEANTVERF | |
| BEWREGEL | Valuation Rule | CHAR | 2 | 0 | QDFM | QBEWERT | |
| FAKPLANME | Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure | FLTP | 16 | 16 | QUMREN | ||
| FAKPROBME | Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure | FLTP | 16 | 16 | QUMRENPME | ||
| PROBMGFAK | Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) | DEC | 5 | 2 | QPROBEFAK | ||
| PROBEMGEH | Sample Unit of Measure | UNIT | 3 | 0 | T006 | QPROBME | |
| STIPROUMF | Sample Size that Must Be Inspected | INT4 | 10 | 0 | QSTIPROUMF | ||
| PRUEFUMF | Quantity to Be Inspected | QUAN | 13 | 3 | QPRUEFUMF | ||
| MENGENEINH | Base Unit of Measure for Sample Unit | UNIT | 3 | 0 | T006 | QPROBEMGEH | |
| QRKNR | Control Chart Number | NUMC | 12 | 0 | QASH | QQRKNR | |
| PRSTUFE | Inspection Stage | NUMC | 4 | 0 | QDPS | QPRSTUFE | |
| PRSCHAERFE | Inspection Severity | NUMC | 3 | 0 | QDEP | QPRSCHAERF | |
| DUMMY_QASV_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
QASV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QASV | ANTVERF | TQ72 | Type of share calculation | ANTVERF |
| 1 QASV | BEWREGEL | QDFM | Function modules for valuation mode | MANDT |
| 1 QASV | BEWREGEL | QDFM | Function modules for valuation mode | FBKEY |
| 0 QASV | MANDANT | T000 | Clients | MANDT |
| 1 QASV | MENGENEINH | T006 | Units of Measurement | MANDT |
| 1 QASV | MENGENEINH | T006 | Units of Measurement | MSEHI |
| 0 QASV | PROBEMGEH | T006 | Units of Measurement | MANDT |
| 1 QASV | PRSCHAERFE | QDEP | Allowed inspection severities | MANDT |
| 0 QASV | PRSTUFE | QDPS | Inspection stages for a dynamic modification rule | MANDT |
| 0 QASV | PRSTUFE | QDPS | Inspection stages for a dynamic modification rule | DYNREGEL |
| 0 QASV | PRSTUFE | QDPS | Inspection stages for a dynamic modification rule | PRSTUFE |
| 1 QASV | PRUEFLOS | QALS | Inspection lot record | MANDANT |
| 0 QASV | QRKNR | QASH | Quality control chart | MANDT |
| 0 QASV | QRKNR | QASH | Quality control chart | QRKNR |
| 1 QASV | SATZSTATUS | TQ76 | Processing status of inspection characteristics | STATUS |