This article provides the details of db tables to be used to extract SAP User Master data - User ID, First Name, Last Name, Address, Email and assigned roles.
The tables you are looking for are USR21, AGR_USERS, ADRP, ADR6.
Please login to view this article. If you are not a member please register to DivulgeSAP.com for free. It's very easy to register and takes only few seconds. DivulgeSAP.com is completely spam free and we don't send unnecessary emails.