SAP Knowledge Base Article - Public

3049816 - Display Currency not Working as Expected in Migrated Data

Symptom

Opportunities that were migrated from different tenant via data work bench do not show the correct currency in reports according to the Display Currency set in the selection screen

Environment

Cloud for Customer

Reproducing the Issue

  1. Goto Business Analytics Work Center
  2. Design Reports>Opportunity Analysis
  3. Open any view and selection, execute the report
  4. Add Opportunity field to rows 
  5. Set the currency in display currency under selection screen

Some of the opportunites does not show expected Values key figure as display currency set

Cause

The Org Unit of the company is not flagged during migration leading to these inconsistencies.

Resolution

The option to adjust the currency is to do a dummy change of the Expected Value which leads to redetermination of the currency. For mass change, this can be done using the Data Workbench. Here are the main steps:


1. Maintain the import csv file: enter a different expected value for all relevant opportunities
2. Run Data Workbench update for the opportunity using known IDs on the Workcenter Data Workbench. 
3. If the Expected Values shall be changed back, just repeat the above steps ( but with the right Expected Values in the csv file which you are importing

Keywords

Expected value, Opportunities, Display Currecny , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer core applications all versions