Email id from SU01 tcode

[Former Member]

Hi Guys,

I am trying to get email id in SU01 tcode. I don't find it in USR* tables.

Any FM available to get it.

Thanks

[Former Member]

Hi,

try using FM

HR_FBN_GET_USER_EMAIL_ADDRESS

EFG_GEN_GET_USER_EMAIL

UMB_SERVICE_USER_EMAIL

best of luck!!!

thanks

Ravi

[Former Member]

Hi,

Try this FM: UMB_SERVICE_USER_EMAIL

George

[arpit_shah]

Hi,

Pl check ADR6 table.

Regards,

Arpit

[GauthamV]

Plz SEARCH in SCN before posting.

[UmaArjunan]

1. Try this function module : BAPI_USER_GET_DETAIL

2. Another way by using sap tables :

DATA: lv_smtp_addr TYPE adr6-smtp_addr.

SELECT SINGLE a~smtp_addr

INTO lv_smtp_addr

FROM adr6 AS a

INNER JOIN usr21 AS b

ON a_{persnumber = b}persnumber

AND a_{addrnumber = b}addrnumber

WHERE b~bname = va_username.

va_username - name of the user for which the email address retreived and stored in the variable

lv_smpt_addr.

Thanks,

Uma

[Former Member]

Hi,

Please make use of USR21 and ADR6 table.

Regards,

Ankur Parab

[former_member585060]

Hi,

Instead of FM use below 2 select statements to get the Email address

SELECT SINGLE addrnumber persnumber FROM usr21 INTO (lv_addrnumber, lv_persnumber)
                                                              WHERE bname = lv_user.

SELECT SINGLE smtp_addr FROM adr6 INTO lv_smtp_addr
                                                  WHERE addrnumber = lv_addrnumber
                                                   AND persnumber      = lv_persnumber.

Regards

Bala Krishna

[Former Member]

Solved

[Former Member]

Hi

if you want to see only Email ID then go to ADR6 but you cant see user ID here.

to see both user ID and Email ID then join two tables called USR21 and ADR6 by uisng SQVI tcode..

I hope this will help you.

Thanks

Ravi

[Former Member]

Hi Ravi,

This is good information.  I need to use a tool like Tivoli, (Political), to monitor a few critical ID's and if they get locked then send an email to our BASIS and Security team.  Is the "Change Documents for Users" in ADR6?  Basically I need to query the table and if the status is locked for a particular ID, then send out the email.

Cheers,

Dan Mead

[robert_smith9]

Old post I know, but thanks, SQVI really helped me out.