Skip to Content
0

Currency conversion in ECC query/infoset

Sep 19, 2017 at 09:55 AM

53

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jürgen L
Sep 19, 2017 at 07:30 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded