In this post, I will try and describe everything you need to know about the SAP crmd_tm_sqch 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_SQCH 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_SQCH....Right lets get started!
Object Name: CRMD_TM_SQCH
Dictionary Type: Transparent table
Description: Search Query Conditions Header
| 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 | ||||
| QUERY_PID | CRMT_CLM_SEARCH_QUERY_ID | RAW | 16(0) | CRMD_TM_SQ | Search query id | SYSUUID | CRM | |||||
| PID | UUID | RAW | 16(0) | Global Unique ID for table | UUID | CRM | ||||||
| PARENT_PID | UUID | RAW | 16(0) | Global Unique ID for table | UUID | CRM | ||||||
| ATTRIBUTE_NAME | CHAR30 | CHAR | 30(0) | 30 Characters | CHAR30 | SAP | CRM | |||||
| REF_ATTR | CHAR1 | CHAR | 1(0) | Single-Character Indicator | CHAR1 | SAP | CRM | |||||
| FLAGS | RAW4 | RAW | 4(0) | Hexadecimal field 4 characters | RAW4 | CRM |