- Home
- Resources
- SAP Tables
- TQ01B - Material authorization groups in quality management
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.
Source: TQ01B (Material authorization groups in quality management)
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |