Skip to Content
avatar image
Former Member

who deleted from a table

hi

How do I tell which user deleted data from a table ?

Andale

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 06, 2009 at 10:53 AM

    Hai,

    Users who have access write ABAP programs, has full access to the database and thus can delete all the data.

    Additionally users with permission can use SE14 to delete table contents completely.

    You can use STAD and ST03 to analyse what are all the tcodes executed in a particular period of time and by which user. Also you can use table logging on tables to log the activities on the table.

    http://help.sap.com/saphelp_nw04/Helpdata/EN/7e/c81ebb52c511d182c50000e829fbfe/frameset.htm

    Regards,

    Yoganand.V

    Edited by: Yoganand Vedagiri on Feb 6, 2009 11:54 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2009 at 11:55 AM

    Hi,

    Here is the solution for you.

    In order to findout who deleted records or made changes you need to have logging enabled on that particular table. If it is enabled then you can use report RSTBHIST to find out the changes. Also, you cna use this report to find out currently logged tables.

    Hope this helps.

    Manoj Chintawar

    Add comment
    10|10000 characters needed characters exceeded