The AQPROT table in SAP ERP or S/4HANA stores Query Logging data. There are total 17 fields in AQPROT table. The Query Logging 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 AQPROT 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 AQPROT Table Fields
Following is the list of fields that are available in SAP AQPROT table. The primary key fields of the table are MANDT (Client), SESSION_ID (GUID in ‘CHAR’ Format in Uppercase), LFDNUM (SAP Query (T): Order Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| SESSION_ID | GUID in ‘CHAR’ Format in Uppercase | GUID_32 | CHAR (32) | |
| LFDNUM | SAP Query (T): Order Number | AQT_CCNT | NUMC (6) | |
| WORKSPACE | SAP Query (S): Work Area ID | AQS_WSID | CHAR (1) | |
| FUNCAREA | SAP Query (S): InfoSet | AQS_SGNAME | CHAR (24) | |
| USERNAME | User Name | UNAME | CHAR (12) | |
| TSP_DATE | System Date | SYDATUM | DATS (8) | |
| TSP_TIME | System Time | SYUZEIT | TIMS (6) | |
| TABNAME | Table Name | TABNAME | * | CHAR (30) |
| FIELDNAME | Field Name | FIELDNAME | * | CHAR (30) |
| AQ_FIELD | SAP Query (S): Field name (table field) | AQS_FNAME | CHAR (70) | |
| FIELDTYPE | Field Type (Output Field/Selection Field) | AQS_FTYPE | NUMC (1) | |
| SIGN | ABAP: ID: I/E (include/exclude values) | TVARV_SIGN | CHAR (1) | |
| OPTI | ABAP: Selection option (EQ/BT/CP/…) | TVARV_OPTI | CHAR (2) | |
| LOW | ABAP: Selection Value (LOW or HIGH Value, External Format) | TVARV_VAL | CHAR (45) | |
| HIGH | ABAP: Selection Value (LOW or HIGH Value, External Format) | TVARV_VAL | CHAR (45) | |
| ADD_DATA | Character 100 | CHAR100 | CHAR (100) |
