topic Re: DB table for user data in Application Development and Automation Discussions

DB table for user data

Former Member — Wed, 24 Sep 2008 13:59:26 GMT

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.

Re: DB table for user data

Former Member — Wed, 24 Sep 2008 14:01:28 GMT

You may search for USR* tables.

Re: DB table for user data

Former Member — Wed, 24 Sep 2008 14:06:40 GMT

check:

As others has said check USR* tables.

USR02 : Logon Data

USR03 : User address data

and check ADR6 for email id

With luck,

Pritam.

Re: DB table for user data

Former Member — Wed, 24 Sep 2008 14:45:52 GMT

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.

Re: DB table for user data

Former Member — Wed, 24 Sep 2008 15:22:29 GMT

Hi,

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

Check out with that.

Thanks

Swati.

Re: DB table for user data

Former Member — Wed, 24 Sep 2008 17:07:16 GMT

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

Re: DB table for user data

Former Member — Thu, 25 Sep 2008 05:27:14 GMT

hi,

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

Regards,

preet

Re: DB table for user data

Former Member — Thu, 25 Sep 2008 07:36:06 GMT

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