TQ01B

Transparent Table Customizing Table

Material authorization groups in quality management

TQ01B is an SAP database table in S/4HANA. Material authorization groups in quality management. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlQualityAuthGroup view_entity from BASIC Material Authzn Group for Qlty Mgmt

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY qmatauth qmatauth QM Matl Auth.
kzgenlos qkzgenlos Lot Approval
sig_il_res sig_il_res Dig. Sig. in RR
sig_il_usa sig_il_usa Dig. Sig. UD
sig_il_sdr sig_il_sdr DigSig SmplDraw
sign_type_rr sign_type_rr Sig.Type R.R.
sign_type_ud sign_type_ud Sig.Type U.D.
sign_type_sm sign_type_sm Sig.Type SD
signstrat_rr signstrat_rr Sig.Strategy R.R.
signstrat_ud signstrat_ud Sig.Strategy U.D.
signstrat_sm signstrat_sm SigStrat SampDr
remark_chg sign_remark_chg Rem. Chng.

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.

-- Material authorization groups in quality management
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ01B (
    MANDT,         -- Client [mandt]
    QMATAUTH,      -- QM Matl Auth. [qmatauth]
    KZGENLOS,      -- Lot Approval [qkzgenlos]
    SIG_IL_RES,    -- Dig. Sig. in RR [sig_il_res]
    SIG_IL_USA,    -- Dig. Sig. UD [sig_il_usa]
    SIG_IL_SDR,    -- DigSig SmplDraw [sig_il_sdr]
    SIGN_TYPE_RR,  -- Sig.Type R.R. [sign_type_rr]
    SIGN_TYPE_UD,  -- Sig.Type U.D. [sign_type_ud]
    SIGN_TYPE_SM,  -- Sig.Type SD [sign_type_sm]
    SIGNSTRAT_RR,  -- Sig.Strategy R.R. [signstrat_rr]
    SIGNSTRAT_UD,  -- Sig.Strategy U.D. [signstrat_ud]
    SIGNSTRAT_SM,  -- SigStrat SampDr [signstrat_sm]
    REMARK_CHG,    -- Rem. Chng. [sign_remark_chg]
    PRIMARY KEY (MANDT, QMATAUTH)
);