TQ40T

Transparent Table Customizing (protected)
4 Fields 1 CDS Views

Text table for sample type

TQ40T is an SAP database table in S/4HANA. Text table for sample type. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaterialSampleTypeText view from BASIC Material Sample Type Text

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prart QPRART Sample Type
KEY spras SPRAS Language
ktext QKURZTEXT Short Text

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.

-- Text table for sample type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ40T (
    MANDT,  -- Client [MANDT]
    PRART,  -- Sample Type [QPRART]
    SPRAS,  -- Language [SPRAS]
    KTEXT,  -- Short Text [QKURZTEXT]
    PRIMARY KEY (MANDT, PRART, SPRAS)
);

Learn More