In SAP, sometimes all the contents of a table need to be deleted. This can be accomplished by writing a program and running it on the system where the table needs to be deleted. Alternatively, it can be done by editing through the SE16N transaction code. However, this method can be very long and tedious for tables with more than 100 rows.
Instead, all the table contents can be deleted by following the steps below using the SE14 transaction code.
The SE14 transaction code is entered. The table name is entered into the Object field. The ‘Tables‘ option is selected from the Dictionary Object radio buttons. The Edit button is pressed to proceed to the screen where the operation will be performed.
It is checked whether the correct table name has been selected on the opened screen, as this operation cannot be undone.
The selections on the opened screen should be as follows:
- Execute database operation: Select the Delete data radio button.
- Processing type: Direct (If the table content is very large, for example, around 100 million, you can select the Background option. This way, you won’t have to wait for a long time on the screen.)
After these options are selected, the ‘Activate and adjust database‘ button is pressed.
In the opened popup screen, click the ‘Yes’ button.
Table row count before operation
Table row count after operation
