topic Re: Problem in ALV in Application Development and Automation Discussions

Problem in ALV

Former Member — Sat, 27 Oct 2007 08:51:00 GMT

Hi Experts,

I've an ALV Grid control Report,

at output list i am having a Column As Amount which is NETWR from VBAK.

When i select AMOUNT column and click on SUM button it sdould show me

AMOUNT ACCORDING TO CURRENCY

For Ex. 24000 INR

32894 USD

Right now it is directly Summing up the values in that column irrespective of the

currency.

and more thing i would like to say is, i m not using FM 'CATALOG_MERGE'.

My code is something like :

wa_fieldcatalog-fieldname = 'NETWR'. " TOT AMOUNT

wa_fieldcatalog-outputlen = '15'.

wa_fieldcatalog-col_pos = '8'.

wa_fieldcatalog-do_sum = 'X'.

wa_fieldcatalog-seltext_m = 'Basic Price(INR)'.

APPEND wa_fieldcatalog TO lit_fieldcatalog.

CLEAR wa_fieldcatalog.

Pls Help..

Pts rewarded for sure...

regards Snehal

Re: Problem in ALV

Former Member — Sat, 27 Oct 2007 09:00:58 GMT

Do one thing,add one more clmn in it, netwr1 like netwr. and than calculate it like :

netwr1 = ( netwr * wkurs ).This wkurs is exchange rate.It will convert ti INR.

Than map it up the the fldcatlog.It can solve ur problem.

Re: Problem in ALV

Former Member — Sat, 27 Oct 2007 09:05:45 GMT

No...I dont want the amount to be converted into INR..

It should be Bifurcated according to Currency

Re: Problem in ALV

Former Member — Sat, 27 Oct 2007 09:09:47 GMT

hi,

wa_fieldcatalog-fieldname = 'NETWR'. " TOT AMOUNT

wa_fieldcatalog-outputlen = '15'.

wa_fieldcatalog-col_pos = '8'.

<b>wa_fieldcatalog-do_sum = 'X'.</b>

wa_fieldcatalog-seltext_m = 'Basic Price(INR)'.

because of this statement, summation is coming directly.

Re: Problem in ALV

Former Member — Sat, 27 Oct 2007 09:13:11 GMT

even if i remove : wa_fieldcatalog-do_sum = 'X'.

it shows same Total...

and on more thing

consider

wa_fieldcatalog-seltext_m = 'Basic Price(INR)'.

wa_fieldcatalog-seltext_m = 'Basic Price'.

Dont Consider 'INR' at that line....

so..it is like :

wa_fieldcatalog-fieldname = 'NETWR'. " TOT AMOUNT

wa_fieldcatalog-outputlen = '15'.

wa_fieldcatalog-col_pos = '8'.

wa_fieldcatalog-do_sum = 'X'.

wa_fieldcatalog-seltext_m = 'Basic Price'.

i repeat my question///

I want SUm ACcording to Currency

Re: Problem in ALV

Former Member — Sat, 27 Oct 2007 09:21:19 GMT

Hi Snehal,

Add <b>wa_fieldcatalog-QFIELDNAME</b> = 'Cuky field(the field name which contains INR & USD)'. in ur field catalog.

like in ur code

wa_fieldcatalog-fieldname = 'NETWR'. " TOT AMOUNT

wa_fieldcatalog-outputlen = '15'.

wa_fieldcatalog-col_pos = '8'.

wa_fieldcatalog-do_sum = 'X'.

wa_fieldcatalog-seltext_m = 'Basic Price(INR)'.

wa_fieldcatalog-QFIELDNAME = 'ur currency field name'.

APPEND wa_fieldcatalog TO lit_fieldcatalog.

CLEAR wa_fieldcatalog.

Try it, ll definitly solve ur problem.

Reward pts if it works out.

regards

pankaj