QDSA

Transparent Table Customizing (protected)
11 Fields 1 CDS Views

Sampling type

QDSA is an SAP database table in S/4HANA. Sampling type. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SamplingType view_entity from BASIC Sampling Type

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stichprart qstprart Sampling Type
kztab qkztab Sampling scheme
kzant qkzant Percent sample
kzfix qkzfix Fixed sample
kz100 qkz100 100% inspection
kznvwsa qkznvwsa Type blocked
ersteller qersteller Created By
aenderer qaenderer Changed By
erstelldat qdatumerst Created On
aenderdat qdatumaend Changed On

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 type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QDSA (
    MANDT,       -- Client [mandt]
    STICHPRART,  -- Sampling Type [qstprart]
    KZTAB,       -- Sampling scheme [qkztab]
    KZANT,       -- Percent sample [qkzant]
    KZFIX,       -- Fixed sample [qkzfix]
    KZ100,       -- 100% inspection [qkz100]
    KZNVWSA,     -- Type blocked [qkznvwsa]
    ERSTELLER,   -- Created By [qersteller]
    AENDERER,    -- Changed By [qaenderer]
    ERSTELLDAT,  -- Created On [qdatumerst]
    AENDERDAT,   -- Changed On [qdatumaend]
    PRIMARY KEY (MANDT, STICHPRART)
);

Learn More