Skip to Content

Currency conversion in ECC query/infoset


We are doing a query with the table KNKK (Credit control values). For some currencies (HUF, JPY) the values are wrong. They have to be multiplied by 100 to get the correct values.

I know the reason is that in OY04 there are no decimals set, so SAP stores the values by dividing them by 100 to use the full length of the field.

I also found the following OSS notes about it:

1360282 - SAP Query: Generated currency fields
BC-SRV-QUE (Query)
137626 - FAQ: Decimal places for currency codes
XX-CSC-XX (Country specific customizing)

Does anybody have an example how we need to implement FM CURRENCY_AMOUNT_SAP_TO_DISPLAY or CONVERT_TO_LOCAL_CURRENCY in the infoset so the values are shown correctly? Please be aware that the currency (T014-WAERS) is not stored in the table KNKK.

Thanks for your help!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 19, 2017 at 07:30 PM

    Follow instruction and screenshots from KBA 2190072 - SAP query: Incorrect decimal place when currency field references to an external structure or table

    Add comment
    10|10000 characters needed characters exceeded