TQ05T

Transparent Table Customizing Table
4 Fields 2 CDS Views

QM: text table for certificate types

TQ05T is an SAP database table in S/4HANA. QM: text table for certificate types. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_QualityCertificateProcmt view from BASIC Quality Certificate Type
I_QualityCertificateTypeT view from BASIC Quality Certificate Type - Text

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sprache spras Language
KEY zgtyp qzgtyp CertificateType
kurztext 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.

-- QM: text table for certificate types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ05T (
    MANDT,     -- Client [mandt]
    SPRACHE,   -- Language [spras]
    ZGTYP,     -- CertificateType [qzgtyp]
    KURZTEXT,  -- Short Text [qkurztext]
    PRIMARY KEY (MANDT, SPRACHE, ZGTYP)
);

Learn More