3520699 - No data available in Fiori App Sales Volume - Detailed analysis(F2235)

An issue arises in the Sales Volume App (F2235) where no data is available. SQL Error 719 occurs on this GET request:

Log-dbg.js:452 xxxx-xx-xx xx:xx:xx.242100 Request failed with status code 400: GET C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results?sap-client=800&$skip=0&$top=3&$orderby=BillingDocumentDateYear%20desc&$select=SlsVolumeNetAmtInDspCrcy%2cDisplayCurrency%2cBillingDocumentDateYear%2cBillingDocumentDateYear_T&ssbMainTileType=CT - [{"code":"BRAIN/289","message":"Error while reading data; navigation is possible","persistent":false,"targets":["/C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results"],"type":"Error"},{"code":"DBMAN/305","message":"Error reading the data of InfoProvider 2CISDSLSVOLBYYEAR","persistent":false,"targets":["/C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results"],"type":"Error"},{"code":"RS_EXCEPTION/000","message":"e valid conversion rate for value(s) XXX from unit 'CurrencyB' to unit 'CurrencyA' on date XXXX-XX-XX 00:00:00.0000000 for client 'XXX'","persistent":false,"targets":["/C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results"],"type":"Error"},{"code":"RS_EXCEPTION/000","message":"Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( \"COL$0$\" ), row 13: could not ...","persistent":false,"targets":["/C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results"],"type":"Error"},{"code":"BW_BICS/011","message":"The result set does not contain any relevant data","persistent":false,"targets":["/C_SALESVOLUMEBYYEARQUERY(P_DisplayCurrency=%27CurrencyA%27,P_ExchangeRateType=%27M%27)/Results"],"type":"Information"}] sap.ui.model.odata.ODataMessageParser

• SAP S/4HANA

SAP S/4HANA, Sales Volume App, F2235, ODATA services, no data, SAP note 3385155, C_SALESVOLUMEANALYTICSQRY, Class CL_SDM_SDSLS_VBRP, issue. , KBA , SD-FIO-HBA , Analytical Apps , Problem