In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_query 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_MKTPL_QUERY 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_MKTPL_QUERY....Right lets get started!
Object Name: CRMD_MKTPL_QUERY
Dictionary Type: Transparent table
Description: CAL: Queries
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| QUERYGUID | SYSUUID_X | RAW | 16(0) | UUID in X form (binary) | SYSUUID | CRM | ||||||
| QUERYID | CRM_MKTPL_QUERYID | CHAR | 35(0) | CAL: QueryID | CRM_MKTPL_QUERYID | CRM | ||||||
| QUERYNAME | CRM_MKTPL_QUERY | CHAR | 35(0) | Kal: Query | CRM_MKTPL_QUERY | CRM_MKTPL_CLDR_QUERY | QUERYNAME | CRM | ||||
| CAMPCLASS | CRM_MKTPL_OBJ_GROUP | CHAR | 3(0) | CRM_MKTPL_OGRP | Object Grouping for Various Object Types in Marketing | CHAR3 | CRM | |||||
| SEARCHCRITID | CRM_MKTPL_SCID | CHAR | 15(0) | CRMC_MKTPL_SCID | CAL: Search Criteria ID | CHAR15 | CRM | |||||
| LOGONUSER | SYUNAME | CHAR | 12(0) | User Name | SYCHAR12 | SYST | CRM | |||||
| ROLE | AGR_NAME | CHAR | 30(0) | * | Role Name | AGR_NAME | AGR_NAME | AGR_NAME | CRM |