topic Re: Table for Username & Email address in Application Development and Automation Discussions

Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:24:20 GMT

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:28:10 GMT

Hi,

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

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:28:37 GMT

use usr21 and adr6,

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:29:32 GMT

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.

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:30:40 GMT

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:32:51 GMT

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:33:16 GMT

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

Re: Table for Username & Email address

RichHeilman — Tue, 27 Jun 2006 13:35:13 GMT

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:35:52 GMT

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

Re: Table for Username & Email address

Former Member — Tue, 27 Jun 2006 13:37:36 GMT

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.

Re: Table for Username & Email address

former_member806088 — Fri, 14 Oct 2022 07:10:45 GMT

Table PUSER002

Re: Table for Username & Email address

geert_nackers3 — Wed, 08 Feb 2023 17:18:10 GMT

thx - saves me the search for a cds