TQ01B
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MatlQualityAuthGroup | view_entity | from | BASIC | Material Authzn Group for Qlty Mgmt |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA