SHINE: Error: SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;currency/unit conversion error,Conversion

[Former Member]

Hi experts

We have built an analytic view on top of table sap.hana.democontent.epm.data::PO.Header.

The calculated column has been defined with two input Parameters, one for the date and the other for the target currency.

Important: Table PO.Header have only EUR as source currency for its transactional records.

Executing the query on this view results in an error message:

Why is there a check on currencies like CNY which are not source currencies in the PO.Header table?

If you select EUR as fixed source currency in the calculated column for the conversion you don't get the error message.

Any ideas how to successfully implement the dynamic way with field "Currency" as column type from the facts of PO.Header in the view?

Thanks

J.

[Former Member · Accepted solution]

resolved by SAP note: https://launchpad.support.sap.com/#/notes/2362127/E