QAVE
Inspection processing: Usage decision
QAVE is an SAP database table in S/4HANA. Inspection processing: Usage decision. It contains 26 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_InspLotUsageDecision | view | from | EXTENSION | Inspection Lot Usage Decision Extension |
| I_InspLotUsageDecision | view | from | BASIC | Usage Decision for Inspection Lot |
| I_InspOperationUsageDecision | view | from | BASIC | Usage Decision on Operation Level |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandant | mandt | Client | |||
| KEY | prueflos | qplos | Inspection Lot | |||
| KEY | kzart | qkzart | UD Type | |||
| KEY | zaehler | qvezaehler | Version | |||
| vkatart | qkatart | Catalog | ||||
| vwerks | werks_d | Plant | ||||
| vauswahlmg | qvmenge | UD Selected Set | ||||
| vcodegrp | qvgruppe | UD Code Group | ||||
| vcode | qvcode | UD Code | ||||
| versionam | qversve | UD version | ||||
| versioncd | qversnrcd | Version | ||||
| vbewertung | qbewertung | Code Valuation | ||||
| dbewertung | qdbewert | DynModValuation | ||||
| vfolgeakti | qfolgeakti | Follow-Up Actn | ||||
| qkennzahl | qkennzahl | Quality Score | ||||
| ltextkz | qltextave | Long text | ||||
| vname | qvname | UD Made By | ||||
| vdatum | qvedatum | UD Code Date | ||||
| vezeiterf | qvezeiterf | Syst. Time | ||||
| vaename | qvaename | UD Changed By | ||||
| vaedatum | qvaedatum | Date of UD | ||||
| vezeitaen | qvezeitaen | Time | ||||
| stafo | stafo | Update Group | ||||
| teillos | qtlos | Partial Lot | ||||
| vorglfnr | qlfnkn | Node Number | ||||
| qfol_up_exe | qfol_up_exe | Follow-Up Action Sts |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Inspection processing: Usage decision
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QAVE (
MANDANT, -- Client [mandt]
PRUEFLOS, -- Inspection Lot [qplos]
KZART, -- UD Type [qkzart]
ZAEHLER, -- Version [qvezaehler]
VKATART, -- Catalog [qkatart]
VWERKS, -- Plant [werks_d]
VAUSWAHLMG, -- UD Selected Set [qvmenge]
VCODEGRP, -- UD Code Group [qvgruppe]
VCODE, -- UD Code [qvcode]
VERSIONAM, -- UD version [qversve]
VERSIONCD, -- Version [qversnrcd]
VBEWERTUNG, -- Code Valuation [qbewertung]
DBEWERTUNG, -- DynModValuation [qdbewert]
VFOLGEAKTI, -- Follow-Up Actn [qfolgeakti]
QKENNZAHL, -- Quality Score [qkennzahl]
LTEXTKZ, -- Long text [qltextave]
VNAME, -- UD Made By [qvname]
VDATUM, -- UD Code Date [qvedatum]
VEZEITERF, -- Syst. Time [qvezeiterf]
VAENAME, -- UD Changed By [qvaename]
VAEDATUM, -- Date of UD [qvaedatum]
VEZEITAEN, -- Time [qvezeitaen]
STAFO, -- Update Group [stafo]
TEILLOS, -- Partial Lot [qtlos]
VORGLFNR, -- Node Number [qlfnkn]
QFOL_UP_EXE, -- Follow-Up Action Sts [qfol_up_exe]
PRIMARY KEY (MANDANT, PRUEFLOS, KZART, ZAEHLER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA