Hi,
you can use the collect statement in this way.
Collect:
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.
GO THROUGH THIS LINK
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/collect.htm
1. Can i use a collect statement here
We can use collect statement in all internal tables.
2. The only MAIN CONCEPT is
3. that it will SUM up the Quantity fields,
based upon
the COMBINATION of all Character Fields.
change code like this.
data: begin of itab occurs 0,
cur(3) type c ,
amt type i,
end of itab.
data: begin of wa_itab,
cur(3) type c ,
amt type i,
end of wa_itab.
itab-cur = 'EUR'.
itab-amt = 111.
<b>collect itab.</b>
itab-cur = 'USR'.
itab-amt = 222.
collect itab.
itab-cur = 'EUR'.
itab-amt = 777.
collect itab.
itab-cur = 'USR'.
itab-amt = 333.
collect itab.
sort itab by cur.
loop at itab into wa_itab.
write:/ wa_itab-cur,wa_itab-amt.
*read table itab
endloop.
regards
Anver
if hlped pls mark points
Bluesky
