topic Re: Caluclate SUM in Application Development and Automation Discussions

Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:08:44 GMT

Hello Gurus,

A text file has data is in the following manner

I have read the file and all properly the only problem

here is summing up the data so below is how my data looks.

Please make a note this is not stored in DDIC database table it will be read in an Internal table

Col1 Col2 Col3

ABC A 1

ABC A 2

ABC B 3

BBC A 4

BBC A 5

I want to Sum up COL3 by grouping COL1 and COL2

so First Record = ABC A 3 ( 1+ 2)

Second Record = ABC B 3

Third Record = BBC A 9 ( 4 + 5 )

Please let me know I tired many logic but nothing seems to be working.. your help is greatly apprecaited .

Points guranteeed !!

Reagrds,

Aryan

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:12:39 GMT

Hi,

try this

loop at itab.

at new col1.

sum.

endat.

endloop

Reward if useful

Regards

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:12:45 GMT

u can achieve this by using control break statments.

Madhavi

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:14:53 GMT

Hi Aryan

Try this code, say you ITAB has the rq. data

Sort itab by COL1 COL2.

Loop at itab.

l_value = l_value + itab-COL3.

at end of COL2.

itab1-COL1 = itab-COL1.

itab1-COL2 = itab-COL2.

itab1-COL3 = L_VALUE.

Clear l_value.

endat.

Endloop.

Now you ITAB1 will have the data in the req. format.

~ Ranganath

Edited by: Ranganath Ramesh on Jan 11, 2008 8:15 AM

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:15:07 GMT

Please guys try this and reply to me and please paste the abap code if possible really looking forward to your help guys , please create such data in your Internal table

and try calculating the sum , please paste the entire Abap code if it works for you I will award points there itself

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:15:39 GMT

Hi,

Read the file in an internal table with 3 cols and then loop at that internal table and claculate the sum based on condition you want to.

regards,

pankaj

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:15:58 GMT

Hello Aryan,

Please use collect on your internal table calculation.

Please reward points if useful.

Regards,

Paresh.

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:16:37 GMT

its on change of col1 and col2 as well its not only

col1 , Please guys try this and reply to me and please paste the abap code if possible really looking forward to your help guys , please create such data in your Internal table

and try calculating the sum , please paste the entire Abap code if it works for you I will award points there itself

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:17:05 GMT

Hi Aryan,

Try the following code.

Suppose the following data is stored in itab.

Col1 Col2 Col3

ABC A 1

ABC A 2

ABC B 3

BBC A 4

BBC A 5

Declare one more internal table which should have same structure of itab.

Ex.

data: itab1 like itab occurs 0 with header line.

Now

Loop at itab.

move-corresponding itab to itab1.

collect itab1.

clear itab.

endloop.

Now in ur ITAB1, u can see ur expected result.

First Record = ABC A 3 ( 1+ 2)

Second Record = ABC B 3

Third Record = BBC A 9 ( 4 + 5 )

If it is usefull pls do reward pts.

Regards

Srimanta

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:17:41 GMT

Cannot use collect becuase its char field in the text file

Please guys try this and reply to me and please paste the abap code if possible really looking forward to your help guys , please create such data in your Internal table

and try calculating the sum , please paste the entire Abap code if it works for you I will award points there itself

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:18:06 GMT

Hi,

Do like this

data: wa1 like line of itab,

lv_lines type i,

lv_cnt type i.

describe table itab lines lv_lines.

sort itab by f1 f2.

Loop at itab into wa.

lv_cnt = lv_cnt + 1.

if wa1-f1 = wa-f1 and wa1-f2 = wa-f2.

wa1-f3 = wa1-f3 + wa-f3.

delete itab from wa.

append wa1 to itab.

endif.

if lv_cnt = lv_lines.

exit.

endif.

wa1 = wa.

endloop.

Regards,

Satish

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:23:07 GMT

Hi there,

You can use COLLECT instead of APPEND.

Full code:

REPORT ZK_TEST3.

types : begin of ty_itab,

col1(3) type c,

col2(1) type c,

col3 type i,

end of ty_itab.

data : gt_itab type table of ty_itab,

wa type ty_itab.

wa-col1 = 'ABC'.

wa-col2 = 'A'.

wa-col3 = '1'.

collect wa into gt_itab.

wa-col1 = 'ABC'.

wa-col2 = 'A'.

wa-col3 = '2'.

collect wa into gt_itab.

wa-col1 = 'ABC'.

wa-col2 = 'B'.

wa-col3 = '3'.

collect wa into gt_itab.

wa-col1 = 'BBC'.

wa-col2 = 'A'.

wa-col3 = '4'.

collect wa into gt_itab.

wa-col1 = 'BBC'.

wa-col2 = 'A'.

wa-col3 = '5'.

collect wa into gt_itab.

loop at gt_itab into wa.

write 😕 wa-col1, wa-col2, wa-col3.

endloop.

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:25:30 GMT

Satish , you are some what close , I cannot delete the lines as I need to to have all the lines in Itab

and I am actullay moidfyin an existing abap code

so nothing mich to play around they have used

as Occurs 0 when declaring Itab so I am not using

wa, could you please arrange the data @ your

end and try executing the code

Edited by: Aryan T on Jan 12, 2008 5:37 AM

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:26:53 GMT

Hey K. Tiwari make Col3 as Char and try using collect this is what my problem is

Re: Caluclate SUM

Former Member — Fri, 11 Jan 2008 07:32:45 GMT

Hi Aryan,

Try this..

data: total type netpr.

loop at itab.

at new.

endat.

total = total + col3.

at end of col1.

endat.

at end of col2.

write:/ total.

clear : total.

endat.

endloop.

Award points if helpful.

Kiran Kumar.G.A

Have a Nice Day..