09-24-2008 2:59 PM
Hi all
i want DB tables which stores user information like name, telephone no etc.
specifically i want table which stores users email id.
user means which we create in SU01.
09-24-2008 3:45 PM
Hi Vishal,
Get Person number and address number from USR21 with BNAME from USR03 and then with address number obtained fetch email address from ADR6.
Srikanth.
09-24-2008 3:01 PM
09-24-2008 3:06 PM
check:
As others has said check USR* tables.
USR02 : Logon Data
USR03 : User address data
and check ADR6 for email id
With luck,
Pritam.
09-24-2008 3:45 PM
Hi Vishal,
Get Person number and address number from USR21 with BNAME from USR03 and then with address number obtained fetch email address from ADR6.
Srikanth.
09-24-2008 4:22 PM
Hi,
Some User tables are there in SAP. USR01, USR02, etc.
Check out with that.
Thanks
Swati.
09-24-2008 6:07 PM
Hi Vishal,
Check out the tables in SE11 by giving US* where you have to remember maximum details regarding users will be stored in the tables starting with U.
Cheers!!
09-25-2008 6:27 AM
09-25-2008 8:36 AM
Hi Vishal,
Yo can try the following tables:
1. USER_ADDR = USER_ADDR = USR21 =-> to get the user info (name and address)
You can mapped data via fields BNAME (User ID)
2. ADR2-ADDRNUMBER = USR21-ADDRNUMBER
ADR2-PERSNUMBER = USR21-PERSNUMBER -> to get User Telephone Number