Change the data without table maintenance in non-production system
Try this at your own risk!!!
The idea of this blog is to share the solution to a common problem faced by many functional consultants while testing. While we need to change the data of a table which does not have a SM30 maintenance view. We can change the data in almost any table either a custom table or a standard table depending upon the admin settings, we just need some basic ABAP knowledge to do this.
- SAP has provided a standard function module SE16N_INTERFACE, we can call this FM to edit any table. This FM calls the SE16N transaction in the edit mode.
- Execute this FM in SE37 and input the table name and set ‘I_EDIT’ and ‘I_SAPEDIT’ fields as ‘X’ and execute.
- Click on the insert/Delete icon to add to delete any row. We can also modify the existing data.
- While modifying the data, we can restrict the number of entries, restrict the data on the selection criteria and can display the desired fields instead of the displaying the whole table.
We must make sure the data whether the data is correct or not while dealing with standard SAP tables, as it may lead to inconsistency in the system.
This FM will work in most of the non-production systems but depending upon the system settings it might not work in few systems.