The CRMD_TM_SQ table in SAP ERP or S/4HANA stores Search Query Header data. There are total 4 fields in CRMD_TM_SQ table. The Search Query Header 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_TM_SQ table. It is in Call List Management Persistent Storages (CRMCIC_CLM_PS) ABAP package and is part of the Campaign Execution (CRM-CIC-CAM) module.
SAP CRMD_TM_SQ Table Fields
Following is the list of fields that are available in SAP CRMD_TM_SQ table. The primary key fields of the table are CLIENT (Client), PID (Search query id).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| PID | Search query id | CRMT_CLM_SEARCH_QUERY_ID | RAW (16) | |
| PARENT_PID | Search query id | CRMT_CLM_SEARCH_QUERY_ID | CRMD_TM_SQ | RAW (16) |
| INCLUDE_SUBORD | Include subordinate objects into the search | CRMT_CLM_SQ_SEARCH_IN_SUBORD | CHAR (1) |
