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: 

Table for Username & Email address

Former Member

Hello All,

Is there is any table for Username & Email address.

I am having the email address from that I have to find out the username.

Regards,

Vasanth

1 ACCEPTED SOLUTION

Former Member

Search the email address in ADR6.

For this you will get an address number and person number

Use the address number in USR21 to get the user

11 REPLIES 11

Former Member
0 Kudos

Hi,

Use table <b>ADR6</b> for email address

for that u have to find Address number associated with User.

Former Member

use usr21 and adr6,

from adr6 give email address and get personal number and address number , using these goto usr21 and get user name

Former Member
0 Kudos

hi vasanth,

cehck these tables...

USR01 User master record (runtime data)

USR04 User master authorizations

USR05 User Master Parameter ID

USR10 User master authorization Profiles

USR11 User Master Texts for Profiles (USR10)

USR12 User master authorization values

search with USR* in SE11 should get you a list of all the User tables in SAP

hope this helps,

do reward if it helps,

priya.

Former Member

Search the email address in ADR6.

For this you will get an address number and person number

Use the address number in USR21 to get the user

0 Kudos

Hello Dominic,

I have did exactly as what u said. But i´n the ADR6 table they are maintaining more than one entry for a email ID.In that situation what can I do...

Regards,

Vasanth

0 Kudos

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,

Rich Heilman

0 Kudos

In that case take the address for which the field <b>flgdefault</b> is set to X.

This should get you only one , unless different users have same email address

0 Kudos

Hi vasanth,

1. There are 2 tables:

ADR6

USR21

2. From Usr21

Get PERSNUMBER

ADDRNUMBER

For BNAME = username

3. Then

From ADR6

Get TEL_NUMBER , etc.

For Above

ADDRNUMBER and

PERSNUMBER

I hope it helps.

regards,

amit m.

Former Member
0 Kudos

Hi Vasanth,

First get the address number and pers. number from table USR21 for a given user

and then

go to table ADR6 to get the eamil address of the user.

You can get it from ADR6.

Regards,

Laxmi.

Message was edited by: Laxmi

former_member806088
Discoverer

Table PUSER002

0 Kudos

thx - saves me the search for a cds