topic Re: User Profile table Name in Application Development and Automation Discussions

User Profile table Name

Former Member — Fri, 27 Jul 2007 12:20:28 GMT

Hi all

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

Re: User Profile table Name

Former Member — Fri, 27 Jul 2007 12:22:37 GMT

hI,

Try to see <b>UST10S</b>

Regards

Re: User Profile table Name

Former Member — Fri, 27 Jul 2007 12:22:40 GMT

USR01

USR02

Regards

Ravish Garg

<b>*reward if useful</b>

Re: User Profile table Name

Former Member — Fri, 27 Jul 2007 12:23:47 GMT

Hi,

try FM: BAPI_USER_GET_DETAIL.

Regards, Dieter

Re: User Profile table Name

Former Member — Fri, 27 Jul 2007 12:23:56 GMT

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

Reward all helpfull answers

Regards

Pavan

Re: User Profile table Name

Former Member — Fri, 27 Jul 2007 12:33:23 GMT

t_code su01

values store table.

USR01

USR02

Re: User Profile table Name

Former Member — Wed, 23 Jun 2010 09:03:39 GMT

Hi Muthu Kumar,

you can use TCODE -

> SUIM for User Information & their details.

Regards

Premnath.

Re: User Profile table Name

Former Member — Wed, 23 Jun 2010 09:10:55 GMT

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

Re: User Profile table Name

Former Member — Wed, 09 Nov 2011 10:03:23 GMT

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,

Re: User Profile table Name

Former Member — Wed, 02 Jan 2013 09:53:25 GMT

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

Re: User Profile table Name

Former Member — Wed, 02 Jan 2013 10:43:44 GMT

check this scn article

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

Regards

Gaurav Ahluwalia

Re: User Profile table Name

Former Member — Fri, 28 Aug 2015 04:53:22 GMT

This message was moderated.

Re: User Profile table Name

Former Member — Fri, 28 Aug 2015 05:36:33 GMT

This message was moderated.

Re: User Profile table Name

Former Member — Fri, 30 Oct 2020 07:31:54 GMT

this helped a lot! thanks