SAP being 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 a 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. Ofcourse 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 tracks 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 of 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..
In 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 of the debugging and execute and viola! you got all the fields editable.. just change it to what ever you need and press ‘SAVE’.
See the new contents.
Copyright SAP DB : Visit us for More SAP Tips