Complete user data

[Former Member]

Hi,

I need user master table, up on searching I found that usr02 is the check table for users, but the user I am searching is not there in that table, it might have been deleted, please let me know if I am going wrong and also let me know if we delete the users, in which table will that be stored.

Thanks.

[JozsefSzikszai]

Your assumptions are right, usr02 is the table you need, however the users can be deleted from this table. You can check tables CDHDR and CDPOS for deletions.

[Former Member]

Thanks for the reply, but the deleted user are not being stored in the above table, can I know from where(tcode) the users will be deleted, I have looked in su01 but we do not have delete option in that tcode.

Thanks.

[JozsefSzikszai]

Dzed Maroz: thanks for the tcode!

OK, I checked user changes are in table USH04. The ones which you can find in USH04, but not in USR02 are the deleted ones.

[Former Member]

Thanks again for the replies, but still I am unable to find the deleted user in this list.

[Former Member]

Hello

USH04-PROFS - first symbol will be 'D' for deleted user.

[Former Member]

But when I give the user name it says that no entries found.

[Former Member]

Hello

If user is not exist in table USH04 then such user never existed in this system.

[Former Member]

Hello

Tbales CDHDR and CDPOS.

For search deleted user you may use t-code SUIM.