topic Re: Collect statement in Application Development and Automation Discussions

Collect statement

Former Member — Tue, 29 Mar 2005 07:58:52 GMT

hey guys,

Can we use collect statement in same internal table?

loop at itab_list.

collect itab_list.

endloop.

is it correct?

ambichan.

Re: Collect statement

ssimsekler — Tue, 29 Mar 2005 08:16:33 GMT

Hi Ambi

Here is an official explanation:

<i>"When the line is inserted, the system checks whether there is already a table entry that matches the key. If there is no corresponding entry already in the table, the COLLECT statement has the same effect as inserting the new line. If an entry with the same key already exists, the COLLECT statement does not append a new line, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.

You should only use the COLLECT statement if you want to create summarized tables. If you use other statements to insert table entries, you may end up with duplicate entries."</i>

By the way, do not forget that, all of the non-key fields of your internal table must have a numeric type (F, I, or P).

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: Collect statement

andreas_mann3 — Tue, 29 Mar 2005 08:20:56 GMT

> hey guys,

> Can we use collect statement in same internal table?

> loop at itab_list.

> collect itab_list.

> endloop.

> is it correct?

-> no.

try this

DATA itab_collect LIKE itab_list OCCURS 0 WITH HEADER LINE.

loop at itab_list.

collect itab_list into itab_collect.

endloop.

Andreas

Re: Collect statement

nitschket — Tue, 29 Mar 2005 14:27:15 GMT

Yes, you can do this... the question rather is: what do you want to achieve?

Suppose your internal (standard) table contains two entries with the same key where the non-key part is just an integer with value 1 in the first line and value 2 in the second line.

After running your little piece of code on this internal table the non-key part of the first line will be 4 and the second line will stay as is.

By the way: COLLECT should rather be used to fill 'empty' tables for performance reasons.

Tom