cancel
Showing results for 
Search instead for 
Did you mean: 

how to do CE_CONVERSION

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

jethendra_ravi2
Explorer
0 Kudos

I am facing the same issues, were u able to solve it ?

Thanks

Jethendra

AtulKumarJain
Active Contributor