The CRMD_MKTPL_QUVAL table in SAP ERP or S/4HANA stores CAL: Query Search Field Values data. There are total 9 fields in CRMD_MKTPL_QUVAL table. The CAL: Query Search Field Values 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_MKTPL_QUVAL table. It is in Marketing Planner calendar (CRM_MKTPL_CALENDAR) ABAP package and is part of the Marketing Calendar (CRM-MKT-MPL-CAL) module.
SAP CRMD_MKTPL_QUVAL Table Fields
Following is the list of fields that are available in SAP CRMD_MKTPL_QUVAL table. The primary key fields of the table are MANDT (Client), QUERYSFVGUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| QUERYSFVGUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| QUERYGUID | UUID in X form (binary) | SYSUUID_X | CRMD_MKTPL_QUERY | RAW (16) |
| TABLENAME | 30 Characters | CHAR30 | CHAR (30) | |
| FIELDNAME | Field name | NAME_FELD | CHAR (30) | |
| SFTYPE | Search Field Type | CRM_MKTPL_SFTYPE | CHAR (1) | |
| MULTPOSSIBLE | Multiple Selection Possible | CRM_MKTPL_MULT | CHAR (1) | |
| SIGN | Single-Character Flag | CHAR1 | CHAR (1) | |
| S_OPTION | Component of the Version Number | CHAR2 | CHAR (2) |
