Suppose you are in middle of testing and found that certain field in a table is wrongly set. The table does not have any table maintenance (SM30), then how do change the data in the SAP table without writing any code?
Just use the debugger to edit the SAP table entries.
Note : In order to use the debugger, you must have the required authorization to use the debugger.
To edit the SAP table entries, first go to Data Browser (SE16). In this example, we shall change the value of a field (DEPT_ID) in a custom table (ZEMPLOYEE).
Enter the Table Name as ZEMPLOYEE and press enter. In the next screen (data browser’s selection screen) just press execute to display all the table entries or you can enter proper inputs to restrict the table entries.
Now select the entry you want to edit and press display.
Enter /H in the command field and press enter to switch on the debugger. After you press enter you will see a message “Debugging switched on” in the status bar. Again press enter to enter the debugger.
By default the variable CODE contains the value “SHOW”. Change the value of CODE to “EDIT” and press the pencil as shown above to change the value of CODE to enter the edit mode. Press F8.
After changing the value of CODE, table entry will be displayed in edit mode. Now you can change the value of the desired field (change the value of DEPT ID in this case) and press SAVE.
You will get the proper message in the status bar. Now go back and check the table entry.
Below table summarizes the possible code variable values.
| Function Code | Description |
|---|---|
| SHOW | Display |
| EDIT | Change |
| INSR | Insert |
| DELE | Delete |
| ANVO | Edit with key values |
&SAP_EDIT command in SE16N is an alternative method to edit the SAP table entries. Both the methods can be disabled by applying proper SAP OSS notes.