Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

When the email address stored of user?

former_member188843
Participant
0 Kudos

Dear All,

Who knows where the 'email' data saved of the user?

As we all known, in SU01 we can see the email address data in tab-page 'Address'.

BR

13 REPLIES 13

Former Member
0 Kudos

the table is ADR6

field SMTP_ADDR

Edited by: pratyush v on Feb 4, 2009 8:42 AM

former_member226203
Active Contributor
0 Kudos

if u hve the pernr, u can get email id from ADR6.

Also plz chk this link:

Former Member
0 Kudos

hi,

While updating existing Users' information through SU01,

the email (SMTP) address is getting stored in ADR6 also check

SU01D. ADR7.

thanks

0 Kudos

ADR7 is for Remote Mail Addresses

SuhaSaha
Advisor
Advisor
0 Kudos

Hello Ed,

The best way is to use the FM: BAPI_USER_GET_DETAIL.

You input the user name to this BAPI & it returns you the User Details.

Email will be in: field E_MAIL of the export parameter ADDRESS.

Else you have to do:

1. Goto USR21 --> Get the Person number(PERSNUMBER), Address number(ADDRNUMBER).

2. Goto table ADR6 give the PERSNUMBER & ADDRNUMBER, and get the email ID SMTP_ADDR.

BR,

Suhas

Edited by: Suhas Saha on Feb 4, 2009 1:47 PM

GauthamV
Active Contributor
0 Kudos

Hi,

you can get email address of user from ADR6 table.

use this condition to link user and email address.

USR21-PERSNUMBER = ADR6-PERSNUMBER.

email address : ADR6-SMTP_ADDR.

former_member188843
Participant
0 Kudos

Thanks for all your reply!

0 Kudos

Is your problem solved ?

0 Kudos

Yes. Your information is helpful.

0 Kudos

If so close the thread by rewarding helpful answers.

0 Kudos

I already closed.Did you see it?

0 Kudos

I think you didn't read my full reply ?

Former Member
0 Kudos

Hi,

U can go to SYSTEM in the Menu go to user Profile & then "Own Data" there u will find the current user email id.