Currency Conversion is not working

[venkataramana_paidi]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[former_member42822]

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

[Ravi_Channe]

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

[Former Member]

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

[dionisio_ambrona]

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:

[dionisio_ambrona]

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

[Ravi_Channe]

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

[venkataramana_paidi]

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.

[Former Member]

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

[Ravi_Channe]

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

[venkataramana_paidi]

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.

[Ravi_Channe]

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

[venkataramana_paidi]

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.

[Former Member]

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,