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.
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
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