Sometimes we are forced to change some database entries. There are many reasons like a new s-note from SAP or incorrect values in the technical table. Every SAP table can be changed via SE16 or SE11 transaction - all you need to have is a debug with change role assigned to your user. In this article you can find youtube video, and bellow is detailed step by step instruction.
Step by step instruction how to change entry in SE161. We have to login into the system and go to the SE16 or SE11 transaction. Put the table name, and display the required result. When you see the record which you want to edit, please select it and put **/hs** in the transaction textbox.
- Click on the Display icon in the upper panel. Normally you should see a detailed view, but now the debugger will run instead. This step will not work if you do not have the debug authorization.
In the debugger window, please click on Breakpoints-> Breakpoint at-> Breakpoint at Subroutine. New window should open.
Click on the FORM tab, and put SAPLSETB in the program and SET_STATUS_VAL in Fmla. No please press F8 - program should stop on refresh_exclude_tab.
- Please double click on the code variable, it should appear in the right bottom corner. Now you have to click on the edit icon and change the variable value from SHOW to EDIT. Please press F8 to continue executing.
- You should be able to change the values of your entry without any restriction. Please be informed that in the EDIT case you can’t add entires. To insert new line into the table, please use ANVO.
Before you save the entry, please double check the consequences. Editing the tables directly on production is not the best idea.