SAP is a very robust system has some flaws.. maybe they kept it intentionally so that we can play with it. Anyways, As far as I know there are two ways in which the table data can be changed directly incase if you do not have an SM30 view or there is no interface written to handle the database tables.
Method 1 – Using &SAP_EDIT in SE16n
One easy way of handling it the use of ‘&SAP_EDIT ‘. Just go to SE16n and give the table name and in the command windows key in ‘&SAP_EDIT'(without quotes) and execute. You will have all the values editable. Of course not the primary keys…! If you want to change the primary keys.. then just delete it and create a new entry in SE16n. Any changes you make are saved in other tables, go to SE16 and type SE16N* and you will see the tables which track these changes.
the other way is below.. need a very little debugging experience.
Method 2: Little bit of Debugging experience for SAP ABAP
Here is a simple example which will allow you to modify any content of the table directly without the need for table maintenance just with a bit of debugging experience.
Go to Transaction: SE16
Give any material number.
Imp: Before going further, first goto Menu –> Settings –> user Parameters –> Data browser –> and tick on SE16 Standard list.
press ‘/H’ in the command window and double click on the line of the record, which you would like to modify.
After the double click.. you should get a screen like below.. just press F7 once.
Here, if you see the value of the CODE, the variable value is set to ‘SHOW’, change it to ‘EDIT’ and click on change.
Now switch off the debugging and execute and viola! you got all the fields editable.. just change it to whatever you need and press ‘SAVE’.
See the new contents.