cancel
Showing results for 
Search instead for 
Did you mean: 

Currecncy Display in DSO for KRW etc..

Former Member
0 Kudos

Hello Experts

I have a question on Currency data storage in BI.

I have to store a Korean currency (KRW) in the DSO.

My flat file has:

Customer Amount Currency

101 500 KRW

Data display from DSO is

Customer Amount Currency

101 5 KRW

When I use Open hub to pull data from DSO I get

Customer Amount Currency

101 5 KRW

Report on the DSO pulls right number.

But ...

How can I pull the correct numbers (500) from DSO using Open hub ?

I guess there is some setting to be changed for currencies like these.

Please let me know.

Regards

Accepted Solutions (0)

Answers (4)

Answers (4)

dielom
Active Contributor
0 Kudos

Hi Doodle,

In table TCURX you can define how many decimals a currency will allow. these are only exceptions. You can find there that KRW is set to 0, that means that no decimals are allowed, so multiplying by 100 would be the right thing to do.

Hope this helps.

Cheers,

Diego

former_member188011
Active Contributor
0 Kudos

Hi there:

Please refer to the SAP Notes below.

1176399 - "Loading amounts to the BW system; decimal places"

1240163 - "Amount too high by factor of 100 for HUF, JPY currencies"

153707 - "Currency translation miscalculates by 100, 1000.."

Regards,

Francisco Milán.

Former Member
0 Kudos

Hi,

I have doubts that data being loaded into DSO is being already undergoing some transformation (i.e. from 500 to 5). And the report might be doing some calculation(like *100) while doing the reporting. Can you please confirm that this is not the case?

Please check in the DSO data to verify that it shows 500 in the table.

Regards, Rahul

dielom
Active Contributor
0 Kudos

Rahul, your doubts dont' help, facts do. Read Francisco notes.

Cheers,

Diego

dielom
Active Contributor
0 Kudos

Hi Doodle,

There is a setting on the currencies that says how many decimals are added to store and then removed to display. So the value you are getting might be right. In case it isn't what you have to do is check that factor (100 from what you mentioned), and multiply the amount by that factor when the currency is KRW. That's what we have done in one of our interfaces.

Hope this helps.

Cheers,

Diego