Skip to Content
Personal Insights
Author's profile photo Oleg K

How to change/delete records in SAP using debug mode

Dear All,

Let me remind you how to do some “cleaning” stuff in ABAP tables.

Some of you would cry “Mate, it is not recommended by SAP!!! Never do it!!!!” 😡

And I would reply them – “Relax and do not worry. The doctor knows what to cut”)) 😛

Let’s play in QA system (learn and practice in QA, after that you would use PROD)

If you have an authorization for debugging please follow my steps below:

I am based on fact that you already know WHICH record to fix.

(The table below is taken as example)

1.    Run SE11 for your particular table and find out your particular record. I usually use the Table Contents – Display :

/wp-content/uploads/2012/05/1_99646.jpg

2.    Type /h  and hit ‘Enter’

/wp-content/uploads/2012/05/2_99653.jpg

1.     3.   Make sure the debugging mode is switched on:

  /wp-content/uploads/2012/05/3_99655.jpg

4.

4. Hit ‘Enter’ again

5. Get the next debug screen.   Double click on word code and get the ‘Variables1’ tab populated:

/wp-content/uploads/2012/05/4_99656.jpg

6. Click on Pencil to get the Edit mode:

/wp-content/uploads/2012/05/5_99657.jpg

7. Now type the ‘magic word’ what you need.

for edition it is EDIT

for deletion it is DELE

(some other parameters also exist)

we are currently doing EDIT (and going to change the record):

/wp-content/uploads/2012/05/6_99658.jpg

8. Hit Enter and F8 :

/wp-content/uploads/2012/05/7_99662.jpg

9. And system will open the record. Fix it and hit Save :

/wp-content/uploads/2012/05/8_99663.jpg

10. The record after our edition:

/wp-content/uploads/2012/05/9_99664.jpg

11. If you mneed to delete the record please use the code DELE (I have taken another record for that) and hit F8:

/wp-content/uploads/2012/05/10_99665.jpg

12. system offers to delete record – confirm it:

/wp-content/uploads/2012/05/11_99666.jpg

and issues the following:

/wp-content/uploads/2012/05/12_99667.jpg

Now refresh your table contents and make sure the changes/deletions have been done.

Nothing special, just some technical tricks. You can talk to abaper to clarify that.

Please remember.

The debug mode is your own risk. You can damage data or even lost it.

Good luck

Regards,

4.

4

