TQSS SAP (QM configuration: Client level) Table details
Description: QM configuration: Client level
Table field list including key, data, relationships and ABAP select examples
TQSS is a standard SAP Table which is used to store QM configuration: Client level data and is available within R/3 SAP systems depending on the version and release level.
The TQSS table consists of various fields, each holding specific information or linking keys about QM configuration: Client level data available in SAP. These include HISTGRUPPE (Code Groups Are Maintained with History), KENNZAHLOB (Upper Allowed Value for the Quality Score), KENNZAHLUN (Lower Allowed Value for the Quality Score), KZMERKZENT (Trigger Central Replacement of Master Inspection Charac.).. 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 or numeric)
SAP TQSS 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 | Assigned to domain | MANDT | |||
| HISTGRUPPE | Code Groups Are Maintained with History | QHISTGRUPP | CHAR | 1 | QKZ | ||||
| KENNZAHLOB | Upper Allowed Value for the Quality Score | QKENNZHLOB | DEC | 3 | QKENNZAHL | ||||
| KENNZAHLUN | Lower Allowed Value for the Quality Score | QKENNZHLUN | DEC | 3 | QKENNZAHL | ||||
| KZMERKZENT | Trigger Central Replacement of Master Inspection Charac. | QMERKERS | CHAR | 1 | QKZ | ||||
| KZMETHZENT | Trigger Central Replacement of Inspection Method | QMETHERS | CHAR | 1 | QKZ | ||||
| KZMERKALE | Distribute Master Inspection Characs on Saving | QKZMERKALE | CHAR | 1 | QKZ | ||||
| KZMETHALE | Distribute Inspection Methods on Saving | QKZMETHALE | CHAR | 1 | QKZ | ||||
| KZCDGRPALE | Distribute Code Groups on Saving | QKZ_CODEGROUP_ALE | CHAR | 1 | QKZ | ||||
| UNPLMK | Lower Number for Unplanned Characteristic | QUNPLMK | NUMC | 4 | QMERKNRP | ||||
| QKZMIN | Minimum Quality Score for Good Quality | QKZMIN | DEC | 3 | QKENNZAHL | ||||
| FBNAMEVE | Function Module Name | QFBNAMEVE | CHAR | 30 | QFKTNAME | ||||
| MATSPEZ | Lower Char. No. for Chars from Mat. Spec./Config./Batch | QMATSPEZNK | NUMC | 4 | QMERKNRP | ||||
| QMCAPID | Parameters for BOM Explosion | QMCAPID | CHAR | 4 | TC04 | CAPID | CSA | ||
| MS_FLAG | Indicator: Multiple Specifications | Q_MS_FLG | CHAR | 1 | Q_MS_FLG | ||||
| CP_FLAG | Display control-plan fields? | QP_CP_FLAG | CHAR | 1 | QKZ | ||||
| RFCDEST_CPRO | Logical Destination (Specified in Function Call) | RFCDEST | CHAR | 32 | RFCDES | RFCDEST | RFC | F4_RFCDESTYPEALL | |
| SWITCHES | Customizing Switch for BAdI BADI_QM_CLIENT_SETTINGS | QMS_SWITCHES | CHAR | 126 |
| Key field | Non-key field |
How do I retrieve data from SAP table TQSS using ABAP code
The following ABAP code Example will allow you to do a basic selection on TQSS to SELECT all data from the tableDATA: WA_TQSS TYPE TQSS.
SELECT SINGLE *
FROM TQSS
INTO CORRESPONDING FIELDS OF WA_TQSS
WHERE...
How to access SAP table TQSS
Within an ECC or HANA version of SAP you can also view further information about TQSS 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