topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Wed, 27 Dec 2006 18:38:28 GMT

Hi all,

What is the difference between Append and Insert.

Re: reports

rahulkavuri — Wed, 27 Dec 2006 18:41:22 GMT

INSERT statement inserts a single record into the database table.

Syntax

Tables: sflight.

Sflight-carrid = ‘LH’.

Sflight-connid = ‘234’.

Insert sflight.

Table sflight is inserted with the record. The SY_SUBRC is returned for this statement. If the entry already exists then the SY_SUBRC is set to non-zero value and you can do processing for existing record by giving some error message.

Both APPEND and INSERT add records..

As far as I know we generally use APPEND statement when we are adding lines to an Internal table...

Award points if found helpful

Re: reports

SantoshKallem — Wed, 27 Dec 2006 18:43:22 GMT

Append command is used to insert a new record in to an internal table.

insert is used to update Table.

Re: reports

Former Member — Wed, 27 Dec 2006 18:44:26 GMT

Hi,

<b>Insert:</b>

INSERT [{<wa>|INITIAL LINE} INTO] <itab> [INDEX <idx>].

Inserts a new line into table. For tables with a header line the source area can be omitted. With INDEX option, the new line is inserted before the line which has the index <idx>. After the insertion, the new entry has the index <idx> and the index of the following lines is incremented by 1.

If the table consists of <idx> - 1 entries, the system appends the new entry after the last existing table line. If the table has less than <idx> - 1 entries, the system cannot insert the entry: SY-SUBRC = 4. If success, SY-SUBRC = 0.

Use INSERT without the INDEX option is allowed only within a LOOP - ENDLOOP loop by inserting the new entry before the current line (i.e. the line which has the index returned by SY-TABIX).

INSERT LINES OF <itab1> [FROM <idx1>] [TO <idx2>] INTO <itab2> [INDEX <idx>].

Inserts lines from one table into another table. Default inserts entire table. Can be up to 20 times faster than inserting lines line by line in a loop.

<b>

Appending Lines:</b>

APPEND [{<wa>|INITIAL LINE} TO] <itab>.

Appends a new line to table. For tables with a header line the source area can be omitted. After statement, the SY-TABIX contains the index of the appended line.

APPEND LINES OF <itab1> [FROM <idx1>] [TO <idx2>] TO <itab2>.

Appends lines from one table to another table. Default appends entire table. After statement, the SY-TABIX contains the index of the last appended line. About 3 to 4 times faster than appending lines line by line in a loop.

APPEND [<wa> TO] <itab> SORTED BY <f>.

Inserts the new line so that the internal table <itab> is sorted in descending order by the field <f>. If you use the SORTED BY option, the table can contain only the number of lines specified in the OCCURS parameter. If you add more lines than specified, the last line is discarded. This is useful for creating ranked lists of limited length (e.g. "Top Ten"). For ranked lists containing more than 100 entries, use instead the SORT for performance reasons.

Re: reports

Former Member — Wed, 27 Dec 2006 18:46:11 GMT

Can I use insert statement to insert into internal table. or can i use insert instead of append

Re: reports

Former Member — Wed, 27 Dec 2006 18:48:12 GMT

I didnt get u

Re: reports

RichHeilman — Wed, 27 Dec 2006 18:48:53 GMT

Yes, you can use the INSERT statement to insert into internal table. Say that you want to insert a record into the second row of the table. You could use INDEX here.

insert itab index 2.

Regards,

Rich Heilman

Re: reports

Former Member — Wed, 27 Dec 2006 18:54:21 GMT

Hi,

Thanks for the answer. I have some more doubt.

If I use append where will the value be stored in header or the body. and what about insert.If I just use

Insert itab.

will it be inserted in the first index. then if I use the same statement the second time what will happen to the first value

Re: reports

Former Member — Wed, 27 Dec 2006 19:02:53 GMT

Hello

Re: reports

Former Member — Wed, 27 Dec 2006 19:03:29 GMT

Thanks for the answer. I have some more doubt.

If I use append where will the value be stored in header or the body. and what about insert.If I just use

Insert itab.

will it be inserted in the first index. then if I use the same statement the second time what will happen to the first value

Re: reports

SantoshKallem — Wed, 27 Dec 2006 19:07:21 GMT

it stores from header to body

insert itab.

will it be inserted in the first index. then if I use the same statement the second time what will happen to the first value

here it increases the index.

index is used to place the record in specific location.

Re: reports

SantoshKallem — Wed, 27 Dec 2006 19:09:39 GMT

select statement retrive the record and places in header.

append statement moves the record from header to body.

Re: reports

Former Member — Wed, 27 Dec 2006 19:30:57 GMT

thanx dude.....