topic Re: Tables where the user information is stored. in Application Development and Automation Discussions

Tables where the user information is stored.

Former Member — Wed, 22 Apr 2009 06:20:06 GMT

Hi all,

Please help me in knowing the tables where the user information is stored? Like user ID, Valid through date etc.

Thanks in advance.

Thanks and Regards,

Nandini.

Re: Tables where the user information is stored.

JPReyes — Wed, 22 Apr 2009 06:26:35 GMT

USR02 and USR03 as far as i remember

Regards

Juan

Re: Tables where the user information is stored.

Former Member — Wed, 22 Apr 2009 06:38:22 GMT

Go to T-Code se16 or se17

Enter usr*

Press f4 key

You will get the list of tables and description

Select the table as per your requirement

Re: Tables where the user information is stored.

jurjen_heeck — Wed, 22 Apr 2009 06:39:11 GMT

Depending on your version and the information required you may want to investigate the ADR* tables as well. If you search the forum for USR21 you'll get relevant info on that topic.

Re: Tables where the user information is stored.

Former Member — Fri, 22 May 2009 11:42:43 GMT

Hi Nandini

If you specify exactly what you are looking for then we can help. As you have seen from the other replies there are a quite a few different sources of the information.

You can have a go yourself by getting the technical field name from the fields in SU01 (F1 -> Technical information) and entering it into a table search based on field (SE84->ABAP Dictionary->Fields->Table Fields). There are a few gotcha's but it's a good technique to learn about places that this data is stored and how it can be used.

Re: Tables where the user information is stored.

former_member182098 — Fri, 22 May 2009 11:46:36 GMT

Hello,

All the user tables are stored in USR*

Go to SE16

Enter USR*

Press F4

You will find all user related tables.

Hope this is informative.

Regards,

Ravi

Re: Tables where the user information is stored.

Former Member — Sat, 23 May 2009 08:39:53 GMT

Why do you need the tables when you from previous post already know the transactions / screens / reports for the data?

Are you wanting to update the tables directly?

These "What is the table for XYZ?" are always suspect to me, and very error prone in reality. For example, table USR03 is obsolete - so you will be downloading / updating Nirvana...

Cheers,

Julius