SAP BLOG ABAP Tricks for Functionals | Trick #1 – Edit Table Values in S/4 HANA using SE16 Debug Edit

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,367
Tepki puanı
7
Puanları
6
Introduction –

We come across situations where we need to edit values in standard/custom tables. There could be many reasons why you want to edit values in standard/custom tables, some reasons are listed below.

  1. You are performing testing, and want to simulate a test scenario without changing a lot of test data
  2. You do not have a table maintenance transaction available to edit table value
  3. You have found a data inconsistency and want to change table value to fix it

This blog post explains how to step by step edit a non primary field value in SAP standard or custom table.

Note this process should be used with extreme caution in your productive and non-productive environments. Changing table values directly can cause unwanted consequences. You should only use this approach, when you are fully aware of what you change, will not cause any harm to the standard SAP system.



Prerequisites-

  • For debug edit to work you need to have access to transaction SE16
  • You need to have access to debug edit – Authorization Object – S_DEVELOP with object type DEBUG and activity 02

Solution –

Step 1-
Identify the table and field you want to edit (For this example, I will edit the material text in table MAKT) and open the table using transaction SE16

Step1-1.png
Step2-1.png


Step3.png


Step 2 – Select the row you want to edit, and double click on it

Step4.png


Step 3 – Enter /h in the SAP command field, and turn on the debugger, if everything is fine, you will see a message saying “Debugging switched on”

Step5.png


Step6.png


Step 4 – Press F7 till you reach program include LSETBF01 and routine – set_status_val, click on line 34 variable code, and change it from SHOW to EDIT

Step7.png


Step8.png


Step9.png


Step 5 – Edit the data and save it (Note you can only edit non primary fields using this approach)

Step10.png


Step11.png


Step 6 – The data edit is complete, now you can view the edited data, to confirm it actually was saved in the system

Step13.png


Step14.png


Conclusion –

  • This process will work for both ECC and SAP S/4 HANA systems
  • The process will work for editing values in standard and custom tables in the system
  • The process should be used with extreme caution, changing standard tables directly in productive system is not advised
  • In a future blog post, I will share how to use other functions, and edit primary key fields (Note this is my first blog post
    1f642.png

Please feel free to share your feedback and questions. Based on your feedback, I will write the upcoming blog posts in this series. Thank you for reading.

Okumaya devam et...
 
Üst