Maintain table entries

Please do not make any direct changes to tables unless you know what you are doing. Tables in SAP are connected to each other and if you don’t know what you are doing you might bring inconsistency in your tables which might cause lot of problems to SAP!!!

Through transaction SM30

This is the official supported way to modify SAP tables. It is only enabled for those customizing tables that are supposed to be modified directly.

Through transaction SE16N

Please note that this option might be deactivated by system administrator. More information can be found in SAP note 1420281 – SE16N: Deactivating &SAP_EDIT. However it is still possible to overcome this setting in debugging session.

Go to transaction SE16N. Enter table in which you want to change entry and hit enter. Example of table USR02 editing:

wiki sap maintain table entries

In command prompt enter “&sap_edit” and hit enter. This will switch you to editing mode.

wiki sap maintain table entries

You will see message “SAP editing function is activated”. Now click on execute or press F8 to continue to editing screen.

wiki sap maintain table entries

Now the SE16N browsing screen is loaded but in edit mode. Do changes to entries you wanted and click on save to confirm them.

wiki sap maintain table entries

You’re done now. Click on back button or hit F3 to go back.

Through transaction SE16

Go to transaction SE16. Enter table in which you want to change entry and hit enter (or F7). Example of table USR02 editing:

wiki sap maintain table entries

In next screen enter any criteria to display entries you want to edit. Example of editing user DDIC master data:

wiki sap maintain table entries

Now select rows which you want to edit and press display button.

wiki sap maintain table entries

Type “/h” in command prompt and hit enter. This will switch you to debugging mode. Then hit enter once again to display debugging screen.

wiki sap maintain table entries

Inside debugging screen in variables window enter “CODE” variable and hit enter. After that you should see current value of CODE variable and a pencil icon. Doubleclick on that pencil icon to change value of variable.

wiki sap maintain table entries

Now change the value from “SHOW” to “EDIT” and hit enter.

wiki sap maintain table entries

Next click on continue button or hit F8 to continue in code execution.

wiki sap maintain table entries

You will be switched back to SE16 screen but now you will be in edit mode. Do changes to entries you wanted and click on save to confirm them.

wiki sap maintain table entries

You’re done now. Click on back button or hit F3 to go back to tableview.

Leave a Reply