Question Re: Currency Conversion is not working in Technology Q&A

Currency Conversion is not working

venkataramana_paidi — Mon, 02 Sep 2013 13:16:05 GMT

Hi ,

I am trying to use currency conversion functionality for one of the measures . I have imported the TCURR,TCURF,TCURN,TCURV and TCURX tables in SYSTEM schema and one more schema where my tables existed. But when I am trying to use currency converter for measure it is throwing the below error.

System tables for currency conversion is missing in the default schema

Please find the below screenshot for the error.

Please help me what is the problem , how can I use the currency conversion using TCURR tables.

Thanks & Regards,

Ramana.

Re: Currency Conversion is not working

Ravi_Channe — Mon, 02 Sep 2013 17:12:44 GMT

Hi Venkata,

Couple of things to check.

1) Check that the Default client at the Analytic View level or User level is defined with the same value as the client value in the Currency tables (column MANDT).

2) Please check the default schema is mapped to the same schema which contains the currency tables.

Regards,

Ravi

Re: Currency Conversion is not working

Former Member — Mon, 02 Sep 2013 17:36:24 GMT

Hi Ramana, to avoid getting that error message you first need to specify the Schema for Currency Conversion (that is basically the schema that contains the TCUR* tables) and Client for currency conversion (that is the client you would like to use to pull the info form the TCUR* tables) properties at the bottom of the screen you are showing.

Lucas

Re: Currency Conversion is not working

former_member42822 — Tue, 03 Sep 2013 03:45:20 GMT

Hi Ramana, try to set the SYSTEM schema in semantics node as per the attached pic. Then you should be able to see the tables.

regards,

Vinoth

Re: Currency Conversion is not working

Ravi_Channe — Tue, 03 Sep 2013 05:51:52 GMT

Hi Vinoth,

You should not be using SYSTEM schema for any application development related activities, It is meant to be the System Administrator user and should not be used for developing HANA models. That schema should not contain any application data (like currency tables) or any application master / transaction data.

Regards,

Ravi

Re: Currency Conversion is not working

venkataramana_paidi — Tue, 03 Sep 2013 08:52:26 GMT

Hi Ravi,

I down load the data from 800 client and i gave the client as 800. Schema also I gave the same . But I am getting the same error .

Please find the below screenshot.

Still I am getting the same error .

Please find the sample TCURR table data as shown below .

Please suggest me any other changes I have to make.

Thanks & Regards,

Ramana.

Re: Currency Conversion is not working

Former Member — Tue, 03 Sep 2013 12:47:00 GMT

Hi Ramana, you need to set the Schema for currency conversion and Client for currency conversion properties in the Currency conversion pop up screen:

Re: Currency Conversion is not working

Ravi_Channe — Tue, 03 Sep 2013 16:47:55 GMT

Hi Venkata,

