TQ40

Transparent Table Customizing (protected)
7 Fields 1 CDS Views

Definition of sample types

TQ40 is an SAP database table in S/4HANA. Definition of sample types. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaterialSampleType view_entity from BASIC Material Sample Type

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY prart qprart Sample Type
numkr qpr_nk No. Range No.
stsma qstsma_prs Status Profile
fb_etikett qfbs_qpr1 Print label
qkz_etdr qkz_etdr Print Immed.
bs_schl qbss_probe Control Key

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.

-- Definition of sample types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ40 (
    MANDT,       -- Client [mandt]
    PRART,       -- Sample Type [qprart]
    NUMKR,       -- No. Range No. [qpr_nk]
    STSMA,       -- Status Profile [qstsma_prs]
    FB_ETIKETT,  -- Print label [qfbs_qpr1]
    QKZ_ETDR,    -- Print Immed. [qkz_etdr]
    BS_SCHL,     -- Control Key [qbss_probe]
    PRIMARY KEY (MANDT, PRART)
);

Learn More