TQ08 is a standard SAP table in SAP ECC (or) S/4HANA which stores Control of QM in procurement data. There are total 13 fields in TQ08 table.This blog post provides key technical details of SAP table TQ08, including its availability across SAP S/4HANA versions and the list of CDS views for TQ08 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
| Package | QM in procurement (QB) |
| Technical Component | QM Control in Procurement (QM-PT-RP-PRC) |
SAP TQ08 Table Fields
The following is the list of fields that are available in SAP TQ08 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| QM_PUR | Control Key for Quality Management in Procurement | QSSPUR | QSSPUR | CHAR (8) | |
| TLERF | Technical Delivery Terms Required | QTLREQ | QKZ | CHAR (1) | |
| QVERF | Quality Assurance Agreement Is Required | QQVREQ | QKZ | CHAR (1) | |
| LIEFFREI | Supplier Release Required for Regular Delivery | QLIFREI | QKZ | CHAR (1) | |
| ZGERF | Certificate Required | QZGREQ | QKZ | CHAR (1) | |
| DOKPFL | Documentation Required for QM Activities | QDOCREQ | QKZ | CHAR (1) | |
| MSGART | Notification Type when Blocking Function Is Active | QMSGFREI | QMSGART | CHAR (1) | |
| SPERRINAKT | Block Is Inactive | QSPINAKT | QKZ | CHAR (1) | |
| RESPERRE | Block Invoice | QRESPERRE | QKZ | CHAR (1) | |
| SRCGR | GR Control for Rejected Source Inspection Lot | QSRCGR | QSRCGR | CHAR (1) | |
| SRCBTCH | First Batch in Source Inspection Lot: GR Control | QSRCBTCH | QSRCBTCH | CHAR (1) | |
| PLN_USG_FAI | Inspection Plan Usage for First Article Inspection | QPLN_USG_FAI | PLN_VERWE | T411 | CHAR (3) |
Availability
The SAP table TQ08 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for TQ08 table
The following is the list of CDS views for TQ08 table, which can also be used instead of TQ08 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_QUALITYMGMTCTRLKEY | BASIC | Control Key for Quality Management |
| P_CTRLKEYFRQMPROC | BASIC | control key for qm procurement value help |
| A_QUALITYINPROCUREMENT | COMPOSITE | Quality Info Record Data |
| I_PRODEXQLTYINFORECDINPROCMT | COMPOSITE | Products without Q-Info records |
| I_QLTYINFORECDINPROCMTUNION | COMPOSITE | Union of Products with and without Q-info Records |
| I_QUALITYINFORECDINPROCMT | COMPOSITE | Products with or without Quality Info Records In Procurement |
| C_CTRLKEYQMPTEMP | CONSUMPTION | control key for qm procurement valuehelp |
| C_QLTYFIRSTARTICLEINSP | CONSUMPTION | First Article Inspection |
| C_QLTYINPROCMTMANAGECALC | CONSUMPTION | Manage Quality Info Record Procurement Calc |
| C_QLTYINPROCUREMENTMANAGE | CONSUMPTION | Manage Quality Inforecord in Procurement |
| C_QLTYINPROCUREMENTOBJPAGE | CONSUMPTION | Quality Info Record in Procurement |
