Register Login

Difference b/w 'INTO TABLE INT-TABLE' and 'APPENDING TABLE INT-TABLE'

Updated May 18, 2018

Hello Experts,

May I know that what is the difference between " INTO TABLE INT-TABLE and APPENDING TABLE INT-TABLE". Which is suitable for best perfomance wise? In SELECT Statement from database table.

Kindly assist here, Thanks in advance.


Comments

  • 26 Jul 2015 10:51 pm SAPYard Helpful Answer

    Hello Sushma,

    INTO TABLE internal_table would put all the data from database table for the selected query into internal table.. It the table already has data, it would be overwritten by new set of data..

    APPENDING TABLE internal_table would add the new set of data from database below the already existing data in internal table. It would not erase/overwrite existing data.

    SAPYard


×