SAP Knowledge Base Article - Public

2511541 - SAP Marketing Segmentation - Currency/Unit conversion Error

Symptom

In SAP Marketing Segmentation you want to use the 'Total Amount' or 'Amount' Filter of the 'Sales Data' attribute group. Instead of the preview an error related to 'Currency/Unit conversion Error' is displayed.

kba curr error.jpg

Environment

SAP Marketing Cloud Edition

Reproducing the Issue

  1. Log on to Fiori Launchpad in the SAP Marketing Cloud
  2. Create a new segmenation model
  3. Click on the 'Total Amount' attribute to display the preview

    total amount attribute.jpg
  4. Instead of the preview following SQL error is shown.

    preview error.jpg

Cause

This error is raised due to missing exchange rates required for currency conversion when retrieving sales related interactions with currencies other than the default currency.

Resolution

  1. Figure out affected currencies.
    In segmentation use the attribute 'currency' from the 'interactions' attribute group to preview all currencies used in any interaction:

    kba curr segment.jpg
  2. Make sure to have the exchange rates maintained for the default currency and all retrieved currencies.
    Access the 'Maintain Exchange Rates' app - the app is available in the business role template Administrator Marketing (SAP_BR_ADMINISTRATOR_MKT)

    kba curr maintain exchange rates tile

    Make sure that the exchange rate is maintained for all currencies.

    kba curr maintain exchange rates.jpg

    When looking at the example from the currency segment, the currency ZAR is maintained in the app, so won't cause any issues. For the currency FRF however there are no exchange rates maintained, this will therefore cause the SQL error.

Keywords

SQL error in segmentation (ADBC);  SQL-Fehler bei Segmentierung (ADBC); currency/unit conversion error; could not determine valid conversion rate for value Segmentation; Total Amount; Sales Data; Currency; Currency Exchange Rates; Interactions; Segmentierung; Gesamtbetrag; Verkaufsdaten; Währung; Umrechnungskurse pflegen; Interaktionen; , KBA , CEC-MKT-SEG , Segmentation , CEC-MKT-BF , Basic Functions , Problem

Product

SAP S/4HANA Cloud 1705 ; SAP S/4HANA Cloud 1708 ; SAP S/4HANA Cloud 1711 ; SAP S/4HANA Cloud 1802 ; SAP S/4HANA Cloud 1805 ; SAP S/4HANA Cloud 1808