Symptom
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.
Read more...
Environment
- HANA Platform 1.0
- HANA Platform 2.0
- AMDP
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
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.