Currency Conversion in SQL Scripted view - features disabled ?

[Former Member]

Hi ,

We are trying to do currency conversion on measures in a SQL scripted calculation view in HANA (SPS10 and SPS11). We have all the required tables (TCURR , TCURC etc)  in the required schema.

The Decimal shift and Currency options are disabled in SQL scripted HANA view where as I am able to see them in Graphical Calculation view .  Is there any parameter I have to turn on to enable these options in SQL scripted view? Please find below the screenshots of the issue I am facing. Any thoughts?

On a measure present in Scripted view :

In Graphical view:

Regards,

Sindhoora

[Former Member]

Hi Sindhoora,

As far as I know currency conversion not supported in script based calculation view, but you can achieve the same in Graphical Calculation view.

Regards,

Shireesha

[Ibrahem]

Currency conversion is do supported in SQLScript Calculation view

SELECT CONVERT_CURRENCY(amount=>price, 
  "SOURCE_UNIT_COLUMN" =>source_unit,
  "SCHEMA" => 'SYSTEM',
  "TARGET_UNIT_COLUMN" => target_unit,
  "REFERENCE_DATE" =>'2013-09-23',
  "ERROR_HANDLING"=>'set to null',
  "CLIENT" => '000') as converted
  FROM sample_input;

CONVERT_CURRENCY - SAP HANA SQL and System Views Reference - SAP Library

[Former Member]

Thank you Ibrahem , Will try this and let you know.

[Ibrahem]

I believe this link will help