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:
In command prompt enter “&sap_edit” and hit enter. This will switch you to editing mode.
You will see message “SAP editing function is activated”. Now click on execute or press F8 to continue to editing screen.
Now the SE16N browsing screen is loaded but in edit mode. Do changes to entries you wanted and click on save to confirm them.
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:
In next screen enter any criteria to display entries you want to edit. Example of editing user DDIC master data:
Now select rows which you want to edit and press display button.
Type “/h” in command prompt and hit enter. This will switch you to debugging mode. Then hit enter once again to display debugging screen.
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.
Now change the value from “SHOW” to “EDIT” and hit enter.
Next click on continue button or hit F8 to continue in code execution.
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.
You’re done now. Click on back button or hit F3 to go back to tableview.