topic Re: Complete user data in Application Development and Automation Discussions

Complete user data

Former Member — Tue, 09 Dec 2008 08:09:22 GMT

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.

Re: Complete user data

JozsefSzikszai — Tue, 09 Dec 2008 08:19:23 GMT

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.

Re: Complete user data

Former Member — Tue, 09 Dec 2008 08:24:17 GMT

Hello

Tbales CDHDR and CDPOS.

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

Re: Complete user data

Former Member — Tue, 09 Dec 2008 08:25:04 GMT

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.

Re: Complete user data

JozsefSzikszai — Tue, 09 Dec 2008 08:33:20 GMT

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.

Re: Complete user data

Former Member — Tue, 09 Dec 2008 08:38:32 GMT

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

Re: Complete user data

Former Member — Tue, 09 Dec 2008 08:53:10 GMT

Hello

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

Re: Complete user data

Former Member — Tue, 09 Dec 2008 09:07:14 GMT

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

Re: Complete user data

Former Member — Tue, 09 Dec 2008 09:27:20 GMT

Hello

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