Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem in ALV

Former Member

‎2007 Oct 27 9:51 AM

0 Likes
779

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

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

Reply
5 REPLIES 5
Read only

Former Member

‎2007 Oct 27 10:00 AM

0 Likes
742

Hi

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.

Read only

Former Member
In response to Former Member

‎2007 Oct 27 10:05 AM

0 Likes
742

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

It should be Bifurcated according to Currency

Read only

Former Member

‎2007 Oct 27 10:09 AM

0 Likes
742

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.

Read only

Former Member
In response to Former Member

‎2007 Oct 27 10:13 AM

0 Likes
742

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)'.

as

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

Read only

Former Member

‎2007 Oct 27 10:21 AM

0 Likes
742

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