SAP Table QAVE
Inspection processing: Usage decision
QAVE (Inspection processing: Usage decision) 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 QAVE to other SAP tables.
QAVE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDANT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||
|
PRUEFLOS
Inspection Lot Number
|
QPLOS | QALS |
NUMC
|
12 | 0 | |||||||||||||||
|
KZART
Inspection Lot, Partial Lot, Single Unit, Interval
|
QKZART |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
ZAEHLER
Counter for Usage Decision
|
QVEZAEHLER |
CHAR
|
6 | 0 | ||||||||||||||||
|
VKATART
Catalog
|
QKATART | TQ15 |
CHAR
|
1 | 0 | |||||||||||||||
|
VWERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||||
|
VAUSWAHLMG
Selected Set of the Usage Decision
|
QVMENGE | QPAM |
CHAR
|
8 | 0 | |||||||||||||||
|
VCODEGRP
Code Group of the Usage Decision
|
QVGRUPPE | QPGR |
CHAR
|
8 | 0 | |||||||||||||||
|
VCODE
Usage Decision Code
|
QVCODE | QPCD |
CHAR
|
4 | 0 | |||||||||||||||
|
VERSIONAM
Version Number of the Selected Set Record
|
QVERSVE |
CHAR
|
6 | 0 | ||||||||||||||||
|
VERSIONCD
Version Number of the Code Record
|
QVERSNRCD |
CHAR
|
6 | 0 | ||||||||||||||||
|
VBEWERTUNG
Code Valuation
|
QBEWERTUNG |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
DBEWERTUNG
Dynamic Modif. Valuation According to Worst Case Principle
|
QDBEWERT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VFOLGEAKTI
Follow-Up Action
|
QFOLGEAKTI | TQ07 |
CHAR
|
8 | 0 | |||||||||||||||
|
QKENNZAHL
Quality Score
|
QKENNZAHL |
DEC
|
3 | 0 | ||||||||||||||||
|
LTEXTKZ
Long Text for Usage Decision
|
QLTEXTAVE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VNAME
Person who Made the Usage Decision
|
QVNAME |
CHAR
|
12 | 0 | ||||||||||||||||
|
VDATUM
Date of Code Used for Usage Decision
|
QVEDATUM |
DATS
|
8 | 0 | ||||||||||||||||
|
VEZEITERF
Time when Usage Decision Was Recorded
|
QVEZEITERF |
TIMS
|
6 | 0 | ||||||||||||||||
|
VAENAME
Person who Changed the Usage Decision
|
QVAENAME |
CHAR
|
12 | 0 | ||||||||||||||||
|
VAEDATUM
Change Date of Usage Decision
|
QVAEDATUM |
DATS
|
8 | 0 | ||||||||||||||||
|
VEZEITAEN
Time when Usage Decision Changed
|
QVEZEITAEN |
TIMS
|
6 | 0 | ||||||||||||||||
|
STAFO
Update group for statistics update
|
STAFO | TMCB |
CHAR
|
6 | 0 | |||||||||||||||
|
TEILLOS
Partial lot number
|
QTLOS | QALT |
NUMC
|
6 | 0 | |||||||||||||||
|
VORGLFNR
Current Node Number from Order Counter APLZL
|
QLFNKN |
NUMC
|
8 | 0 | ||||||||||||||||
QAVE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QAVE | MANDANT | QAVE | MANDANT |
T000
Clients
|
MANDT |
| QAVE | PRUEFLOS | QAVE | MANDANT |
QALS
Inspection lot record
|
MANDANT |
| QAVE | PRUEFLOS | QAVE | PRUEFLOS |
QALS
Inspection lot record
|
PRUEFLOS |
| QAVE | STAFO | QAVE | MANDANT |
TMCB
Update groups
|
MANDT |
| QAVE | STAFO | QAVE | STAFO |
TMCB
Update groups
|
STAFO |
| QAVE | TEILLOS | QAVE | MANDANT |
QALT
Partial lot
|
MANDANT |
| QAVE | TEILLOS | QAVE | PRUEFLOS |
QALT
Partial lot
|
PRUEFLOS |
| QAVE | TEILLOS | QAVE | TEILLOS |
QALT
Partial lot
|
TEILLOS |
| QAVE | VAUSWAHLMG | QAVE | VWERKS |
QPAM
Inspection catalog selected sets
|
WERKS |
| QAVE | VAUSWAHLMG | QAVE | VKATART |
QPAM
Inspection catalog selected sets
|
KATALOGART |
| QAVE | VAUSWAHLMG | QAVE | VAUSWAHLMG |
QPAM
Inspection catalog selected sets
|
AUSWAHLMGE |
| QAVE | VAUSWAHLMG | QAVE | MANDANT |
QPAM
Inspection catalog selected sets
|
MANDT |
| QAVE | VCODE | QAVE | VCODEGRP |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| QAVE | VCODE | QAVE | VCODE |
QPCD
Inspection catalog codes
|
CODE |
| QAVE | VCODE | QAVE | VERSIONCD |
QPCD
Inspection catalog codes
|
VERSION |
| QAVE | VCODE | QAVE | MANDANT |
QPCD
Inspection catalog codes
|
MANDT |
| QAVE | VCODE | QAVE | VKATART |
QPCD
Inspection catalog codes
|
KATALOGART |
| QAVE | VCODEGRP | QAVE | VCODEGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QAVE | VCODEGRP | QAVE | MANDANT |
QPGR
Inspection catalog code groups
|
MANDT |
| QAVE | VCODEGRP | QAVE | VKATART |
QPGR
Inspection catalog code groups
|
KATALOGART |
| QAVE | VFOLGEAKTI | QAVE | MANDANT |
TQ07
Follow-Up Action for Usage Decision of Inspection Lot
|
MANDT |
| QAVE | VFOLGEAKTI | QAVE | VFOLGEAKTI |
TQ07
Follow-Up Action for Usage Decision of Inspection Lot
|
FOLGEAKTI |
| QAVE | VKATART | QAVE | MANDANT |
TQ15
Inspection catalog type index
|
MANDT |
| QAVE | VKATART | QAVE | VKATART |
TQ15
Inspection catalog type index
|
KATALOGART |
| QAVE | VWERKS | QAVE | MANDANT |
T001W
Plants/Branches
|
MANDT |
| QAVE | VWERKS | QAVE | VWERKS |
T001W
Plants/Branches
|
WERKS |