Currency conversion in ECC query/infoset

[former_member222075]

Hej

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!

JD

[JL23]

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