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.
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-
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 –
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...
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.
- You are performing testing, and want to simulate a test scenario without changing a lot of test data
- You do not have a table maintenance transaction available to edit table value
- 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.
Okumaya devam et...