Skip to Content

Error in Currency Conversion in HANA Calculation View

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2017 at 05:17 AM

    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;

    Add comment
    10|10000 characters needed characters exceeded