Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

<body><p>Hello,</p><p></p><p>I'm experiencing an issue as descripted bellow:</p><p></p><p>1. I load an ODS and a specific record/KYF with some specific value (let's suppose ZKYF = 100,000)</p><p>2. When I look into the ODS contents for this particular record/KYF:</p><p></p><p> a. From the SAP-GUI using ODS' viewing options... &quot;Contents/Display A version table&quot; it shows up: 1,000 (this is using viewing settings as <strong>&quot;ALV Display Grid&quot; settings</strong>)</p><p></p><p> b. From the SAP-GUI using ODS' viewing options... &quot;Contents/Display A version table&quot; it shows up: 100,000 (this is using viewing settings as <strong>&quot;SE16 standard list&quot; settings</strong>)</p><p></p><p> c. From a BEx query over the same ODS it shows up as: 100,000</p><p></p><p>3. Currency for this KYF is JPY.</p><p></p><p>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.</p><p></p><p>I &quot;suspect&quot; 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:</p><p></p><p>&#91;http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17436&#93 <b>[original link is broken]</b>;</p><p>&#91;http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0d5bf96-b19b-2c10-e3b6-e2f12a3de99a?QuickLink=index&amp;overridelayout=true&#93;</p><p></p><p>but no success. I hope you can help. Best regards,</p><p></p><p>Bernardo</p></body>
Former Member
replied

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question