SAP Table CRMD_TM_SQ stores Search Query Headerdata
In this post, I will try and describe everything you need to know about the SAP crmd_tm_sq table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_TM_SQ what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_TM_SQ....Right lets get started!
SAP CRMD_TM_SQ dictionary attributes
Object Name: CRMD_TM_SQ
Dictionary Type: Transparent table
Description: Search Query Header
CRMD_TM_SQ field list
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| PID | CRMT_CLM_SEARCH_QUERY_ID | RAW | 16(0) | Search query id | SYSUUID | CRM | ||||||
| STORAGE_PID | CRMT_CLM_STORAGE_ID_X | RAW | 16(0) | Storage Id | CRM | |||||||
| PARENT_PID | CRMT_CLM_SEARCH_QUERY_ID | RAW | 16(0) | CRMD_TM_SQ | Search query id | SYSUUID | CRM | |||||
| FLAGS | CRMT_CLM_FLAGS | RAW | 4(0) | Indicators | CRM | |||||||
| BACKGROUND_EXEC | CRMT_CLM_EXECUTE_IN_PARALLEL | CHAR | 1(0) | Execute in parallel | CRM | |||||||
| PARENT_INST_PID | CRMT_CLM_SQ_INSTANCE_ID | CHAR | 255(0) | Instance Id | CRM | |||||||
| INCLUDE_SUBORD | CRMT_CLM_SQ_SEARCH_IN_SUBORD | CHAR | 1(0) | Include subordinate objects into the search | CRM_BOOLEAN | CRM | ||||||
| HITS_MAX | CRMT_CLM_SQ_HITS_MAX | INT4 | 10(0) | Maximum number of hits | CRM |
View list of all tables