Assigned Tags

      27 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jignesh Mehta
      Jignesh Mehta

      Thank you Mr. PPIO. Good Document.

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Hi PPIO,

       

      your doc is very nice

       

      thanks putting these doc

       

       

       

      Naren

      Author's profile photo Former Member
      Former Member

      Thank you Mr. PIPO.. Very informative..

       

      Regards

      Krishna..

      Author's profile photo Former Member
      Former Member

      Very interesting thing. Tnx you!

      Author's profile photo Former Member
      Former Member

      very good information

      Author's profile photo Former Member
      Former Member

      Really something new for learn

      your doc is simple nice & under standing so thank your very much for this document 

      Really good dude

      Author's profile photo Former Member
      Former Member

      Very Good Information!!

      Author's profile photo Former Member
      Former Member

      Hi PIPO,

      thanks for posting such a wonderful document .Can you define the process in brief how to change the entries through SE16 N.

      thanks.

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Dear,

       

      First of all , if you want to change the data in Table level ,you have to some authorizations for changing data in SE16 or SE16N .

       

      If you dont mind , please have a look into below document . I have created this document in one of the my earlier project .

       

      https://docs.google.com/viewer?a=v&pid=gmail&attid=0.2&thid=13cb9106c6af86c4&mt=application/vnd.openxmlformats-officedocument.wordprocessingml.document&url=https://mail.google.com/mail/u/0/?ui%3D2%26ik%3D3061daef2e%26view%3Datt%26th%3D13cb9106c6af86c4%26attid%3D0.2%26disp%3Dsafe%26realattid%3Df_hcx452iy1%26zw&sig=AHIEtbRFIuDd4bhuSwWpZ-lAP5SBA4iQWQ

       

       

      Thanks,

       

      Naren

      Author's profile photo Jürgen Lins
      Jürgen Lins

      Such kind of documents should be treated like cigarette boxes. At least 30% of the size should clearly indicate "....can cause serious damage to the health of your SAP system"

      I would estimate that 5% of the issues reported in some forums are caused by those doctors who get the information from such a document instead of having studied for some years like other doctors.

       

      And the auditors know about such activities as well, hence in the most big companies debugging in production systems is disabled,  and in case debugging is allowed then at least changing values is restricted.

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Jurgen ,

       

      You are really great .( I have spent some time with my auditor also ). In one  Asset Issue ,he should not agree with this type of activities to do in PRD . Finally , we management convinced to him to do this in PRD .He said only one thing as " this should not a way to write off your Issues in PRD " .

       

      Any way , I appreciate you Jurgen like above very Good Explanation .

       

      Thanks,

       

      Naren

      Author's profile photo Oleg K
      Oleg K
      Blog Post Author

      tumultuous applause

      Author's profile photo kesari sai krishna Sabniveesu
      kesari sai krishna Sabniveesu

      Hi Jurgen,

       

      Very good point. I am currently playing a SoX control owner for my client ERP system along with my SD consultant role. At any cost we don't allow consultants to do the debugging in PRD. If at all they have to do then system owner has to provide the approval with wet signature.

       

      Playing with data that to in PRD is absolutely violation of controls. We don't even provide access to PRD for ABAP team. For functional its just display of SE16 or SE16n.

       

      @Others: You may use the above information for your knowledge sake. You can't definitely try in PROD.

       

      Regards, Sai Krishna.

      Author's profile photo Oleg K
      Oleg K
      Blog Post Author

      mate, do not play with data in PRD you will damage your system

      Author's profile photo Oleg K
      Oleg K
      Blog Post Author

      Mate, that is just your opinion

       

      I am happy that people can do things like this helping their users

      Author's profile photo Srinu S
      Srinu S

      Hi Jurgen,

      Very important information provided. thank you.

      Author's profile photo Srinu S
      Srinu S

      Hi Pipo,

      Very good. useful document. keep it up,

       

      thanks,

      srinu.

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hello PPIO,

       

      Good and useful doc. keep it up.

       

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Very Good Document

      Author's profile photo SAQ MD
      SAQ MD

      Dear PPIO,

       

      By above method you can also edit the primary keys in the table. for which use the code if code = "ANVO"  so that primary keys will also be in edit mode and you can very well change the partner etc.

       

      Even With ANVO you can retrieve the deleted data...Its really awesum.

       

      Regards,

      Saher Mohammed.

      Author's profile photo Vijay S Krishnan
      Vijay S Krishnan

      Thanks Saher, I was specifically looking for this information.

       

      Best regards,

      Vijay

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Author's profile photo Former Member
      Former Member

      A very useful guide!

      Thank you!

      Author's profile photo Parag Pandya
      Parag Pandya

      Hello Dear,

       

      I must say that this is a very good initiative taken by you to provide such a dangerous information and how to process it.....

      Well I already knew about it and that is different story.....but other my not..!

       

      But i have one very crucial question regarding the deleting something from tables.....!

       

      IS IT LEGAL.....?

       

      What i feel is that it is not legal and not recommended to any one, just like pros and cons discuses by other users here..

       

      So my question is open for all.

       

      Regards

      Parag Pandya

      Author's profile photo Venugopala Sali
      Venugopala Sali

      Nice documents.

      Author's profile photo Yahya Kamran
      Yahya Kamran

      Also change the code value as 'INSR' for insert.

      Author's profile photo Sreenivasarao Saliganti
      Sreenivasarao Saliganti

      Hi, Very helpful link, Thank you.