08-01-2006 3:34 PM
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
08-01-2006 3:40 PM
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
08-01-2006 5:40 PM
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.
08-01-2006 5:53 PM
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
08-02-2006 6:53 AM
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
08-01-2006 3:43 PM
In amount column of table control you must to refer to waers column of that table control.
Are you doing it?
08-01-2006 5:39 PM
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.
08-01-2006 5:47 PM
That should work...
Have amount column attribute "Format" value 'CURR'?
08-02-2006 6:52 AM
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