The CRMC_ERMS_ATTR table in SAP ERP or S/4HANA stores ERMS Attributes data. There are total 12 fields in CRMC_ERMS_ATTR table. The ERMS 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_ERMS_ATTR table. It is in CRM_ERMS_REPOSITORY (CRM_ERMS_REPOSITORY) ABAP package and is part of the Rule Maintenance (CRM-IC-EMS-RUL) module.
SAP CRMC_ERMS_ATTR Table Fields
Following is the list of fields that are available in SAP CRMC_ERMS_ATTR table. The primary key fields of ERMS Attributes table in SAP are MANDT (Client), CTXTID (Context), ATTRID (Attribute).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CTXTID | Context | CRM_ERMS_CTXTID | CRMC_ERMS_CTXT | CHAR (16) |
| ATTRID | Attribute | CRM_ERMS_ATTRID | CHAR (16) | |
| ATTRGUID | Attribute GUID | CRM_ERMS_ATTRGUID | RAW (16) | |
| CONCATID | Attribute Concatenated ID | CRM_ERMS_CONCATID | CHAR (255) | |
| XPATH | XPath Expression | CRM_ERMS_XPATH | CHAR (255) | |
| ACCESSOR | Accessor Service | CRM_ERMS_ACCESSOR | CHAR (32) | |
| PROVIDERSERVICE | Fact Gathering Service | CRM_ERMS_FGSERVICE | CHAR (16) | |
| MULTIVALUE | Multivalue Attribute | CRM_ERMS_MULTIVALUE | CHAR (1) | |
| SHORTLIST | Show Attribute | CRM_ERMS_SHORTLIST | CHAR (1) | |
| ATTR_EXT_CLS | Attribute Extension Class | CRM_ERMS_ATTR_EXT_CLS | CHAR (30) | |
| SETVAL_ALLOWD | ERMS Attribute: “Set Value” Action Allowed | CRM_ERMS_SETVAL_ALLOWD | CHAR (1) |
