cancel
Showing results for 
Search instead for 
Did you mean: 

Table for login name and corresponding E-mail address.

Former Member
0 Kudos

Hi all,

I have reqirement of getting user name(Login name) and user email address.Can anybody tell me the table for these details.

Thank you,

Sanjay Deshpande.

Accepted Solutions (1)

Accepted Solutions (1)

sikindar_a
Active Contributor
0 Kudos

and also check V_T591A for the subtypes

Former Member
0 Kudos

As said, the connection between employee and user is in IT0105, subtype 0001.

However, the email-address for the user is maintained in SU01 (many companies reads this from 0010 automatically). This mail-address you find via FM BAPI_USER_GET_DETAIL. It is returned in the ADDSMTP table.

To check tables directly:

1. Find users PERSNUMBER and ADDRNUMBER in table USR21

2. Use these values to check email in table ADR6

Hope this helps

Kirsten

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

It will be stored in IT 105(Communictions). Check subtype 0001 for user name and 0010 for Email address.

Check in PA0105 table.

Thanks and Regards,

Shilpashree