Custom Security report for audit

Hi Gurus,

I am trying to develop a security report having below fields and I am using these tables to develop this SQ01 query/t-code = AGR_USERS, USER_ADDR, ADR6

But, I am not able to build a relationship between user id of table USER_ADDR and ADR6. Can anyone please help me how should I proceed ?

User id

Last name

First name

Email id

Security role

Validity from

Validity to

Regards,

Salman