Delete table entries using ABAP debugger

Requirement:

You have received approval to delete an entry from a table. How do you do this?

 

Important Note: Use this option with extreme caution as you will be making changes to a table and if you do not understand what you are doing please don’t do it! SAP highly recommends not to use this option but however lets you use it in special circumstances, so be careful!

 

 

Procedure:

Using debug mode you can easily delete a table entry. In our example we will use table USR02 (user table) and delete a user ID (eg: TEST1_RAJ).

1) Go to T-Code SE16

2) Enter the table name (In our example it is "USR02")

3) Click on "Table Contents" icon

4) Enter the search parameter or leave it blank (In our example we will look for user "TEST1_RAJ")

5) Click "Execute" button

6) Once you find the data you are looking for double click on it

 

 

7) From the data display screen type /h and hit enter "TWICE" to start the debugger

8) In the debug screen double click on the word "CODE"

     - In the variables tab you will see this variable along with it's value which will be "SHOW" by default

9) Click on the pencil icon to change the value

10) Change it to "DELE" and hit ENTER and finally F8

11) You will come back to the data display screen where you will now find the "DELETE ENTRY" button, click on this to delete this record for the table

12) You will get a confirmation that the record is deleted