Online Tutorials & Training Materials | STechies.com
Register Login

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

|| || 1

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

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

  • SAPYard
    26 Jul 2015 10:51 pm 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