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 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||||
| 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 |
Possible values
|
||||||||||||||
| DBEWERTUNG | Dynamic Modif. Valuation According to Worst Case Principle | QDBEWERT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| 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 |
Possible values
|
||||||||||||||
| 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 | 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 | VAUSWAHLMG | QAVE | VWERKS | QPAM | Inspection catalog selected sets | WERKS |
| 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 | VCODE | QAVE | VCODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
| QAVE | VCODEGRP | QAVE | MANDANT | QPGR | Inspection catalog code groups | MANDT |
| QAVE | VCODEGRP | QAVE | VKATART | QPGR | Inspection catalog code groups | KATALOGART |
| QAVE | VCODEGRP | QAVE | VCODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| QAVE | VFOLGEAKTI | QAVE | VFOLGEAKTI | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | FOLGEAKTI |
| QAVE | VFOLGEAKTI | QAVE | MANDANT | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | MANDT |
| 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 |
