Skip to Content
0

Error in Currency Conversion in HANA Calculation View

Oct 20, 2017 at 02:13 PM

160

avatar image

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

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

1 Answer

ANIRUDDHA SHINDE Oct 25, 2017 at 05:17 AM
0

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;

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Anirudda,

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

Regards,

Jyoti

0