The CRMC_DQ_ATTROP table in SAP ERP or S/4HANA stores Operators for advanced query attributes data. There are total 14 fields in CRMC_DQ_ATTROP table. The Operators for advanced query attributes 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_DQ_ATTROP table. It is in Customizing Objects for Generic Interaction Layer (CRM_GENIL_CUST) ABAP package and is part of the Generic Interaction Layer (CA-WUI-GOL-GIL) module.
SAP CRMC_DQ_ATTROP Table Fields
Following is the list of fields that are available in SAP CRMC_DQ_ATTROP table. The primary key fields of Operators for advanced query attributes table in SAP are COMPONENT (Component Name), DQUERY_NAME (External Name of Object), ATTR_NAME (Component name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| COMPONENT | Component Name | CRMT_COMPONENT_NAME | CRMC_DQ_COM | CHAR (6) |
| DQUERY_NAME | External Name of Object | CRMT_EXT_OBJ_NAME | CRMC_DQ_COM | CHAR (30) |
| ATTR_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) |
