QAVE

Transparent Table Application Table
27 Fields 3 CDS Views

Inspection processing: Usage decision

QAVE is an SAP database table in S/4HANA. Inspection processing: Usage decision. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
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 (27)

KeyField Data ElementDescription DomainTypeLength
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
dummy_qave_incl_eew_ps DUMMY Dummy function in length 1

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]
    DUMMY_QAVE_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDANT, PRUEFLOS, KZART, ZAEHLER)
);

Learn More