Delete All Data from SAP Database Table
ABAP developers can delete all data from SAP database table using one of two methods.
First method is to create an ABAP program which runs DELETE ABAP command to remove all data from database table.
And the second method is to use SAP transaction SE14 ABAP Dictionary Database Utility to delete data from ABAP table.
As summarized in introduction of this ABAP tutorial, SAP developers or SAP professionals can choose one of two methods to delete data from database table.
To run ABAP program which includes the ABAP statement DELETE or to call SAP transaction SE14 Database Utility.
Execute DELETE Command to Remove Data from ABAP Table
Create a custom ABAP report and execute following ABAP program code.
"DELETE FROM [tablename]" ABAP code deletes all rows from database table.
delete from /BSHS/TR_PFORM_H.
I want to truncate table data for the following ABAP table
After I execute "Delete From" command, as seen in below screenshot all data is deleted.
SAP Transaction SE14 to Delete Data from Database Table
Use SAP transaction code SE14 "ABAP Dictionary: Database Utility" SAP screen.
Here is my demo table which I want to delete all entries in it.
Type the ABAP database table name and press Enter
Be sure that you select option "Delete data"
Then press "Activate and adjust database" button.
A confirmation request will be displayed to delete table data and truncate all data in the database table. Approve the deletion by pressing Yes
When I check the number of records in the database table using SE11, the query returns 0 entries.