SAP Table TQ01B

Material authorization groups in quality management

TQ01B (Material authorization groups in quality management) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TQ01B to other SAP tables.

TQ01B table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
QMATAUTH Material Authorization Group for Activities in QM QMATAUTH CHAR 6 0
KZGENLOS Inspection Lot Approval QKZGENLOS CHAR 1 0
NULL Approval not required
1 automatic approval despite mat. specification
2 no automatic approval for insp. with mat. specification
SIG_IL_RES Digital Signature for Insp. Lot in Results Recording SIG_IL_RES CHAR 1 0
NULL not required
1 Required for Results Recording
2 Required for Results Recording 'New' Digital Signature
SIG_IL_USA Digital Signature for Insp. Lot when Usage Decision Made SIG_IL_USA CHAR 1 0
NULL not required
1 required for making the usage decision
2 Required for Making the Usage Decision New Digital Signature
SIG_IL_SDR Digital Signature for Confirmation of Phys.-Sample Drawing SIG_IL_SDR CHAR 1 0
NULL not required
1 required for confirmation of physical-sample drawing
2 Req. for Conf. of Physical-Sample Drawing 'New' Digital Sig.
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording SIGN_TYPE_RR CHAR 1 0
A Asynchronous Signature Process
B Asynchronous Signature Process with Changeable Signatory
C Synchronous Signature Process
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision SIGN_TYPE_UD CHAR 1 0
A Signature Strategy - Signatory Cannot Be Changed
B Signature Strategy - Signatory Can Be Changed
SIGN_TYPE_SM Signature Type: Physical-Sample Drawing SIGN_TYPE_SM CHAR 1 0
A Signature Strategy - Signatory Cannot Be Changed
B Signature Strategy - Signatory Can Be Changed
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording SIGNSTRAT_RR TC85 CHAR 8 0
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision SIGNSTRAT_UD TC85 CHAR 8 0
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Physical-Sample Drawing SIGNSTRAT_SM TC85 CHAR 8 0
REMARK_CHG Remark Can Be Changed SIGN_REMARK_CHG CHAR 1 0
NULL Change Not Allowed
X Changes Allowed

TQ01B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TQ01B MANDT TQ01B MANDT T000 Clients MANDT
TQ01B SIGNSTRAT_RR TQ01B MANDT TC85 Signature Strategy MANDT
TQ01B SIGNSTRAT_RR * TC85 Signature Strategy APPLICID
TQ01B SIGNSTRAT_RR TQ01B SIGNSTRAT_RR TC85 Signature Strategy SIGNSTRAT
TQ01B SIGNSTRAT_SM TQ01B MANDT TC85 Signature Strategy MANDT
TQ01B SIGNSTRAT_SM * TC85 Signature Strategy APPLICID
TQ01B SIGNSTRAT_SM TQ01B SIGNSTRAT_SM TC85 Signature Strategy SIGNSTRAT
TQ01B SIGNSTRAT_UD TQ01B MANDT TC85 Signature Strategy MANDT
TQ01B SIGNSTRAT_UD * TC85 Signature Strategy APPLICID
TQ01B SIGNSTRAT_UD TQ01B SIGNSTRAT_UD TC85 Signature Strategy SIGNSTRAT