email ID's of users

[Former Member]

Hi,

can any body very urgently tell me the way to display the users

and the email addresses of them.

i.e., i have list of users and i need the email addresses of them.

Is there any short cut to get the entire list other than with SU01.

Thanks in advance,

DVRK

[Former Member · Accepted solution]

Hello Rama,

Write a simple query using SQVI transaction using join of tables USR21 and ADR6.

It is pretty simple.

Regards.

Ruchit.

[Former Member · Accepted solution]

can u please tell me how to join the table of USR21, ADR06.

Thannks a lot

[JPReyes · Accepted solution]

Hi Rama,

SQVI -> create a new quick view-> datasource: tablejoin -> add the two tables -> choose the fields -> execute

Very easy as Ruchit said

Regards

Juan

[Former Member]

Hi Rama,

Go through the below thread, it gives detail step by step process to retrive E-mail id & User ID (Very good explanation by Ruchit in below thread)

?

Regards,

Rajesh

[Former Member]

Hi,

Excellent ! I got the required Email ID's very easily with SQVI.

Thanks a lot ..

Ramakrishna

[Former Member]

Hi I could not open the thread...please tell the link or ramkrishna please send the details again..plzz