UST04 inconsistency

[Former Member]

Hello Experts,

We are coming across a very abnormal behaviour of the table UST04. In our existing system we are getting a one single entry which shows a profile but the user column is BLANK.

Ideally UST04 gives us the entries of the profiles assigned to the users. But in our case the user column is blank and we get that profile.

That profile is not assigned to any role. We tried deleting the profile from SU02 but we get a message saying profile has been assigned to a user and hence cannot be deleted. We tried deleting the user assignment from SU25 and were also able to delete the assignment but the still the table UST04 continues to show that row which comprises of the profile and blank user column.

Can you please help...

In anticipation of your reply. Thanks in advance.

Best Regds,

Suyog Chakot.....

[Former Member]

Hi

Does the field have no characters at all? If you download that entry into excel or a text file, are there any spaces there?

I've often seen issues in older systems where user names have been prefixed or suffixed with a space so they are not what they appear.

[Former Member]

Please check in table USR_FLAGS whether the field FLAG has the value SYNC in it?

If so, then start transaction SUIM_OLD once.

If not, then check in USR04 that there isn't anything obviously wrong in the PROFS field and run report RSAUTHXPRA.

The problem should hopefully be gone.

If not, then we need to find out why...... (i.e. where it came from!)

Cheers,

Julius

[Former Member]

Hi Ramesh/Suyog,

Just to add to the checks posted by Julius. Can you also execute FM: SUSR_SYNC_USER_TABLES as this issue might be because of the inconsistency in UST04.

Do let us know the end results.

[Former Member]

Sorry just checked Julius already mentioned SUIM_OLD which directly call the function SUSR_SYNC_USER_TABLES = X.

[Bernhard_SAP]

Hi,

please have a look at SAP note #1401395. Propably it will solve the issue with the scrap entry....

b.rgds,

Bernhard