topic Re: data dictionary in Application Development and Automation Discussions

data dictionary

Former Member — Tue, 28 Nov 2006 13:11:23 GMT

Hi Friends,

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

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:12:52 GMT

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

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:16:59 GMT

Hi,

use the table <b>ADR6</b>

Regards

Vijay

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:18:58 GMT

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

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:19:00 GMT

in table ADR6....field SMTP_ADDR

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:20:46 GMT

Hello,

CHECK the table USR21 & ADR6.

If useful reward.

Vasanth

Re: data dictionary

Former Member — Tue, 28 Nov 2006 13:21:46 GMT

MEREP_E_MAIL

Re: data dictionary

amit_khare — Tue, 28 Nov 2006 13:21:56 GMT

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