The CMPERSPARM table in SAP ERP or S/4HANA stores Personalization: User Settings data. There are total 11 fields in CMPERSPARM table. The Personalization: User Settings 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 CMPERSPARM table. It is in DDIC Objects for Personalization (K_CM_PERS_DDIC) ABAP package and is part of the Cross-Application Components (CA) module.
SAP CMPERSPARM Table Fields
Following is the list of fields that are available in SAP CMPERSPARM table. The primary key fields of the table are MANDT (Client), PERSKEYTP (Key Type for Personalization Data (User, Role, …)), PERSKEY (Key for Personalization Data (User, Role, …)), APPLID (Personalization Application Name), FIELDNAME (Field Name), FIELDINDEX (Counter for Personalization Data).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PERSKEYTP | Key Type for Personalization Data (User, Role, …) | KCMP_KEYTP | CHAR (1) | |
| PERSKEY | Key for Personalization Data (User, Role, …) | KCMP_KEY | CHAR (30) | |
| APPLID | Personalization Application Name | KCMP_APPID | CMPERSAPPL | CHAR (30) |
| FIELDNAME | Field Name | FIELDNAME | * | CHAR (30) |
| FIELDINDEX | Counter for Personalization Data | KCMP_INDEX | NUMC (10) | |
| FIELDTYPE | Field Type: Value, Interval, Hierarchy, String, … | KCMP_FTYPE | CHAR (1) | |
| SEL_SIGN | Sign (like RANGES table) | S_SIGN | CHAR (1) | |
| SEL_OPTION | Operator of Selection Option | SEL_OPTION | CHAR (2) | |
| LOW | From Value | KCMP_LOW | CHAR (60) | |
| HIGH | To Value | KCMP_HIGH | CHAR (60) |
