The CRMD_DH_QUERY table in SAP ERP or S/4HANA stores Query Buffer data. There are total 7 fields in CRMD_DH_QUERY table. The Query Buffer 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 CRMD_DH_QUERY table. It is in Operative Reporting in CRM (CRM_REPORT) ABAP package and is part of the Reporting Framework (CRM-BTX-ANA-RFW) module.
SAP CRMD_DH_QUERY Table Fields
Following is the list of fields that are available in SAP CRMD_DH_QUERY table. The primary key fields of the table are CLIENT (Client), USERID (User Name), ZONLO (Time Zone), QUERYID (4 Byte Signed Integer).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| USERID | User Name | UNAME | CHAR (12) | |
| ZONLO | Time Zone | SYSTZONLO | CHAR (6) | |
| QUERYID | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| EXECUTED_AT | Time of Preceding Execution of Query | CRM_DH_EXECUTED_AT | DEC (15) | |
| REFCNT | Counts the Number of References to an Object | CRM_DH_REFCNT | INT4 (10) | |
| VALID_TO | Time at Which Query Will Automatically Be Removed from DH | CRM_DH_VALID_TO | DEC (15) |
