Application Development 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: 

User Profile table Name

Former Member
0 Kudos

Hi all

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

1 ACCEPTED SOLUTION

Former Member

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

Former Member
0 Kudos

hI,

Try to see <b>UST10S</b>

Regards

Former Member
0 Kudos

HI

USR01

USR02

Regards

Ravish Garg

<b>*reward if useful</b>

Former Member
0 Kudos

Hi,

try FM: BAPI_USER_GET_DETAIL.

Regards, Dieter

Former Member
0 Kudos

Hi

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

Reward all helpfull answers

Regards

Pavan

Former Member
0 Kudos

t_code su01

values store table.

USR01

USR02

Former Member
0 Kudos

Hi Muthu Kumar,

you can use TCODE -


> SUIM for User Information & their details.

Regards

Premnath.

Former Member
0 Kudos

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

Former Member

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,

0 Kudos

this helped a lot! thanks

Former Member
0 Kudos

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

Former Member
0 Kudos

check this scn article

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

Regards

Gaurav Ahluwalia

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

This message was moderated.