Skip to Content
0
Jun 09, 2014 at 09:34 PM

CONVERT_CURRENCY IN SELECT NOT EXECUTING

249 Views

I am trying to execute the following query.

select productid, category,
  CONVERT_CURRENCY("AMOUNT"=> price,
  "SOURCE_UNIT_COLUMN"=> currency,
  "SCHEMA" => 'SAP_HANA_DEMO',
  "TARGET_UNIT_COLUMN"=> currency,
  "REFERENCE_DATE"=> '2013-09-23',
  "CLIENT"=>'000'
  ) as "afterconver"
from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::EPM.MasterData.Products";

I am getting the below error.


SAP DBTech JDBC: [2048]: column store error: # required attributes: 5, # attributes in itab: 5, requested column index: 5 at function __copy_trex_field_NString__()

Appreciate all the help.

Thanks.