DB connect: Yen Currency

we are extracting data from R3 and other databases using DB connect.

data extracted via DB using Yen currency multiplies the result by 100.

Transactions extracted from R3 using Yen currency are displayed correctly.

checked the currency settings/ tables and everything seems to be correct.

I know that Yen does not have decimal places and that R3 & BW overcome this problem in order to display the correct value. However this translation does not seem to work when extracting via DB connect.

Any useful suggestions/ solutions?