topic SUM in Application Development and Automation Discussions

SUM

Former Member — Fri, 31 Aug 2007 03:18:00 GMT

I want to print sum of all amount , i have 3 fields i want to sum them at the bottom of the report.these 3 fields are in a internal table.

how do i do?

Re: SUM

Former Member — Fri, 31 Aug 2007 03:29:11 GMT

Hi,

LOOP AT itab.

AT LAST.

SUM.

WRITE : itab-field1, itab-field2....

ENDAT.

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

Re: SUM

Former Member — Fri, 31 Aug 2007 03:31:16 GMT

hi,

check this samole code

data : l_cust like kna1.

data: l_sales like vbak occurs 0 with header line.

vbeln type vbak-vbeln,
erdat type vbak-erdat,
netwr type vbak-netwr,
end of l_sales.

data amt_sum like vbak-netwr value 0.

parameters : cno like kna1-kunnr.

select single * from kna1 into corresponding fields of l_cust where kunnr = cno.

select *

from vbak into corresponding fields of table l_sales where kunnr = cno.

loop at l_sales.

amt_sum = amt_sum + l_sales-netwr.

endloop.

Re: SUM

Former Member — Fri, 31 Aug 2007 04:20:25 GMT

hi vikas

thanks for giving me solution

after writing this code there is another errror occurs

in debug mode SUm is occurring but in my output its overlapping the 2nd field value and does display the sum of result

regards soumendra

Re: SUM

Former Member — Fri, 31 Aug 2007 04:25:21 GMT

hi vikas

thanks for giving me solution

after writing this code there is another errror occurs

in debug mode SUm is occurring but in my output its overlapping the 2nd field value and does not display the sum of result

regards soumendra

Re: SUM

Former Member — Fri, 31 Aug 2007 05:26:18 GMT

Hi Sumendra,

You need to adjust the WRITE statement..

Just give the positions too..

WRITE 😕 itab-field1,

20 itab-field2,

35 itab field3.

Adjust the values 20, 35 to display your o/p properly..

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

Re: SUM

Former Member — Fri, 31 Aug 2007 05:51:10 GMT

hi vikas

still the prblm comes

Re: SUM

Former Member — Fri, 31 Aug 2007 05:58:03 GMT

Hi Soumendra,

I am not getting the issue.. wht do u mean by overlapping with field 2??

can you copy and paste the o/p?

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

Re: SUM

Former Member — Fri, 31 Aug 2007 06:00:30 GMT

hi vikas

shall i copy my code and screen shot of my o/t send to u

Re: SUM

Former Member — Fri, 31 Aug 2007 06:01:10 GMT

plz send me urmail id

Re: SUM

varma_narayana — Fri, 31 Aug 2007 06:02:01 GMT

Hi ..

If you paste ur Code.. i can trace the probelm..

regards,

Varma@infyTree.

Re: SUM

Former Member — Fri, 31 Aug 2007 06:06:08 GMT

Hi,

vikas.bittera@gmail.com

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**