The CRMC_ERMS_CAT_AD table in SAP ERP or S/4HANA stores Coherent Cat – Aspect Labels data. There are total 8 fields in CRMC_ERMS_CAT_AD table. The Coherent Cat – Aspect Labels 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_CAT_AD table. It is in CRM_ERMS_CATEGORIZATION (CRM_ERMS_CATEGORIZATION) ABAP package and is part of the Categories (CRM-IC-EMS-CAT) module.
SAP CRMC_ERMS_CAT_AD Table Fields
Following is the list of fields that are available in SAP CRMC_ERMS_CAT_AD table. The primary key fields of Coherent Cat – Aspect Labels table in SAP are CLIENT (Client), LANG (Language Key), ASP_GUID (Multilevel Cat. – GUID Data Element).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| LANG | Language Key | LANGU | T002 | LANG (1) |
| ASP_GUID | Multilevel Cat. – GUID Data Element | CRM_ERMS_CAT_GUID | CRMC_ERMS_CAT_AS | RAW (16) |
| ASP_LABEL | Coherent Cat – Category Description | CRM_ERMS_CAT_CA_DESC | CHAR (50) | |
| ASP_LABEL_UC | Coherent Cat – Category Description | CRM_ERMS_CAT_CA_DESC | CHAR (50) | |
| TSTAMP_CREATE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| TSTAMP_MODIFY | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| RESP_USER | Last change by | UPNAME | CHAR (12) |
