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.
|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)
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.
|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
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 for the feedback. That’s good idea I will try to do that .
Mike Freake As requested here it is Find the users with Fiori Launchpad Personalization
hi Prakash S,
how to check/see list of all available themes in system.
thanks in advance
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:
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,