Skip to main content

Delete table data

With this function you can delete table data quickly. The records of a table to be deleted can be selected via a "where condition".

For example this could be useful when you have to delete records in tables where neither a possibility via table maintenance nor an update via transport request is given (think of tables like MARA, ANLA etc.).

The small "i" button right from the input field for the table offers a list of the table fields. A doubleclick on a line transfers the field name and a value pattern to the "where condition" in the dialog form.

You can also enter the field names manually. The specified field names are checked against the SAP data dictionary.

For offering as much flexibility as possible the input in the "where condition" is not syntactically checked.

Please enter the table and especially the "where condition" carefully - otherwise it could be that more data will be deleted than intended! In that case it could be that the SAP application will not work properly anymore.

The "where condition" is optional. In case you leave it empty the deletion will be done for every record of the specified client in the table.

In the "Preview" text area you can see the update statement that is built from your input. Have a look at it and check if it would do what you intended. Some basic knowledge about SQL and it's implementation in the ABAP programming language is strongly recommended!

If the table is not client-dependent, the "client specified" clause of the update statement must be avoided. For this enter the same client as used in the connection.

It is also strongly recommended that you do a test in a test / quality system to ensure that the deletion works in the way you want to! This function is highly critical from security and data consistency point of view. Handle it with care and know exactly what you do, please! If the need for deleting / cleansing table data is more complex, you better should create a specific update program and use the function "Insert / modify a program".

If you do not set a flag in the "With SAPGUI" field, also system users (type 'B' or 'C') can be used. In case you set the flag "With SAPGUI" a dialog session will be started and after the execution you will see a short log with information about the number of updated records.

This function is also in the command line tool available.

####