Skip to Content
author's profile photo Former Member
Former Member

Tabel control - amount not correct for currency

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Aug 01, 2006 at 02: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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Laxmana Appana

      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

  • Posted on Aug 01, 2006 at 02:43 PM

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

    Are you doing it?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Luciano Bentivegna

      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