Skip to Content
0
Former Member
Nov 29, 2006 at 04:34 PM

SUM in internal Table- urgent

257 Views

Hi All,

In internal table I have fields F1 F2 F3 F4.

F1 is Invoice no.

F2 is Month

F3 is amount

F4 is currency.

I want to get SUM by Month wise & currency wise. How can I get this?

Eg : These are the values in internal Table

. F1 f2 f 3 f4

2345 01.01.2006 250.50 INR

1239 12.01.2006 240.50 INR

5463 15.01.2006 100 EUR

2003 17.01.2006 200 USD

1562 19.01.2006 500 EUR

6933 02.03.2006 150 USD

<b>I want to get SUM output like this

. F1 f2 f3 f4

2345 01.01.2006 250.50 INR

1239 12.01.2006 240.50 INR

_----


Total 491.00

-


5463 15.01.2006 100 EUR

1562 19.01.2006 500 EUR

_----


Total 600

_----


2003 17.01.2006 200 USD

_----


Total 200

_----


6933 02.03.2006 150 USD

_----


Total 150

_----


</b>