Find the Users with personalized Theme selection in Fiori Launchpad

[prakashsaurav]

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 Criteria 1

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 Criteria 2

User and corresponding Theme List

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

 

Source: Intelira

[former_member732734]

LIKE 😄

[mikeyfreake]

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

[prakashsaurav]

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

[prakashsaurav]

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

 

[Balu483]

hi Prakash S,

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

thanks in advance

 

regards,

Balu.

[abhijnansaha]

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