3653016 - Currency/unit conversion error in Customer Data Browser app - SAP S/4HANA Cloud Public Edition

• Error occurs when attempting to preview data using the "Data Browser" button.
• The error message displayed is: "Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( 'COL$1$' ), row [X]: could not determine valid conversion rate for value(s) [Y] from."
• The same behavior is reproducible with both custom CDS views (based on I_STOCKQUANTITYCURRENTVALUE_2) and standard CDS views (e.g., I_STOCKQUANTITYCURRENTVALUE_2).

SAP S/4HANA Cloud Public Edition

1. Open the "Custom CDS Views" app in SAP S/4HANA Cloud Public Edition.
2. Search for the CDS view (e.g., YY1_XYZ based on I_STOCKQUANTITYCURRENTVALUE_2) and select it.
3. Click on the "Data Browser" or "Preview Data" button.
4. Set the display currency (P_DISPLAYCURRENCY) to ABC.
5. Observe that the system returns the error.

• The error occurs because currency exchange rates are not defined for all currencies present in the system. For example, documents with the currency EFD exist, but there is no defined exchange rate for EFD/ABC.

1. Verify the currencies present in the relevant data tables to identify any currencies without defined exchange rates.
2. Define the missing currency exchange rates in the system.
   1. Use the "Currency Exchange Rate" app to add the required exchange rates.
   2. Ensure that all currencies used in the data have valid exchange rates defined for the target display currency (e.g., ABC).

Currency Exchange Rate App

currency conversion error, unit conversion error, sql code 719, custom cds views, data browser error, preview data error, p_displaycurrency, ron, sap s/4hana cloud public edition, currency exchange rates, missing exchange rates, mxn/ron conversion, i_stockquantitycurrentvalue_2 , KBA , BC-SRV-APS-CDB , Customer Data Browser , Problem