Can you please try setting the default client at the user level (double click on user in Security -> Users and check the property session client. You can set the schema for conversion as mentioned by Lucas. I think that setting is missing in your definition. It may not pick up the tables from the Default schema, but will pick up from the Schema for Conversion.

Setting the client value at the KF level as mentioned below by Lucas will impact only that KF. If you have 10 KFs with currency conversion, then you will have to set it up 10 times. Setting it at User level will impact all the KFs in ALL the models.

But it will also help and override the default setting at the User and Model level.

Regards,

Ravi

Re: Currency Conversion is not working

venkataramana_paidi — Wed, 04 Sep 2013 08:02:48 GMT

Hi Ravi/Lucas ,

Thanks for your support. I have resolved that error by importing the table TCURC into SAP HANA. But now I am getting different error while retrieving the the data from analytical schema as shown below .

Error: SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;currency/unit conversion error,Conversion( "AMOUNT_GBP" ), row 0: could not determine valid conversion rate for value(s) 100 from unit 'USD' to unit 'GBP' on date 2006-01-03 00:00:00.0000000

In my TCURR table date 2006-01-03 is there . But I don't know why I am getting this error.

Please find the below screenshot for the TCURR table data .

Please find the below screenshot for the Currency conversion measure.

Please suggest me how to resolve this error.

Thanks& Regards,

Ramana.

Re: Currency Conversion is not working

Ravi_Channe — Wed, 04 Sep 2013 09:35:05 GMT

Can you please send the screenshot for the TCURR table. Please check if you have the data for conversion type 'M'.

Secondly, did you type in the values like USD and GBP. If so, please select them from the list available. I had faced an issue, when the "typed" values were not used for conversion, but when I selected the values from the dropdown / list, it worked.

Regards,

Ravi

Re: Currency Conversion is not working

venkataramana_paidi — Wed, 04 Sep 2013 10:41:26 GMT

Hi Ravi,

I Didn't type the currency names. I got it from list of values and selected from currency ,to currency and currency type. I types only conversion date.

Please find the below screenshot for sample TCURR table.

Thanks & Regards,

Ramana.

Re: Currency Conversion is not working

Former Member — Tue, 05 Aug 2014 21:45:33 GMT

Hello Venkata.

Did you solve this problem? I'm having the same issue and I verified all suggested solutions but still no luck.

Also I have a question regarding the dates coming from SAP, the field GDATU in the table TCURR has a different format that is not a DATE datatype and Data Services saves this as VARCHAR of lenght 8.

Can this be the reason why HANA cannot find the specific date for the conversion? How did you load the TCURR* tables into HANA??

Thanks in advance.

Re: Currency Conversion is not working

Former Member — Tue, 09 Sep 2014 05:37:22 GMT

HI Venkat ,

Yes, TCURR table has filed GDATU which is in different format than our usual date field of VARCHAR length 8. The GDATU field stores date after subtracting it from 99999999 (99999999-given date) . But this has no impact on the currency conversion in my understanding.

When you select the conversion date in the currency conversion , it still picks up the correct line from TCURR against the M rate exchange type .

Currency conversion from any to fixed or any to any is working fine for me.

However ,i am facing a rather peculiar issue and hopefully somebody can guide me on that.

If the entry is not found for a specific conversion date and M rate type for a given currency types , the analytical view is still picking up the conversion rate for given conversion date for given currency types but for a different exchange rate type !!!!

This results in wrong conversion .

Since upon conversion failure , i set to to null , instead of null , i am getting wrong conversion .

Anyone can help on this.

Re: Currency Conversion is not working

Former Member — Thu, 09 Oct 2014 14:54:03 GMT

Hello Sumit.

I faced the same problem and what I noticed is that it was taking the last or newest exchange rate available in the table, similar to what BW does with it's currency conversion.

For me this was fine but I had to create a calculated field to take the correct date so the view went to take a specific exchange rate, in case there was nothing there then it would take the newest available.

I hope this helps.

Regards.

Re: Currency Conversion is not working

Former Member — Tue, 02 Dec 2014 12:34:53 GMT

Hi All,

I am also facing the same error on currency conversion on HANA data maintained in TCURR table

but still it shows error like:

TCURR Table entries for this is like:

thanks and regards,

Manoj Kumar,

Re: Currency Conversion is not working

dionisio_ambrona — Fri, 08 Jan 2016 09:16:19 GMT

Hi experts,

I'm having the same problem ("System tables for currency conversion are missing in the schema") to set the exchange type for calculated currency conversion.

I am trying to choose the same schema of the TCUR* table properties as Lucas said. In my case, this is the _SYS_BIC schema (as system did not allow me to generate those tables in a different schema). But even when those tables appear inside _SYS_BIC schema in the screenshot, the system keeps telling that there are not currency conversions table in that schema.

I am trying to follow exercises of openSAP course "Next Steps in Software Development on SAP HANA" (course link https://open.sap.com/courses/hana2/items/4ivLcOzdNn4Kax1CZau91K file link Next Steps in Software Development on SAP HANA - Exercises / Solutions openSAP_HANA_2_Exercise_BuildingApplicationsWhichLeverageSAPHANA.pdf ).

I am using SAP HANA Cloud instance with Cloud cockpit and Eclipse as tools, not on-premise HANA nor Amazon Web Services nor HANA Studio, I know this could make a small difference, but even so I don't see why I get this error.

I have tried solutions proposed in this thread:

Currency tables: Using your own SCHEMA | SCN

as create tables as select, or create table synonyms, but these didn't work for me either, due to missing privilege to create synonyms or tables.

I even have public synonyms of the tables (I guess they were created when I did import the SHINE content in my SAP HANA Cloud Instance) but this does not work either.

Any ideas on what can be wrong?

Thanks!

Error screenshot is below:

Re: Currency Conversion is not working

dionisio_ambrona — Fri, 08 Jan 2016 12:16:04 GMT

Update: finally I managed to add the synonyms to my schema DEV_* by using context menu option "New synonym" on the EPM TCUR* tables in _SYS_BIC schema, and also changed the client 001 and this DEV_* schema on the view and on the currency calculation so now the Analytic view AN_PURCHASE_ORDERS at least works and I can display the data with a select statement in the SQL console