SAP StackFICOHRMMSDPMPSABAPNetWeaverTablesTcodes ☰MENU

ABAP DELETE table statements

Here you can see the usage of DELETE statements for deleting lines from database tables, cluster tables, index tables and internal tables.

Delete lines from the database tables

Syntax

Here all the lines matching the condition (<cond>) in the database table (<dbtab>) will be deleted.

Here the line in the database table that matching the primary key with specified work area (<wa>) will be deleted.

Here all the lines in the database table that matching the primary keys in the specified internal table will be deleted.

Delete from the Cluster database tables

Syntax

Here the cluster area (<ar>) with the specified name (<key>) will be deleted from the Cluster database table (<dbtab>).

Here it deletes the data cluster for the area <ar> with the specified name <key> stored in the cross-transaction application buffer for the table <dbtab>.

Delete lines from the internal table.

Syntax

Here the line in the internal table that matching the primary key with the specified work area will be deleted.

Here the lines in the table with the specified table keys will be deleted.

Here the lines in the table that matching the specified conditions will be deleted.

Deletes adjacent duplicate entries, either by comparing the key fields or the comparison fields specified explicitly in the COMPARING addition.

Delete lines from an Index table

Here the line with the specified index will be deleted. We can use the same statement without INDEX addition within a loop. That time it will delete the current line.

This statement is used to specify for deleting the lines between the index <n1> and <n2> and matching the condition <cond>

Also Read : View Other ABAP Keywords & Syntax -> ABAP Transaction codes

SAP ALECRMSCMSRMSAP Solutions SAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com