DB table for user data

[Former Member]

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.

[Former Member]

You may search for USR* tables.

[Former Member]

check:

As others has said check USR* tables.

USR02 : Logon Data

USR03 : User address data

and check ADR6 for email id

With luck,

Pritam.

[Former Member]

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.

[Former Member]

Hi,

Some User tables are there in SAP. USR01, USR02, etc.

Check out with that.

Thanks

Swati.

[Former Member]

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!!

[Former Member]

hi,

Type USR* in SE11 and your query will be solved.

Regards,

preet

[Former Member]

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