Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
ameya_beri
Active Contributor
31,424
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



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


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"



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




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



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



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 🙂


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.

 
9 Comments
Labels in this area