TQ05

Transparent Table Customizing Table
13 Fields 1 CDS Views

QM certificate categories for procurement

TQ05 is an SAP database table in S/4HANA. QM certificate categories for procurement. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QualityCertificateType view from BASIC Quality Certificate Type

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY zgtyp QZGTYP CertificateType
weprf QWEPRF Cert. required
zglief QZGLIEF Cert reqd
zgpruef QZGPRUEF Check Cert.
msgart QMSGZG Ctrl w/o Cert.
stsma J_STSMA Status Profile
qcpract QCPRACT Enhanced certPrc
qgrpop QCGRPOP No GR cert conf
qremind QCREMIND Remind.Deadline
qescal QCESCAL Escalation
sign_type QSIGNTYPE Sig.Type R.R.
signstrat QSIGNSTRAT Sig.Strategy R.R.

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 certificate categories for procurement
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ05 (
    MANDT,      -- Client [MANDT]
    ZGTYP,      -- CertificateType [QZGTYP]
    WEPRF,      -- Cert. required [QWEPRF]
    ZGLIEF,     -- Cert reqd [QZGLIEF]
    ZGPRUEF,    -- Check Cert. [QZGPRUEF]
    MSGART,     -- Ctrl w/o Cert. [QMSGZG]
    STSMA,      -- Status Profile [J_STSMA]
    QCPRACT,    -- Enhanced certPrc [QCPRACT]
    QGRPOP,     -- No GR cert conf [QCGRPOP]
    QREMIND,    -- Remind.Deadline [QCREMIND]
    QESCAL,     -- Escalation [QCESCAL]
    SIGN_TYPE,  -- Sig.Type R.R. [QSIGNTYPE]
    SIGNSTRAT,  -- Sig.Strategy R.R. [QSIGNSTRAT]
    PRIMARY KEY (MANDT, ZGTYP)
);

Learn More