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