Different values in cube and in BEX

[Former Member]

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

[Former Member]

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

[Former Member]

I found in SAP Reference IMG - .... - General Settings -> Currencies -> Set Decimal Places for Currencies:

HUF - > decimals -> 0

JPY - > decimals -> 0

[Former Member]

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

[anindya_bose]

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

[Former Member]

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