09-18-2008 6:05 AM
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
09-18-2008 6:16 AM
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
09-18-2008 6:06 AM
09-18-2008 6:16 AM
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
09-18-2008 6:24 AM
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
09-18-2008 6:26 AM
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.
09-18-2008 6:28 AM
check this program BALVST02_GRID , i am not sure why you are not getting. you are doing some thing wrong in that case...
09-18-2008 6:50 AM
Hi
Thank you very much for the answer.
My problem is solved.
Pointa are assigned.
Regards,
Archana