topic Re: ALV GRID Do_Sum in Application Development and Automation Discussions

ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:05:31 GMT

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

Re: ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:06:50 GMT

Perhaps answer is in your subject line

Re: ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:16:49 GMT

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

Re: ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:24:15 GMT

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

Re: ALV GRID Do_Sum

GauthamV — Thu, 18 Sep 2008 05:26:20 GMT

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.

Re: ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:28:32 GMT

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

Re: ALV GRID Do_Sum

Former Member — Thu, 18 Sep 2008 05:50:42 GMT

Thank you very much for the answer.

My problem is solved.

Pointa are assigned.

Regards,

Archana