SAP Knowledge Base Article - Preview

2942607 - Wrong result of function CONVERT_CURRENCY by a factor of 100


You used HANA function convert_currency in SQL script or AMDP. However, the result is wrong and always has a factor of 100.

This can be seen for Japanese Yen (JPY), Korean Won (KRW), Chilean Peso (CLP) or other currencies which do not have 2 decimal places.



  • HANA Platform 1.0
  • HANA Platform 2.0
  • AMDP


SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0


CONVERT_CURRENCY, 100, KRW, EUR, JPY, currency conversion, decimal, TCURR, TCURX, rate, currency, AMDP , KBA , HAN-DB-SCR , SAP HANA SQL Script , BC-ABA-LA , Syntax, Compiler, Runtime , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.