Currency conversion in ECC query/infoset

former_member222075 — Tue, 19 Sep 2017 09:55:53 GMT

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!

Re: Currency conversion in ECC query/infoset

JL23 — Tue, 19 Sep 2017 19:30:58 GMT

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

topic Re: Currency conversion in ECC query/infoset in Application Development and Automation Discussions

Currency conversion in ECC query/infoset

Re: Currency conversion in ECC query/infoset