Why is SAP authorization profile red or yellow?

When you change a role, you must regenerate the authorization profile. In this case, the status of the profile generation is displayed red or yellow at the top of the Authorizations tab page, and is explained in more detail further down the tab page with a short text:

·        If the status display is red, you must perform an authorization data comparison, since the menu was changed since the last profile generation or no authorization data exists.

·        If the display is yellow, the authorization data for the role was changed and saved after the last generation. The generated profile is no longer current. You need to regenerate it.

SAP Query using tcode SQVI with username and email as the result

1. SQVI
2. Quickview: Email
3. Click Create
   
4. Datasource: Table Join
   
5. Ok
6. Edit > Insert Table (both tables)
   ADRP
   ADR6
   USR21
7. Click Check. If defined joined condition is correct, click back
   
8. Expend and select the field you would like to see in the result
   
   eg: First Name, Last Name, E-Mail Address and User Name in User Master Record
   
   
9. Click on selection field tab. Select user name in master data. Add to the left column.
   
10. Click check for errors. If none, then proceed to execute
11. Now you can search using username and it will show your the first name, last name and email address