Skip to Content
Technical Articles

Find the Users with personalized Theme selection in Fiori Launchpad

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_TYPEUPERS_KEY/UI2/USER_PROFILEFIELDNAMEIDFIELDVALUETHEME

PERS_TYPE U
PERS_KEY /UI2/USER_PROFILE
FIELDNAME ID
FIELDVALUE THEME

Selection%20Criteria%201

Selection Criteria 1

Unique%20IDs%20for%20Theme

Unique IDs for 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

Selection%20Criteria%202

Selection Criteria 2

User%20and%20corresponding%20Theme%20List

User and corresponding Theme List

User ID’s @ OBJECT_ID (Peronalization Object) Column
Selected Theme’s @ FIELDVALUE (Personalization Data) Column

 

Source: Intelira

5 Comments
You must be Logged on to comment or reply to a post.