on 11-06-2014 2:00 PM
Hi all,
can you please see the give example for CE_CONVERSION
T1=CE_COLUMN_TABLE("HANAUSER"."CE1IDEA",["FRWAE","VV010","WADAT"]);
var_out=CE_CONVERSION(:T1, [family = 'currency',
method = 'ERP', client = '800',
conversion_type = 'M', target_unit = 'EUR',
source_unit_column = " FRWAE",
reference_date = '1900-01-01',
SCHEMA="HANAUSER",
output_unit_column = "TRGCUR"]);
when doing this i am facing issues AP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;currency/unit conversion error,Conversion( "VV010" ), row 0: could not determine valid conversion rate for value(s) 642.6 from unit 'USD' to unit 'INR' on date 1900-01-01 00:00:00.0000
I am facing the same issues, were u able to solve it ?
Thanks
Jethendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jethendra,
Please check below thread and KBA
BR
AKJ
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.