QINFLTEXT is a standard SAP table in SAP ECC (or) S/4HANA which stores Quality Info Record in Procurement Long Text data. There are total 11 fields in QINFLTEXT table.This blog post provides key technical details of SAP table QINFLTEXT, including its availability across SAP S/4HANA versions and the list of CDS views for QINFLTEXT table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | QM in procurement (QB) |
| Technical Component | QM Control in Procurement (QM-PT-RP-PRC) |
SAP QINFLTEXT Table Fields
The following is the list of fields that are available in SAP QINFLTEXT table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | CLNT (3) | |
| MATNR | Material Number | MATNR | MATNR | CHAR (40) | |
| QINF_ZAEHL | Internal Counter for DB Objects | Q_COUNT | Q_COUNT | NUMC (6) | |
| LANGU | Language Key | LANGU | SPRAS | LANG (1) | |
| CREATED_BY | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| CREATED_AT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS | DEC (15) | |
| CHANGED_BY | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| CHANGED_AT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS | DEC (15) | |
| TEXTID | Text ID | TDID | TDID | TTXID | CHAR (4) |
| MIMETYPE | DD: Mime Type for Full-Text Index | DD_FTI_MIME_TYPE | DD_FTI_MIME_TYPE | * | CHAR (127) |
| TXT_COMPATIBILITY | Text Compatibility | QTXT_COMPATIBILITY | QTXT_COMPATIBILITY | CHAR (1) |
Availability
The SAP table QINFLTEXT 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 QINFLTEXT table
The following is the list of CDS views for QINFLTEXT table, which can also be used instead of QINFLTEXT table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_QLTYINPROCMTLONGTEXT | BASIC | Q-Info Record in Procurement Long Text |
| A_QUALITYINPROCUREMENT | COMPOSITE | Quality Info Record Data |
| C_QLTYINPROCUREMENTLONGTEXT | CONSUMPTION | Qlty in Procmt Long Text CTP View |
