Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

append vs insert

Former Member
10,047

what is difference while inserting row through append statement and the one inserting using insert statement.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
4,527

Hi!

You can append a line only at the end of your table.

Insert command inserts the line anywhere in the internal table.

APPEND has better performance, so mostly this command has to be used...

Regards

Tamá

5 REPLIES 5
Read only

Former Member
0 Likes
4,527

hi pankaj

u can insert any where in the row

but u can append only at last

Read only

Former Member
0 Likes
4,527

Once you use APPEND it vl add that record only at the end of the DB table.

If you use INSERT it vl add records where ever u need

For eg: INSERT Itab index 4.

Read only

Former Member
0 Likes
4,527

u can insert a new record in internal table at specific index using insert statement.

through append new record is added at the last position in the internal table.

reward points please...

Read only

Former Member
0 Likes
4,527

HI pankaj

Append is used to store the row of data the end of internal table

But insert is used to inesrt it anywhere in the rows of internal table contents.

Read only

Former Member
0 Likes
4,528

Hi!

You can append a line only at the end of your table.

Insert command inserts the line anywhere in the internal table.

APPEND has better performance, so mostly this command has to be used...

Regards

Tamá