Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

User Profile table Name

Former Member
0 Likes
24,186

Hi all

I want to know user profile (SU01) table name. Any tables contains emaill id?

1 ACCEPTED SOLUTION
Read only

Former Member
7,354

Hi all,

You can refer to the table i.e. USER_ADDR.

The table contains the field bname, name_first, name_last, full name and other personal info setails.

You can fetch it from there,

13 REPLIES 13
Read only

Former Member
0 Likes
7,354

hI,

Try to see <b>UST10S</b>

Regards

Read only

Former Member
0 Likes
7,354

HI

USR01

USR02

Regards

Ravish Garg

<b>*reward if useful</b>

Read only

Former Member
0 Likes
7,354

Hi,

try FM: BAPI_USER_GET_DETAIL.

Regards, Dieter

Read only

Former Member
0 Likes
7,354

Hi

ADR6 SMTP Numbers (Business Address Services) - Contains Email – Id of the BP.

Reward all helpfull answers

Regards

Pavan

Read only

Former Member
0 Likes
7,354

t_code su01

values store table.

USR01

USR02

Read only

Former Member
0 Likes
7,354

Hi Muthu Kumar,

you can use TCODE -


> SUIM for User Information & their details.

Regards

Premnath.

Read only

Former Member
0 Likes
7,354

Hi

see these

USR01,USR02

or try doing

USR* f4 in se11 ,

you will get lot many , i have just first 2.

Hope it is helpful.

Regards,

Uma Dave

Read only

Former Member
7,355

Hi all,

You can refer to the table i.e. USER_ADDR.

The table contains the field bname, name_first, name_last, full name and other personal info setails.

You can fetch it from there,

Read only

0 Likes
7,354

this helped a lot! thanks

Read only

Former Member
0 Likes
7,354

Hi

you can get mailID details in ADR6 but you cant see user ID here.

If you want see user IDs along with Email IDs then you will have join two tables called USR21 and ADR6 by uisng SQVI tcode..

I hope this will help.

Regards

Ravi

Read only

Former Member
0 Likes
7,354

check this scn article

http://scn.sap.com/thread/1364993

Regards

Gaurav Ahluwalia

Read only

Former Member
0 Likes
7,354

This message was moderated.

Read only

Former Member
0 Likes
7,354

This message was moderated.