SAP WPPERSPARM Personalization: User Settings Table
Overview
WPPERSPARM is a standard SAP S/4HANA table that stores Personalization: User Settings data. There are total 11 fields in the WPPERSPARM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WPPERSPARM belongs to Cross-Application Components (CA) module and is located in the package DDIC Objects for Personalization (S_CM_PERS_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WPPERSPARM to other SAP tables and standard CDS views available based on WPPERSPARM table in S/4HANA 2020.
Techincal Settings of WPPERSPARM
Below are technical details of the table WPPERSPARM
- Buffering allowed but switched off
- Full buffering as specified by generic key
- Storage type is Column Store
List of WPPERSPARM Fields
The following table gives you an overview of the fields available in WPPERSPARM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PERSKEYTP | Key Type for Personalization Data (User Role ...) | SWPP_KEYTP | CHAR | 1 | |
| PERSKEY | Key for Personalization Data (User Role ...) | SWPP_KEY | CHAR | 30 | |
| APPLID | Personalization Application Name | SWPP_APPID | WPPERSAPPL | CHAR | 30 |
| FIELDNAME | Field Name | FIELDNAME | * | CHAR | 30 |
| FIELDINDEX | Counter for Personalization Data | SWPP_INDEX | NUMC | 10 | |
| FIELDTYPE | Field Type: Value Interval Hierarchy String ... | SWPP_FTYPE | CHAR | 1 | |
| SEL_SIGN | Sign | SSIGN | CHAR | 1 | |
| SEL_OPTION | Operator of Selection Option | SEL_OPTION | CHAR | 2 | |
| LOW | From value | SWPP_LOW | CHAR | 60 | |
| HIGH | To value | SWPP_HIGH | CHAR | 60 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WPPERSPARM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WPPERSPARM | APPLID | 1: CN | WPPERSAPPL |
| WPPERSPARM | MANDT | 1: CN | T000 |