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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
SIG_IL_RES
Digital Signature for Insp. Lot in Results Recording
|
SIG_IL_RES |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIG_IL_USA
Digital Signature for Insp. Lot when Usage Decision Made
|
SIG_IL_USA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIG_IL_SDR
Digital Signature for Confirmation of Phys.-Sample Drawing
|
SIG_IL_SDR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIGN_TYPE_RR
Signature Type: Inspection Lot Results Recording
|
SIGN_TYPE_RR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIGN_TYPE_UD
Signature Type: Inspection Lot Usage Decision
|
SIGN_TYPE_UD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIGN_TYPE_SM
Signature Type: Physical-Sample Drawing
|
SIGN_TYPE_SM |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
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 | SIGNSTRAT_SM |
TC85
Signature Strategy
|
SIGNSTRAT |
| TQ01B | SIGNSTRAT_SM | TQ01B | MANDT |
TC85
Signature Strategy
|
MANDT |
| TQ01B | SIGNSTRAT_SM | * |
TC85
Signature Strategy
|
APPLICID | |
| 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 |