topic Re: help with the code in Application Development and Automation Discussions

help with the code

Former Member — Wed, 11 Jul 2007 01:59:20 GMT

Hi all,

i have records like in internal table itab

id amount

101 1 1.00

101 2 2.00

102 1 1.00

102 2 2.50

102 3 3.00

103 2 1.50

i want the output like like this internal table itab1

101 3.00

102 6.50

103 1.50

clear : wa_zoritem ,price.

total= 0.00

loop at itab into wa_itab.

on change of wa_itab1-id.

clear total.

total= total + wa_itab1-amount.

wa_itab1-id = wa_itab_copy-id.

wa_itab1-total= wa_itab_copy-total.

append wa_itab1 to itab1.

endon.

*MODIFY TABLE i_FINAL FROM wa_FINAL

TRANSPORTING COST.

*MODIFY wa_final to i_final.

wa_itab_copy = wa_itab.

clear : wa_itab.

endloop.

This works fine when i have multiple records

but this doesn't work when i have the follwwing record in itab

id amount

101 1 1.00

Thanks

Re: help with the code

jayanthi_jayaraman — Wed, 11 Jul 2007 02:03:01 GMT

Hi,

clear : wa_zoritem ,price.

total= 0.00

loop at itab into wa_itab.

total= total + wa_itab-amount.

wa_itab1-id = wa_itab-id.

wa_itab1-total= wa_itab-total.

on change of wa_itab-id.

append wa_itab1 to itab1.

clear total.

total= total + wa_itab-amount.

endon.

clear : wa_itab.

endloop.

Message was edited by:

Jayanthi Jayaraman

Re: help with the code

Former Member — Wed, 11 Jul 2007 02:06:33 GMT

Hi Kajol,

Try this

loop at itab into wa_itab.

<b>if sy-tabix = 1.

total= total + wa_itab1-amount.

endif.</b>

on change of wa_itab1-id.

clear total.

total= total + wa_itab1-amount.

Regards,

Atish

Re: help with the code

Former Member — Wed, 11 Jul 2007 04:28:41 GMT

hi,

*suppose the data is avialble in the internal table ITAB.
[code]
sort ITAB by ID amount.
delete adjacent duplicates from ITAB comparing ID.

*Now thw ITAB conatins only the records.

*101 3.00

*102 6.50

*103 1.50[/code]

Regards

Reshma

Re: help with the code

kesavadas_thekkillath — Wed, 11 Jul 2007 05:06:56 GMT

data: itab2 like table of itab1 with header line.

loop at itab1.

move:; <col1> to itab2-<col1>

move: <col2> to itab2-<col2>

collect itab2.

clear itab2.

endloop.

or u can collect the itab1 itself but the values in the second field will get summed up.

if its not a probs u can do the same method in itab1.

Re: help with the code

dev_parbutteea — Wed, 11 Jul 2007 05:21:57 GMT

Hi,

Either use collect statement

loop at itab

if id is same as previous

add the two id's and delete record from table.

Regards,

Sooness