Any Way to know which date a user is deleted from System ?

[Former Member]

Hi Everyone.

I just want to know is there any method or procedure from which we can see that on which date a user(s) is deleted from the system ? I mean very specific in way that on which date not the last logon date or time.

Just want to know is there a way to see that on which  date a user is deleted from the system ?

thanks in advance

[venkat_aileni]

Hi-

Table USh04 field: PROFS = 'D' gives you the deleted profiles.

Pass those values to USH02 table to retrieve more details.

Check below link for more details:

http://scn.sap.com/thread/779804

Thanks,

Venkat

[Former Member]

Hi Venkat

Thanks for the reply

CAn you ellaborate more in a simple manner? As i'm not a SAP guy.

like the full procedure

[venkat_aileni]

Sure!

Lets assume If you are having a User-Id say 'XYZ' and was deleted 2 months back. Now you want to find these user deletion details(Date).

Goto table USH04 and pass this User-Id, if you check the last record you will be getting value 'D' for field PROFS. This clearly confirms that this user-id was deleted.

Now to fetch when this User-Id got deleted just pass this user-id to USH02 table field name 'BNAME', along with this pass 'KRNL' value for field TCODE and value 'SAPMSYST' for the field REPID. From the retrieved records select the most recent one and that is the date when this user-id has got deleted in system.

Hope this clarifies...

-Venkat