SAP Knowledge Base Article - Public

3367932 - Unable to access Apps/Reports due to currency/unit conversion error.

Symptom

Error: Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( "COL$1$", "COL$5$" ).

Environment

SAP S/4HANA Cloud.

Reproducing the Issue

  1. Open App Credit Limit Utilization - Business Partner gt 80% Today.
  2. Press GO button.

Cause

For all the company codes group currency (currency type 30) is configured. Currency exchange rates are not configured for the pair From Company Code Currency to Group Currency.

ex. Company Code Currency (10) is THB for company code and USD is the Group Currency.

Resolution

Maintain currency exchange rates for currency pair. To view/maintain the currency exchange rates use App Currency Exchange Rates (App ID: F3616) help portal link

Keywords

F1751, currency, exchange, rate, 10, 30, group, currency, company code, currency, SQL code 719, Conversion( "COL$1$", "COL$5$" ), F3616 , KBA , FIN-FSCM-CR-2CL , Credit Management (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions