data dictionary

[Former Member]

Hi Friends,

could pls tell me in which table will i find email address

[Former Member]

Hi,

You are right - I need to combine two tables. ADR6 & USR21 will provide the

combination of user id and email address.

Message was edited by:

Sudheer Junnuthula

[Former Member]

Hi,

use the table <b>ADR6</b>

Regards

Vijay

[Former Member]

Hi prakash,

You can do it like this. I believe that the email address for your selection must be capitalized.

data: bname type usr01-bname.

select Single usr21~bname into bname

from usr21

inner join adr6

on usr21_{addrnumber = adr6}addrnumber

and usr21_{persnumber = adr6}persnumber

where adr6~smtp_addr = YOU@YOURCOMPANY.COM'.

write:/ bname.

Regards.

Kumar

[Former Member]

in table ADR6....field SMTP_ADDR

[Former Member]

Hello,

CHECK the table USR21 & ADR6.

If useful reward.

Vasanth

[Former Member]

MEREP_E_MAIL

[amit_khare]

If you are looking for employees email id they are stored in PA0105, you have to check the subtype for your system.

otherwise general address you may find in SOS04-L_ADR_NAME this is use by SAP Business workplace..

Regards,

Amit