2006 Jun 27 2:24 PM
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
2006 Jun 27 2:30 PM
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
2006 Jun 27 2:28 PM
Hi,
Use table <b>ADR6</b> for email address
for that u have to find Address number associated with User.
2006 Jun 27 2:28 PM
use usr21 and adr6,
from adr6 give email address and get personal number and address number , using these goto usr21 and get user name
2006 Jun 27 2:29 PM
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.
2006 Jun 27 2:30 PM
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
2006 Jun 27 2:33 PM
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
2006 Jun 27 2:35 PM
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
2006 Jun 27 2:35 PM
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
2006 Jun 27 2:37 PM
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.
2006 Jun 27 2:32 PM
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
2022 Oct 14 8:10 AM
2023 Feb 08 5:18 PM