WRBTR value mismatch

[Former Member]

HI All,

I am using WRBTR field form BSIK table.

IN SE16 this table if currency is JPY then its showing 110.00 but its original value is 11,000 with out decimals.

In SE16 if we select the JPY currency row and click on display button its gives entire row values one by one in that the value is coming 11,000 which is correct.

But in my select query value is coming 110.00 which is wrong.

Pl help regarding this issue.

Thanks in Advance.

Regards,

Simha.

[Former Member]

Shakya,

I am confused when you say you are getting 11000 in your SELECT query and is correct? I think when you look at the table it automatically goes through the currency conversion process, which is missing when you query the currency or quantity fields directly. In this process the conversion would have to be handled appropriately by the code.

-- SMA

[brad_bohn]

The screen is handling the currency display due to the assigned reference field. You need to follow the same process for your screen display or your write operations. See the help files on currency handling.

[shaik_a]

Shakya,

I am confused when you say you are getting 11000 in your SELECT query and is correct? I think when you look at the table it automatically goes through the currency conversion process, which is missing when you query the currency or quantity fields directly. In this process the conversion would have to be handled appropriately by the code.

-- SMA

[Former Member]

ok