on 06-24-2015 4:54 AM
Hi all,
I am new to HANA. I have created a calculated column for currency conversion. I am trying to convert the Gross amount to EUR. The issue is the converted amount result currency column always shows ARS for all the rows. I am displaying the target currency in the column CONVERTED_CURRENCY for test purpose. As you can see below, the column ConvGrossAmount always shows ARS.
My calculated column definition is
SAP HANA studio
Version: 1.00.81.0
Internal Version: 1.81.2 (1812)
Thanks
R
My best bet here would be that the relevant ECC tables for the currency conversion hadn't been loaded.
You will find the details on this in the documentation.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
I did check the T* tables and i do have entries for the client 000, which i am using. To confirm this i set the "Upon Conversion Failure" to "Set to NULL" under semantics tab.Now the output looks fine. Looks like USD to EUR is available and getting converted and for the conversion errors it sets "?". Not sure why the "Ignore" option doesn't seem to work. Any thoughts?
Thanks.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.