Saturday, September 17, 2011

Insert / Edit / Delete Database Table Entries

Insert/Edit/Delete database table entries even when Table Maintenance is not allowed through SE16 and SM30 and Table Maintenance generator is not available.

To Edit a database table entry, simply go to SE11 and display the entry which you need to edit.
Then double click the entry or select the entry and press 'Details' button in application tool bar.

Now go to command prompt, type '/h' and press Enter to activate debugger. Once the debugger is activated, double click on variable 'CODE' as shown in following screenshot. It will contain value as 'SHOW', change it to: EDIT or INSR (insert) or DELE (delete) as per the need and execute (F8).

You can perform the intended action now!

Table maintenance Attribute: 

Display/Maintenance Allowed with Restrictions: Maintenance is not possible through SE16/SE11. 
Table  Maintenance generator is created then you maintain table entries through SM30 otherwise not possible.

Display/Maintenance Allowed: Table can be maintained through SE11/SE16/SM30

Display Maintenance not allowed: Table maintenance not possible through SE11/SE16/SM30

No comments:

Post a Comment