topic Re: Table USR01 and USR02 in Application Development and Automation Discussions

Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 02:53:32 GMT

Can someone advise what is the difference between table USR01 and USR02 and is it possible for the 2 tables to have different number of records.

Thank you.

Re: Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 02:57:24 GMT

Hi,

These two tables will contain different data. USR02 contains the master data of the user and USR01 contains only the run time data.

Hope it is clear.

Reward points if useful.

Regards,

Atish

Re: Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 03:02:19 GMT

USR01 contains the runtime data of the user master records

USR02 is the table containing logon information such as the password

Thanks

Seshu

Re: Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 15:06:09 GMT

USR01 contains run time data for user master record

e.g

Spool device being used, language, date format, decimal notation ( period or comma ) etc.

USR02 contains Logon information

e.g user name, password in encrypted form, validity of user, last logon date and time, etc

Reward if useful...

Re: Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 16:16:09 GMT

Question is is it possible for the 2 tables to have different number of records?? This is what i am facing now.

Regards.

Re: Table USR01 and USR02

Former Member — Sun, 08 Jul 2007 16:22:17 GMT

Both tables having one primary key BNAME,but remaing fields are diffrent.

so 2 tables will have diffrent records as per data point of view.

Thanks

Seshu

Re: Table USR01 and USR02

Former Member — Mon, 09 Jul 2007 12:08:48 GMT

Logically it should have same number of records...

But I have also see different number of users in two tables.. 1 less in USR02.

Re: Table USR01 and USR02

Former Member — Mon, 09 Jul 2007 12:22:44 GMT

If you want number of users then go for USR02 as it will have all users. USR01 may contain less records depending on data.

Re: Table USR01 and USR02

Former Member — Mon, 09 Jul 2007 12:41:53 GMT

I found a BNAME = 'SAP*' in USR01 which is not in USR02.

Re: Table USR01 and USR02

Former Member — Mon, 09 Jul 2007 14:49:57 GMT

Hi Pradeep

I face exactly the same probelm as yours. Our table USR01 has one more user compared to USR02 and that one user ID is "MATZKE".

We intend to delete this ID - do you know if there is any implication?

Regards.

Re: Table USR01 and USR02

Former Member — Mon, 09 Jul 2007 15:12:53 GMT

I think...

using TCODE SU01, u can do that...

It has delete option... but I'm not sure whether it will work in ur case or not...

if works... then reward some more points...

Re: Table USR01 and USR02

Former Member — Wed, 28 Nov 2007 08:17:43 GMT

Is there any solution for this ?? Did you have deleted the MATZKE user??

Why it was created?

Re: Table USR01 and USR02

Former Member — Mon, 18 Feb 2013 00:52:04 GMT

Dear friends,

Recently i came across a strange issue with respect to table USR01.

The SU01 entries were not reflected in db table USR01(The runtime version)

Like decimal format,time etc.

Could any body let me know what is the way to make them sync with db level and sap level.

Regards

Omkar