Question:
Hi All,
I've a keyfigure - YAMOUNT in my custom cube. It shows values excatly like the values in the source system for all currencies. But when I execute a query on this cube, the amounts are getting multiplied by 100 for curriencies other than USD.
Any idea what could be wrong?
Thanks,
CM
Answer:
Hi,
In your place I would first try to find out whether it is an infocube data issue or a query translation issue. (use listcube to verify the infocube amounts)
-> If it turns out to be an infocube issue, you may wanna know about the following;
SAP stores all amounts fields with 2 decimals, independ on whether the corresponding currency key has 0, 1, 2, .... decimals.
Examples:
1. USD 200.35 gets stored as 200.35 in the database
when displayed it detects that USD is defined with 2 decimals and
thus the amount is displayed as stored in the database
2. Let's assume that EUR would not have any decimals
EUR 212 would be stored as 2.12 in the database
when displayed it detects that EUR is defined with 0 decimals and
thus the amount is multiplied by 100 before to be displayed
For that reason any amount field in the system is always linked with a currency key field. This currency key has a specific number of decimals, I believe this is defined in table TCURX.(or TCUR?)
This is all standard SAP.
-> If it turns out to be a query issue:
Use RSRT to debug the query.
Select the standard break-points to stop at the currency translation code.
Answer:
Hi,
I have the same issue as this, where conversion from USD to IDR returning me a value which is multiplied by 100. I agree that it is due to no decimal place for IDR and is configurable.
Just wonder is there any simpler solution to resolve it function module or setting, despite using coding to resolve the problem.
Regards,
Sean