Table USR01 and USR02

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

USR01 contains the runtime data of the user master records

USR02 is the table containing logon information such as the password

Thanks

Seshu

[Former Member]

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...

[Former Member]

Hi

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

Regards.

[Former Member]

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

[Former Member]

Logically it should have same number of records...

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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...

[Former Member]

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

Why it was created?

[Former Member]

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