Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Analytical App: Search Table Error, Currency Conversion Error in TotalAccountsReceivableQuery

Hi experts,

We are getting the below error when executing the query for TotalAccountsReceivableQuery in HANA Studio.

Could not execute 'select * from "_SYS_BIC"."sap.hba.r.sfin700/TotalAccountsReceivableQuery"' in 1.129 seconds .

SAP DBTech JDBC: [2048]: column store error: search table error:  [2620] executor: plan operation failed;currency/unit conversion error,Conversion( "NetDueIntvl1AmtInDspCrcy_E", "NetDueIntvl2AmtInDspCrcy_E", "NetDueIntvl4AmtInDspCrcy_E", "NetDueIntvl3AmtInDspCrcy_E", "TotalNotOvrdAmtInDspCrcy_E", "TotalOverdueAmtInDspCrcy_E" ), row 128: could not determine valid conversion rate for value(s) 17535, 0, 0, 0, 0, 17535 from unit 'EUR' to unit 'USD' on date 2015-04-10 00:00:00.0000000

Can you please suggest what could be the reason?



Not what you were looking for? View more on this topic or Ask a question