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

October 23, 2017   Authorization , query , security , sqvi , user email

SQVI

Quickview: Email

Click Create

Datasource: Table Join

Ok

Edit > Insert Table (both tables)
ADRP
ADR6
USR21

Click Check. If defined joined condition is correct, click back

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

Click on selection field tab. Select user name in master data. Add to the left column.

Click check for errors. If none, then proceed to execute

Now you can search using username and it will show your the first name, last name and email address