In SAP Fiori Launchpad user can personalize it and select their theme of choice as well.
This blog discusses the way to find all the users who are not using the default configured theme and has their own choice of theme in the Fiori Launchpad.
- If you are trying to find users with personalized launchpad groups please Click Here
System Details (On-Prem)
Below is the specification of the system used for this analysis.
| Product | Release | SP Stack |
| NW AS ABAP | 7.52 | 03 |
| SAP FIORI FRONT-END SERVER | 6.0 | SP01 |
Base Database Table
SAP table SPERS_OBJ (Personalization object repository) is used to find the desired results.
Step 1: Find the Unique ID’s related to Theme Selection by Users
Go to data browser for the table SPERS_OBJ and enter below values for respective fields. Execute and get the list of the Unique ID’s for Theme Selection. This result set also gives you the list of users in the column OBJECT_ID (Personalization Object)
| PERS_TYPE | U |
| PERS_KEY | /UI2/USER_PROFILE |
| FIELDNAME | ID |
| FIELDVALUE | THEME |
Step 2: Use the Unique ID’s to find the corresponding theme selected by the given user
Select the list of the unique ids from above result set and use the same in the selection criteria for the table SPERS_OBJ to get the result.
| PERS_TYPE | U |
| PERS_KEY | /UI2/USER_PROFILE |
| FIELDNAME | VALUE |
| ADD_KEY | List of Unique ID’s found in first list |
User ID’s @ OBJECT_ID (Peronalization Object) Column
Selected Theme’s @ FIELDVALUE (Personalization Data) Column