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