Error in Currency Conversion in HANA Calculation View

[jyoti_senapati]

Hi Experts,

I am doing Currency Conversion upon the Salary column of EMP table.

SAP Std. Currency tables available in the HANA and I have mentioned that schema.

PFB of Curr conv details:-

But while executing data preview getting below error.

Please provide any input or feedback.

Regards,

Jyoti

[dgallegog]

Hello jyoti.senapati,

I have the same problem as you.

Did you resolve it?

Thanks in advance.

David

[aleksandrs_antonuks2]

jyoti.senapati ,

Just remove the ERROR_HANDLING string.

Br,
Aleks.

[akshinde]

Your SALARY_USD Data type is Double , the output from currency conversion coming out in DECIMAL size and the storing into DOUBLE size , because of which numeric overflow error appearing , this is my preliminary observation from the error .

Quick way to check currency conversion is ,Use following function in SQL Editor

SELECT CONVERT_CURRENCY(amount=>1, "SOURCE_UNIT_COLUMN" =>'EUR',

"SCHEMA" => 'YOUR SCHEMA',

"TARGET_UNIT_COLUMN" => 'HKD',

"REFERENCE_DATE" =>'2017-06-28',

"ERROR_HANDLING"=>'fail', "CLIENT" => '010') as converted_value FROM DUMMY;

[jyoti_senapati]

Hi Anirudda,

I have tried above SQL in the Console but it is also showing the error . 😞

Regards,

Jyoti