Currency conversion

dataservices sap-erp-bw
1

Hi

I am using Data Services 12.2.3.3 to import data from an SAP ERP system table. I want to convert currency when I import, to do this I am using CONVERT_TO_LOCAL_CURRENCY inside an ABAP data flow to create a new output column. When I validate this inside Data Services designer I get:

[Query:QRY_ZORDERREPDET]
Invalid mapping expression for column <QRY_ZORDERREPDET.OPNVALLC>. Additional information: <Cannot parse expression.

For the call to function <CONVERT_TO_LOCAL_CURRENCY>, cannot convert parameter number <3> to type . Please provide a parameter of the correct type… (BODI-1112351)>. (BODI-1111081)

This objects to the foreign amount field, which is a decimal(15,3) on the input table. When running this function on the ERP system it is happy with this same field an converts without problem. I have tested this running via Data Services with a hard coded varchar amount and the conversion works as correctly expected.

Any ideas greatly appreciated.

Regards

douglasCuts (BOB member since 2011-02-22)

2

Maybe cast the column as VARCHAR before that Query Transform by adding an other query transform and try.

ganeshxp :us: (BOB member since 2008-07-17)

3

Ganesh

Thank you that has sorted the issue out, your rapid help is much appreciated.

douglasCuts (BOB member since 2011-02-22)