QASV

Transparent Table Application Table
27 Fields 3 CDS Views

Sample specifications for inspection processing

QASV is an SAP database table in S/4HANA. Sample specifications for inspection processing. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_InspSubsetCharacteristic view from EXTENSION Insp. Charc. for an Insp. Pt. Extension
I_InspSubsetCharacteristic view from BASIC Inspection Charc for an Inspection Point
P_Qm_Insppointswithchars view from BASIC

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandant MANDT Client
KEY prueflos QPLOS Inspection Lot
KEY vorglfnr QLFNKN Node Number
KEY merknr QMERKNRP Characteristic
KEY probenr QPROBENR Sample Number
ersteller QERSTELLER Created By
erstelldat QDATUMERST Created On
aenderer QAENDERER Changed By
aenderdat QDATUMAEND Changed On
satzstatus QSTATUS Spec. status
annahmez QANNAHMEZ Acceptance no.
rueckwez QRUECKWEZ Rejection no.
kfaktorni QNINITIAL Not Initial
kfaktor QKFAKTOR K-factor
antverf QEANTVERF Fraction Calc.
bewregel QBEWERT Valuation rule
fakplanme QUMREN MatlConvFactor
fakprobme QUMRENPME SmplConvFactor
probmgfak QPROBEFAK Base smpl. qty
probemgeh QPROBME Sample Unit
stiproumf QSTIPROUMF Inspect
pruefumf QPRUEFUMF Insp. Quantity
mengeneinh QPROBEMGEH Sample UOM
qrknr QQRKNR Control Chart
prstufe QPRSTUFE Insp. Stage
prschaerfe QPRSCHAERF Insp. Severity
dummy_qasv_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.

-- Sample specifications for inspection processing
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QASV (
    MANDANT,                 -- Client [MANDT]
    PRUEFLOS,                -- Inspection Lot [QPLOS]
    VORGLFNR,                -- Node Number [QLFNKN]
    MERKNR,                  -- Characteristic [QMERKNRP]
    PROBENR,                 -- Sample Number [QPROBENR]
    ERSTELLER,               -- Created By [QERSTELLER]
    ERSTELLDAT,              -- Created On [QDATUMERST]
    AENDERER,                -- Changed By [QAENDERER]
    AENDERDAT,               -- Changed On [QDATUMAEND]
    SATZSTATUS,              -- Spec. status [QSTATUS]
    ANNAHMEZ,                -- Acceptance no. [QANNAHMEZ]
    RUECKWEZ,                -- Rejection no. [QRUECKWEZ]
    KFAKTORNI,               -- Not Initial [QNINITIAL]
    KFAKTOR,                 -- K-factor [QKFAKTOR]
    ANTVERF,                 -- Fraction Calc. [QEANTVERF]
    BEWREGEL,                -- Valuation rule [QBEWERT]
    FAKPLANME,               -- MatlConvFactor [QUMREN]
    FAKPROBME,               -- SmplConvFactor [QUMRENPME]
    PROBMGFAK,               -- Base smpl. qty [QPROBEFAK]
    PROBEMGEH,               -- Sample Unit [QPROBME]
    STIPROUMF,               -- Inspect [QSTIPROUMF]
    PRUEFUMF,                -- Insp. Quantity [QPRUEFUMF]
    MENGENEINH,              -- Sample UOM [QPROBEMGEH]
    QRKNR,                   -- Control Chart [QQRKNR]
    PRSTUFE,                 -- Insp. Stage [QPRSTUFE]
    PRSCHAERFE,              -- Insp. Severity [QPRSCHAERF]
    DUMMY_QASV_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDANT, PRUEFLOS, VORGLFNR, MERKNR, PROBENR)
);

Learn More