Skip to Content

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

To report this post you need to login first.

24 Comments

You must be Logged on to comment or reply to a post.

    1. 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

      (0) 
  1. Jürgen L

    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.

    (0) 
    1. 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

      (0) 
    2. 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.

      (0) 
    3. SP RO Post author

      Mate, that is just your opinion

       

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

      (0) 
  2. 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.

    (1) 
  3. 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

    (0) 

Leave a Reply