topic Re: sum fields in internal table in Application Development and Automation Discussions

sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:40:49 GMT

Hi,

my sorted table with unique key field1 field2 is defined like:

field1 keyfield

field2 keyfield

field3

field4

i would like to get a sum of field3 and field4 of all entries "for each new field1 field2" and write it out.

field1 = 1

field2 = 100

sum(field3)

sum(field4)

write it out.

field1 = 1

field2 = 200

sum(field3)

sum(field4)

write it out.

field1 = 2

field2 = 100

sum(field3)

sum(field4)

write it out.

Q: Should I use LOOP and AT NEW FIELD1/FIELD2 or can i use another way for that ?

Thanks,

Gordon

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:43:16 GMT

Hi,

You can use loop and At new.it is enough.

Regards

Jana

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:43:41 GMT

Hi,

my sorted table with unique key field1 field2 is defined like:

field1 keyfield

field2 keyfield

field3

field4

create one more table similar to the above table

loop the first table.

secondtable-field1 = firsttable-field1.

secondtable-field2 = firsttable-field1

secondtable-field3 = firsttable-field1

secondtable-field4 = firsttable-field1

collect secondtable.

endloop.

Regards

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:44:20 GMT

loop at itab.

res = res + itab1-field3 + itab-field4.

endloop.

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:44:24 GMT

Hello

Do Following:

1. Sort Internal table by Field1 Field2

2. Do Loop... At New Field2... Sum... Endat.... Endloop.

Thanks

Amol Lohade

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:45:07 GMT

declare an internal table same as itab...

first do a sort on internal table...

sort itab by field1 field2.

loop at itab.

itab1-field1 = itab-field1.

itab1-field2 = itab-field2.

itab1-field3 = itab-field3.

itab1-field4 = itab-field4.

collect itab1.

endloop.

loop at itab1.

write:/itab1-field1, itab1-field2, itab1-field3, itab1-field4.

endloop.

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:46:49 GMT

hi,

you will have to use LOOP AT and AT NEW field2.

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:49:48 GMT

try to use COLLECT it will help.

Regards

Sachin

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:54:02 GMT

thanks for your help.

what is the better way to avoid performance issue.

1. loop / at new field or

2. second itab and use collect itab.

note: my table is selected from VBRP (invoice items) - very huge

Re: sum fields in internal table

bpawanchand — Thu, 25 Sep 2008 09:55:12 GMT

The second option is to be avoided.

2. second itab and use collect itab.

Regards

Pavan

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 09:58:11 GMT

that means,

i should use the loop option for this task ?

Re: sum fields in internal table

kesavadas_thekkillath — Thu, 25 Sep 2008 10:00:00 GMT

if field1 and field2 are non numeric then

collect those values to other itab...

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 10:01:11 GMT

they are both numeric.

Re: sum fields in internal table

Former Member — Thu, 25 Sep 2008 10:03:20 GMT

hi,

then you cannot use "collect" statement.

you will have to first sort table based on field1 field2.

then you will have to use LOOP AT and AT NEW field2.

Re: sum fields in internal table

kesavadas_thekkillath — Thu, 25 Sep 2008 10:11:09 GMT

Then do it like this.

loop at itab into wa.

at new field2.

move wa-field1 to it2-field1.

move wa-field2 to it2-field2.

endat.

at end of field2.

sum.

move wa-field3 to wa1-field3.

move wa-field4 to wa1-field4.

append wa1 to it2.

endat.

endloop.