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 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