Hi guys,
I get different values of one key figure in BEX and in cube directly:
Example:
Cube:
149.247,00-
BEX:
-14.924.700
It is not the general problem, I have this problem only with two currencies: HUF and JPY, the other values are OK.
I did not use here "Scaling Factor".
Do you have mayby any idee, why it is so?
Regards
Erwin
I found in SAP Reference IMG - .... - General Settings -> Currencies -> Set Decimal Places for Currencies:
HUF - > decimals -> 0
JPY - > decimals -> 0
Hi,
You can set on how to display - sign in Query properties.
Query Properties --> tab value display --> select radio button after display.
This will be set across all KF's in your query
Hello Erwin
Did you have a look at below note, if not please check .
Note 1240163 - Amount too high by factor of 100 for HUF, JPY currencies
Regards
Anindya
Hi,
There is a table TCURX and you need to write a piece of code in routine like this:
select records from table TCURX into itab.
sort itab by currkey.
clear the itab.
read itab into wa with key currkey = source field.
case sy-subrc.
when 0.
result = source field / 100.
when others.
result = source field.
endcase.
Cheers!!
MK
Hi,
thank you for your help but I did not mind "-" sign.
As you can see below the comma sign is a problem. The number in BEX is 100 times bigger then in cube.
Cube:
149.247,00-
BEX:
-14.924.700