topic Re: Email id from SU01 tcode in Application Development and Automation Discussions

Email id from SU01 tcode

Former Member — Thu, 04 Jun 2009 03:59:12 GMT

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

Re: Email id from SU01 tcode

Former Member — Thu, 04 Jun 2009 04:03:18 GMT

Hi,

try using FM

HR_FBN_GET_USER_EMAIL_ADDRESS

EFG_GEN_GET_USER_EMAIL

UMB_SERVICE_USER_EMAIL

best of luck!!!

thanks

Ravi

Re: Email id from SU01 tcode

Former Member — Thu, 04 Jun 2009 04:06:45 GMT

Hi,

Try this FM: UMB_SERVICE_USER_EMAIL

George

Re: Email id from SU01 tcode

arpit_shah — Thu, 04 Jun 2009 04:31:55 GMT

Hi,

Pl check ADR6 table.

Regards,

Arpit

Re: Email id from SU01 tcode

GauthamV — Thu, 04 Jun 2009 04:35:26 GMT

Plz SEARCH in SCN before posting.

Re: Email id from SU01 tcode

UmaArjunan — Thu, 04 Jun 2009 04:52:46 GMT

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

Re: Email id from SU01 tcode

Former Member — Thu, 04 Jun 2009 05:04:10 GMT

Hi,

Please make use of USR21 and ADR6 table.

Regards,

Ankur Parab

Re: Email id from SU01 tcode

former_member585060 — Thu, 04 Jun 2009 05:08:01 GMT

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

Re: Email id from SU01 tcode

Former Member — Tue, 09 Jun 2009 02:14:21 GMT

Solved

Re: Email id from SU01 tcode

Former Member — Wed, 02 Jan 2013 10:58:36 GMT

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

Re: Email id from SU01 tcode

Former Member — Mon, 05 Oct 2015 15:54:20 GMT

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

Re: Email id from SU01 tcode

robert_smith9 — Tue, 04 Oct 2016 20:17:56 GMT

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