We are all aware of the conventional way of inserting, deleting
and modifying the table entries in SAP. The process followed to insert, delete
or modify the table records in production system is quite different from the
way we do it in KPI or development environment. In this blog we will see insertion,
deletion, or modification of single or multiple table entries in the production
systems.
Single Table Entry:
1.
Execute
the T-code: SE11 / SE12 / SE16.
2.
Enter
the table name in which you want to do modification and then display the
contents of the table.
3. Double
click on entry to which you want to do the modification. Now you will see the
below screen. Type ‘/h’ in the command field and press enter twice. When you press
enter first time you will see ‘Debugger switched on’ message in the status bar
and when you press enter second time you will enter into the debug mode.
4. In
the debugger double click on the variable ‘code’. By default it will have ‘SHOW’
value. If you want to edit the existing table value then change the variable ‘code’
value to ‘EDIT’ (Note: Case Sensitive)
by clicking the pencil button. Then keep on pressing F5 (Line by line
Execution) until the debugger enter the EDIT section and points to the line: set titilebar ‘TAB’ with name ‘andern’(101).
Now press F8.
5. Now
you will see the below screen where you can make the changes to the table
entry. After making the changes click on save. You will see a message
confirming the changes to the database table. Then click on back. The records
are updated.
Follow the same
procedure to insert or delete the table entries. You just have to change the
variable code value respectively.
Multiple Table Entry:
We will encounter the scenarios where we have to edit, insert
or delete multiple table entries at one instance. At that point following the
above single table entry procedure is a lengthy process and time consuming. Follow
the below steps for editing, inserting or deleting the multiple records from
the table at a single time.
1.
Execute
the T-code: SE16N
2.
Enter
the table name in which you want to do modification and then display the
contents of the table.
3.
Import
the multiple entries by clicking on arrow button against the field.
4.
Type
‘/h’ in the command field and press enter twice. When you press enter first
time you will see ‘Debugger switched on’ message in the status bar and when you
press enter second time you will enter into the debug mode.
5.
In
the debugger write two fields in the capital letters (Case Sensitive) GD-SAPEDIT and GD-EDIT and change their values to ‘X’ by clicking the pencil button.
6.
Now
press F8 you will see the below screen.
7. Again
press F8. It will display the below screen where you can edit, add or remove
the multiple entries from the table. Save the values and click on back. Records
are updated to the database table.
