ALV GRID Do_Sum

[Former Member]

Hi Guru's

I have written a zreport where i have used ALV Grid.

In ALV grid we can display the sum of the columns. Now in a column we are displaying amount in document currency and the document currency can be different for every transaction for a single customer.

Now I want to dispaly the sum for different currencies separately at the bottom.

How can i do it.

Please help.

Regards

Archana

[Former Member]

Perhaps answer is in your subject line

[Former Member]

Hi,

You need to have a field for different currencies then you include that field in your fieldcatalog so that you can include fieldcatalog-do_sum='X'.

Regards,

Fred

[Former Member]

I did that but the suppose i have the entries as shown below

AMT Currency

1000 GHC

2000 USD

12000 GHC

9000 USD

-

---

13000 GHC

11000 USD

How can show the sum as mentioned above?

Regards,

Archana

[GauthamV]

hi,

use cfieldname option in fieldcatelog structure.

fieldcatalog-fieldname = 'WRBTR'.

fieldcatalog-REF_TABNAME = 'BSEG'.

fieldcatalog-seltext_l = 'TRANSACTION CURRRENCY'.

fieldcatalog-col_pos = 17.

fieldcatalog-cfieldname = 'WAERS'.

fieldcatalog-do_sum = 'X'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

[Former Member]

check this program BALVST02_GRID , i am not sure why you are not getting. you are doing some thing wrong in that case...

[Former Member]

Hi

Thank you very much for the answer.

My problem is solved.

Pointa are assigned.

Regards,

Archana