TQ01B SAP (Material authorization groups in quality management) Table details
Description: Material authorization groups in quality management
Table field list including key, data, relationships and ABAP select examples
TQ01B is a standard SAP Table which is used to store Material authorization groups in quality management data and is available within R/3 SAP systems depending on the version and release level.
The TQ01B table consists of various fields, each holding specific information or linking keys about Material authorization groups in quality management data available in SAP. These include QMATAUTH (Material Authorization Group for Activities in QM), KZGENLOS (Inspection Lot Approval), SIG_IL_RES (Digital Signature for Insp. Lot in Results Recording), SIG_IL_USA (Digital Signature for Insp. Lot when Usage Decision Made).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TQ01C
SAP TQ01B table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| QMATAUTH | Material Authorization Group for Activities in QM | QMATAUTH | CHAR | 6 | QMATAUTH | ||||
| KZGENLOS | Inspection Lot Approval | QKZGENLOS | CHAR | 1 | QKZGENLOS | ||||
| SIG_IL_RES | Digital Signature for Insp. Lot in Results Recording | SIG_IL_RES | CHAR | 1 | SIG_IL_RES | ||||
| SIG_IL_USA | Digital Signature for Insp. Lot when Usage Decision Made | SIG_IL_USA | CHAR | 1 | SIG_IL_USA | ||||
| SIG_IL_SDR | Digital Signature for Confirmation of Phys.-Sample Drawing | SIG_IL_SDR | CHAR | 1 | SIG_IL_SDR | ||||
| SIGN_TYPE_RR | Signature Type: Inspection Lot Results Recording | SIGN_TYPE_RR | CHAR | 1 | SIGN_TYPE | ||||
| SIGN_TYPE_UD | Signature Type: Inspection Lot Usage Decision | SIGN_TYPE_UD | CHAR | 1 | SIGN_TYPE_SINGLE | ||||
| SIGN_TYPE_SM | Signature Type: Physical-Sample Drawing | SIGN_TYPE_SM | CHAR | 1 | SIGN_TYPE_SINGLE | ||||
| SIGNSTRAT_RR | Signature Strategy: Inspection Lot Results Recording | SIGNSTRAT_RR | CHAR | 8 | TC85 | SIGNSTRAT | |||
| SIGNSTRAT_UD | Signature Strategy with Individual Signature: Usage Decision | SIGNSTRAT_UD | CHAR | 8 | TC85 | SIGNSTRAT | |||
| SIGNSTRAT_SM | Signature Strategy w. Ind.Signature: Physical-Sample Drawing | SIGNSTRAT_SM | CHAR | 8 | TC85 | SIGNSTRAT | |||
| REMARK_CHG | Remark Can Be Changed | SIGN_REMARK_CHG | CHAR | 1 | SIGN_REMARK_CHG |
| Key field | Non-key field |
How do I retrieve data from SAP table TQ01B using ABAP code
The following ABAP code Example will allow you to do a basic selection on TQ01B to SELECT all data from the tableDATA: WA_TQ01B TYPE TQ01B.
SELECT SINGLE *
FROM TQ01B
INTO CORRESPONDING FIELDS OF WA_TQ01B
WHERE...
How to access SAP table TQ01B
Within an ECC or HANA version of SAP you can also view further information about TQ01B and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects