Personal Insights
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 :
2. Type /h and hit ‘Enter’
1. 3. Make sure the debugging mode is switched on:
4.
4. Hit ‘Enter’ again
5. Get the next debug screen. Double click on word code and get the ‘Variables1’ tab populated:
6. Click on Pencil to get the Edit mode:
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):
8. Hit Enter and F8 :
9. And system will open the record. Fix it and hit Save :
10. The record after our edition:
11. If you mneed to delete the record please use the code DELE (I have taken another record for that) and hit F8:
12. system offers to delete record – confirm it:
and issues the following:
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
Thank you Mr. PPIO. Good Document.
Hi PPIO,
your doc is very nice
thanks putting these doc
Naren
Thank you Mr. PIPO.. Very informative..
Regards
Krishna..
Very interesting thing. Tnx you!
very good information
Really something new for learn
your doc is simple nice & under standing so thank your very much for this document
Really good dude
Very Good Information!!
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.
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
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.
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
tumultuous applause
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.
mate, do not play with data in PRD you will damage your system
Mate, that is just your opinion
I am happy that people can do things like this helping their users
Hi Jurgen,
Very important information provided. thank you.
Hi Pipo,
Very good. useful document. keep it up,
thanks,
srinu.
Hello PPIO,
Good and useful doc. keep it up.
Thanks & Regards,
Lakshmi S
Very Good Document
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.
Thanks Saher, I was specifically looking for this information.
Best regards,
Vijay
and everything can be traced: Have fun with system log - your debugging activity is being recorded by System
A very useful guide!
Thank you!
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
Nice documents.
Also change the code value as 'INSR' for insert.
Hi, Very helpful link, Thank you.