Skip to Content

BEx Issue with keyfigure

Hi Folks,

We have one issue with bex out put. 12.40 in ecc coming as 1,2404999999999999E+01 our bw 7.5. we can see the same value till composite provider. Requirement is we need to see it as 12.40. i have changed decimal settings to 0.00. but value is coming as 12.41. (Break down duration is 1240 in ecc). Tool used to design is HANA studio.

How can we resolve this issue? kindly suggest some inputs.

Thanks a lot in advance.

Raki.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Apr 17, 2017 at 10:26 PM

    Hi Raki,

    You dis not show us the ECC version of the key figure, but my guess is that it is a decimal (DEC) type number.

    My guess is that that th number at the source is 12.405

    The problem is that your key figure is in floating point format (FLTP) .

    The conversion of DEC to FLTP is not perfect , so 12.405 is rendered as 12.40499999999999

    When the query rounds to two decimals, 12.40499999999999 is rounded down to 12.40

    Option:

    1) Recreate the key figure as DEC to match how the data is stored in ECC. No conversion, no problem!

    2) In the query, set the number of decimals to three. 12.40499999999999 will round to 12.405 , the stored value in ECC.

    Let us know the right answer!

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

    • Hi John,

      You are right. But our client agreed for a little variance. now we cant change key figure to dec from fltp because of one value is not in sync with ecc.

      Thanks a lot for your inputs.

      Raki.

  • avatar image
    Former Member
    Apr 13, 2017 at 07:45 PM

    Hi Raki,

    Did you try rounding? Is it acceptable?
    Example: round("column_Name",3)

    Mateusz.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2017 at 09:09 AM

    Hello;

    I recommend you create a new KF (since tomorrow other users would like to see 12.41 in another report) and apply the following logic:

    https://archive.sap.com/discussions/thread/409513

    Hope it helps;

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2017 at 09:38 AM

    Hi,

    I think it is currency issue.

    Check this SAP Note : https://service.sap.com/sap/support/notes/1240163

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2017 at 10:32 PM

    Hi Raki,

    What kind of key figure is it?

    What is the unit of measure or currency?

    Is it a calculation?

    If so, what are the components of the the calculation?

    If so, what is their structure?

    Details help.

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded