ABAP Keyword Documentation →  ABAP - Short Reference 

DELETE itab - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

DELETE { { {TABLE itab 
            {{FROM wa [USING KEY key_name|(name)]} 

            |{WITH TABLE KEY [key_name|(name) COMPONENTS] 

                             {comp_name1|(name1)} = dobj1 

                             {comp_name2|(name2)} = dobj2 

                             ... }}} 

         | {itab INDEX idx [USING KEY key_name|(name)]} 
         | {itab [USING KEY loop_key]} } 

       | {itab [USING KEY key_name|(name)] 
    
          [FROM idx1] [TO idx2] [WHERE log_exp]|(cond_syntax)} 

       | {ADJACENT DUPLICATES FROM itab 
           [USING KEY key_name|(name)] 

           [COMPARING comp1 comp2 ...|{ALL FIELDS}]} }. 

Effect

Deletes rows from an internal table itab.

Additions

• TABLE itab FROM wa
  Specifies a row to be deleted that matches the key values of a work area wa.
• TABLE itab WITH TABLE KEY {comp_name1|(name1)} = dobj1 {comp_name2|(name2)} = dobj2 ...
  Specifies a row to be deleted through the static or dynamic specification of components of the primary table key.
• itab INDEX idx
  Specifies a row to be deleted through the specification of the row number (idx) of a table index.
• itab [USING KEY loop_key]
  Determines the row to be deleted in a loop by the current line.
• itab [FROM idx1] [TO idx2] [WHERE log_exp]|(cond_syntax)]
  Specifies several rows to be deleted through the specification of a lower and upper row number (idx1 and idx2) in a table index. These can be restricted by the specification of a static condition log_exp or a dynamic condition in cond_syntax.
• ADJACENT DUPLICATES FROM itab [COMPARING comp1 comp2 ...|{ALL FIELDS}]
  Specifies adjacent identical rows, whereby you can specify relevant comparison components with COMPARING.
• KEY key_name|(name)
  Statically or dynamically specifies a (secondary) table key that is used to search for the rows to be deleted.