• 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