QDSV

Transparent Table Application Table
30 Fields 2 CDS Views

Sampling procedure

QDSV is an SAP database table in S/4HANA. Sampling procedure. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SamplingProcedure view from EXTENSION Sampling Procedure Extension
I_SamplingProcedure view from BASIC Sampling Procedure

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stichprver qstprver Smpl. Procedure
stichprart qstprart Sampling Type
bewertmod qbewmod Valuation Mode
kzohi qkzohi No Stage Change
kzumfs qkzumfs Multi. Samples
kznocut qkznocut Recurring insps.
stpranz qstpranz No. of samples
stprumf qstprumf Sample size
annahmez qannahmez Acceptance no.
kfaktor qkfaktor K-factor
kfaktorni qninitial Not Initial
kznvwsv qkznvwsv Usage Blocked
kzvwsvpl qkzvwsvpl In Task List
fbkey qfbkey Determ. Rule
fbkeymfs qfbkeymfs Valuation Rule
stprplan qstprplanv Sampling Scheme
prschaerfe qprschaerv Insp. severity
aqlwert qaqlwertv AQL Value
prozumf qprozumf Size as lot %
prozumfni qninitial Not Initial
prozazl qprozazl AccNo. as %
prozazlni qninitial Not Initial
ersteller qersteller Created By
aenderer qaenderer Changed By
erstelldat qdatumerst Created On
aenderdat qdatumaend Changed On
kzrast qkzrast With insp. pts.
raster qraster Insp. Frequency
qrkart qqrkart Ctrl Chart Type

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.

-- Sampling procedure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QDSV (
    MANDT,       -- Client [mandt]
    STICHPRVER,  -- Smpl. Procedure [qstprver]
    STICHPRART,  -- Sampling Type [qstprart]
    BEWERTMOD,   -- Valuation Mode [qbewmod]
    KZOHI,       -- No Stage Change [qkzohi]
    KZUMFS,      -- Multi. Samples [qkzumfs]
    KZNOCUT,     -- Recurring insps. [qkznocut]
    STPRANZ,     -- No. of samples [qstpranz]
    STPRUMF,     -- Sample size [qstprumf]
    ANNAHMEZ,    -- Acceptance no. [qannahmez]
    KFAKTOR,     -- K-factor [qkfaktor]
    KFAKTORNI,   -- Not Initial [qninitial]
    KZNVWSV,     -- Usage Blocked [qkznvwsv]
    KZVWSVPL,    -- In Task List [qkzvwsvpl]
    FBKEY,       -- Determ. Rule [qfbkey]
    FBKEYMFS,    -- Valuation Rule [qfbkeymfs]
    STPRPLAN,    -- Sampling Scheme [qstprplanv]
    PRSCHAERFE,  -- Insp. severity [qprschaerv]
    AQLWERT,     -- AQL Value [qaqlwertv]
    PROZUMF,     -- Size as lot % [qprozumf]
    PROZUMFNI,   -- Not Initial [qninitial]
    PROZAZL,     -- AccNo. as % [qprozazl]
    PROZAZLNI,   -- Not Initial [qninitial]
    ERSTELLER,   -- Created By [qersteller]
    AENDERER,    -- Changed By [qaenderer]
    ERSTELLDAT,  -- Created On [qdatumerst]
    AENDERDAT,   -- Changed On [qdatumaend]
    KZRAST,      -- With insp. pts. [qkzrast]
    RASTER,      -- Insp. Frequency [qraster]
    QRKART,      -- Ctrl Chart Type [qqrkart]
    PRIMARY KEY (MANDT, STICHPRVER)
);

Learn More