Skip to Content
Technical Articles
Author's profile photo Prakash Saurav
Prakash Saurav
March 4, 2021 1 minute read

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Read MeCom!
      Read MeCom!

      LIKE 😀

      Author's profile photo Mike Freake
      Mike Freake

      This is great. Are you able to enhance this article or post another showing the table(s) containing other personalization info for the Fiori Launchpad?

      For instance, I'd like to know which users have personalized their Fiori groups and tiles.

      Thanks,

      Mike

      Author's profile photo Prakash Saurav
      Prakash Saurav
      Blog Post Author

      Thanks for the feedback. That’s good idea I will try to do that .

      Author's profile photo Prakash Saurav
      Prakash Saurav
      Blog Post Author

      Mike Freake As requested here it is Find the users with Fiori Launchpad Personalization

       

      Author's profile photo B@lu .
      B@lu .

      hi Prakash S,

      how to check/see list of all available themes in system.

      thanks in advance

       

      regards,

      Balu.

      Author's profile photo Abhijnan Saha
      Abhijnan Saha

      Hi Prakash,

      Thanks for the references. In case you have applied a custom theme and the screen goes into an error then these steps are your only saviour unless you want to recreate your user.

      This worked for me with some alterations.

      As per your steps, with some changes in column names, it would now be:

      1. In table SPERS_OBJ, filter using SAP UserID on column OBJECT_ID
      2. Look for rows which have PERS_KEY = "/UI2/USER_PROFILE" and FIELDVALUE = "THEME"
      3. Pick the value of column "ADD_KEY" from this row in Step2.
      4. Using this "ADD_KEY" value filter on table SPERS_OBJ again.
      5. Few rows will be fetched. Look for those where the column "FIELDNAME" has a value = "VALUE".
      6. In the column "FIELDVALUE", the theme name eg: "sap_belize" will be present.
      7. The table is available in a non-cross client maintenance mode. Therefore modify the theme as required.

      Alternatively:

      Steps 1- 5 can be skipped and would be easier to filter on the table directly using OBJECT_ID = <SAP user name> and FIELDVALUE = "VALUE".

      Thanks and Regards,

      Abhijnan