Select ... Into Table & Select ... Appending Table in ABAP/4

Select ... Into Table


SELECT * FROM TABLE1 INTO TABLE itab1
WHERE fld1 = ’AA’.

Select ... Appending Table


SELECT * FROM TABLE1 APPENDING TABLE itab1
WHERE fld1 = ’AA’. 

Two statements are similar if itab1 has no entry.

But if itab1 has at least one row before select clause:

  • Select ... Into Table
    The entries of internal table will be cleared before adding new records.
  • Select ... Appending Table
    System don’t touch old records and append new records to internal table.

Post new comment