The CRMC_MC_DQO table in SAP ERP or S/4HANA stores CRM Marketing: Marketing Contact Dynamic Query Options data. There are total 13 fields in CRMC_MC_DQO table. The CRM Marketing: Marketing Contact Dynamic Query Options 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 CRMC_MC_DQO table. It is in CRM Marketing: Marketing Contact BOL/GenIL (CRM_MKTHV_MC_IL) ABAP package and is part of the Marketing Prospect (CRM-MKT-MP) module.
SAP CRMC_MC_DQO Table Fields
Following is the list of fields that are available in SAP CRMC_MC_DQO table. The primary key fields of the table are DQUERY_NAME (External Name of Object), ATTRIBUTE_NAME (Component name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DQUERY_NAME | External Name of Object | CRMT_EXT_OBJ_NAME | CHAR (30) | |
| ATTRIBUTE_NAME | Component name | NAME_KOMP | CHAR (30) | |
| OPTIONS_AV | Indicates if options are available or not available | GENILT_OPTIONS_AVAILABLE | CHAR (1) | |
| EQ | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| NE | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| BT | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| NB | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| CP | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| NP | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| LT | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| LE | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| GT | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| GE | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) |
