Key figure showing value divided 100 or not depending on where it's queried

[Former Member]

Hello,

I'm experiencing an issue as descripted bellow:

1. I load an ODS and a specific record/KYF with some specific value (let's suppose ZKYF = 100,000)

2. When I look into the ODS contents for this particular record/KYF:

a. From the SAP-GUI using ODS' viewing options... "Contents/Display A version table" it shows up: 1,000 (this is using viewing settings as "ALV Display Grid" settings)

b. From the SAP-GUI using ODS' viewing options... "Contents/Display A version table" it shows up: 100,000 (this is using viewing settings as "SE16 standard list" settings)

c. From a BEx query over the same ODS it shows up as: 100,000

3. Currency for this KYF is JPY.

When I try to extract the data via an OpenHub to a transparent table the KYF value is transferred as 1,000 which is incorrect.

I "suspect" this is a currency conversion issue; I tried to determine how to replicate the internal process to get the right value transferred but no success. I've even checked related links just like:

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17436] [original link is broken];

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0d5bf96-b19b-2c10-e3b6-e2f12a3de99a?QuickLink=index&overridelayout=true]

but no success. I hope you can help. Best regards,

Bernardo

[former_member188011 · Accepted solution]

Hi Bernardo:

For a solution to this issue take a look at SAP Note 856619 - "Open hub: Internal format in output file or table"

Regards,

Francisco Milán.

[Former Member]

Hi,

As mentioned above, JPY/HUF has no subunit like 100 Penny = 1 Dollar. So if you see in table TCURX, Decimal maintained would be Zero for these currency.

In such cases, while Displaying system always multiplies the table values with 100. If Decimal maintained is 1 then multiplies by 10.

That is why values stored in tables are always = Actual Value / 100. Hence 1000 in your case.

ALV Display Grid shows actual value while SE16 display applies Display Conversions.

So I advice you change Decimal value in BW TCURX = 2 for JPY. (Ideally decimals should be same as that in R/3-ECC) If you cant change R/3 TCURX decimals, then always multiply the value for JPY x 100 while stroing into ODS/Cube in BW side.

[Former Member]

Hi,

There are some known currency conversion issues with JPY/HUF.

Check the currency translation once and the Conversion type.

In case evrything is fine and u still face teh issue use a multiplier of 100 for the KF while loading.

Reg,

Rahul