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. A restricted variant works withmesh paths.

Additions

• TABLE itab FROM wa
  Specifies a row to be deleted. The row 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 by specifying components of the primary table key statically of dynamically.
• itab INDEX idx
  Specifies a row to be deleted by specifying the row number of a table index idx.
• itab [USING KEY loop_key]
  Defines the rows to be deleted in a loop across the current row.
• itab [FROM idx1] [TO idx2] [WHERE log_exp|(cond_syntax)]
  Specifies multiple rows to be deleted by specifying a lower and upper row number in a table index idx1 and idx2. These can be restricted by specifying 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. Using COMPARING, the relevant comparison components can be specified.
• KEY key_name|(name)
  Specifies, statically or dynamically, a (secondary) table key that is used to search for the rows to be deleted.