SAP AQLTQ Table – SP Query: Texts for Queries

The AQLTQ table in SAP ERP or S/4HANA stores SP Query: Texts for Queries data. There are total 9 fields in AQLTQ table. The SP Query: Texts for Queries table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AQLTQ table. It is in Application Development R/3 SAP Query (SQUE) ABAP package and is part of the SAP Query (BC-SRV-QUE) module.

SAP AQLTQ Table Fields

Following is the list of fields that are available in SAP AQLTQ table. The primary key fields of the table are MANDT (Client), SPRSL (SAP Query (S): Language key), NUM (SAP Query (S): Name of a user group), QNUM (SAP Query (S): Query name), TINDX (SAP Query (S): Text Index).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT (3)
SPRSL SAP Query (S): Language key AQS_SPRSL LANG (1)
NUM SAP Query (S): Name of a user group AQS_BGNAME CHAR (12)
QNUM SAP Query (S): Query name AQS_QUNAME CHAR (14)
TINDX SAP Query (S): Text Index AQS_TINDX NUMC (5)
HEAD SAP Query (S): Flag AQS_FLAG CHAR (1)
MODIF SAP Query (S): Modification number AQS_MODIF NUMC (4)
MAXL SAP Query (S): Maximum text length AQS_MAXL NUMC (3)
TEXT SAP Query (S): Text of length 255 AQS_TXT255 CHAR (255)