Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Tabel control - amount not correct for currency

Former Member
0 Kudos

Hi all

I m having a slight problem with a table control. First this is my table:

MANDT MANDT

INVID ZIC_INVID

INVLINE ZIC_INVLINE

.INCLUDE ZIC_ITEM

.INCLUDE ZIC_GLACCOUNT

.INCLUDE ZIC_MATERIAL

.INCLUDE ZIC_FI_ITEM

I have different includes in my table, because I have more then one table control, but everyhing is related so i work with includes.

In one of the includes i have an amount and currency.

First the amount is for example 1,00 and the currency is EUR. if i should change this to JPY i expect that the amount should change to 1 JPY like in transaction fv60, but this is not the case.

In my table i have a reference of my amount to the currency.

Also in the table control i have a reference. Is there something that I m missing?

thanks

Message was edited by: Kristof De Bruecker

8 REPLIES 8

naimesh_patel
Active Contributor
0 Kudos

Hello,

If you change the currency in the table control, you also should change the target amount as maintained in the foreign key relations. Otherwise it will not be converted automatically.

regards,

Naimesh

0 Kudos

Hi Naimesh Patel

if i change the target amount, after I changed the currency, the amount does remain the same.

It gives for currency JPY, 1,00 instead of 1.

0 Kudos

Hi,

Change the format of the field to 'DEC' in screen painter attributes of dict. tab and also tick the checkbox 'from dict.' with modify value blank ( mask original from dict)then amount will come correctly.

Regards

Laxman

0 Kudos

L Appana

I have changed the attribute to DEC, but i can't tick the checkbox from dict., because my table control is an internal table...

Changed to DEC didn't work either...

Message was edited by: Kristof De Bruecker

LucianoBentiveg
Active Contributor
0 Kudos

In amount column of table control you must to refer to waers column of that table control.

Are you doing it?

0 Kudos

Hi Peluka

Yes, I have done that. The amount refers to a waers field of that table control. The field is will hidden though, but filled in.

0 Kudos

That should work...

Have amount column attribute "Format" value 'CURR'?

0 Kudos

Peluka

I changed the attribute to 'CURR' and changed in my table the reference table and field and this works but...

when first I have an amount of 1,00 EUR, changed the currency to JPY, i get now automaticly 100 instead of 1.

Is this normal? What can I do to change in automaticly to 1?

Message was edited by: Kristof De Bruecker