ABAP Keyword Documentation →  ABAP - Quick Reference 

DELETE dbtab - Quick reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

DELETE { { FROM dbtab|view|(target_syntax) 

           [USING CLIENT clnt] | [CLIENT SPECIFIED] 

           [CONNECTION con|(con_syntax)] 

           [WHERE
sql_cond] [ORDER BY ... [OFFSET o]] [UP TO n ROWS] } 

       | { dbtab|view|(target_syntax) [CLIENT SPECIFIED] 

                 
                 
  [CONNECTION con|(con_syntax)] } 

           FROM wa|{TABLE itab} }. 

Effect

ABAP SQL statement. Deletes rows from a database table or a classic view.

Additions

• FROM dbtab|view|(target_syntax)
  Specifies the database table and/or view statically or dynamically.
• USING CLIENT
  Switches implicit client handling to the client specified in clnt.
• CLIENT SPECIFIED
  Switches implicit client handling to the client specified in the data source.
• CONNECTION con|(con_syntax)
  Makes the change on a secondary connection.
• WHERE sql_cond
  Uses a sql_cond condition to specify the rows that are to be deleted.
• [ORDER BY ... [OFFSET o]] [UP TO n ROWS]
  Specifies an offset and the maximum number of rows to delete. ORDER BY can be used (or must be used) to define an order.
• FROM { wa|{TABLE itab} }
  Specifies the rows that are to be deleted by matching them with the key values of a work area wa or the rows of an internal table itab.