SAP table TQ01B (Material authorization groups in quality management)

SAP table TQ01B has 2 primary key fields being MANDT,QMATAUTH.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
QMATAUTH Material Authorization Group for Activities in QM CHAR 6 0 QMATAUTH
KZGENLOS Inspection Lot Approval CHAR 1 0 QKZGENLOS
Approval Not Required
1 Automatic Approval Despite Material Specification
2 No Automatic Approval for Inspection with Matl Specification
SIG_IL_RES Digital Signature for Insp. Lot in Results Recording CHAR 1 0 SIG_IL_RES
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 CHAR 1 0 SIG_IL_USA
Not Required
1 Required for Making Usage Decision
2 Required for Making the Usage Decision New Digital Signature
SIG_IL_SDR Digital Signature for Confirmation of Sample Drawing CHAR 1 0 SIG_IL_SDR
Not Required
1 Required for Confirmation of Sample Drawing
2 Req. for Conf. of Sample Drawing 'New' Digital Sig.
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording CHAR 1 0 SIGN_TYPE_RR
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision CHAR 1 0 SIGN_TYPE_UD
SIGN_TYPE_SM Signature Type: Sample Drawing CHAR 1 0 SIGN_TYPE_SM
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording CHAR 8 0 TC85 SIGNSTRAT_RR
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision CHAR 8 0 TC85 SIGNSTRAT_UD
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Sample Drawing CHAR 8 0 TC85 SIGNSTRAT_SM
REMARK_CHG Remark Can Be Changed CHAR 1 0 SIGN_REMARK_CHG
Change Not Allowed
X Changes Allowed

TQ01B foreign key relationships

Table Field Check Table Check Field
0 TQ01B SIGNSTRAT_RR TC85 Signature Strategy MANDT
0 TQ01B SIGNSTRAT_RR TC85 Signature Strategy APPLICID
1 TQ01B SIGNSTRAT_SM TC85 Signature Strategy MANDT
1 TQ01B SIGNSTRAT_SM TC85 Signature Strategy APPLICID
0 TQ01B SIGNSTRAT_UD TC85 Signature Strategy MANDT
0 TQ01B SIGNSTRAT_UD TC85 Signature Strategy APPLICID