How To Fix AQ_AD_HOC064 - The fields in the statistics contain different currencies

SAP Error Message - Details

• Message type: E = Error

• Message class: AQ_AD_HOC - SAP Query: Ad Hoc Query Messages

• Message number: 064

• Message text: The fields in the statistics contain different currencies

What causes this issue?

,,,,,,

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

The statistics or ranked list contain several curency fields. In the
SAP Query you can set a currency for each of the fields individually.
In the InfoSet Query you can set only one currency and only one unit
per statistic/ranked list. All the currency fields refer to this
currency, and all the quantity fields refer to this unit.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message AQ_AD_HOC064 - The fields in the statistics contain different currencies ?

  The SAP error message AQ_AD_HOC064 indicates that there is a mismatch in the currencies of the fields being used in a report or query. This typically occurs when you are trying to aggregate or compare financial data that is denominated in different currencies without proper conversion or handling.
  
  Cause:
  
  Different Currencies: The fields being analyzed or reported on have different currency types (e.g., one field is in USD while another is in EUR).
  Currency Conversion Not Applied: The system is unable to automatically convert the currencies for comparison or aggregation.
  Data Source Configuration: The data sources or tables being queried may not have consistent currency settings.
  
  
  Solution:
  
  Check Currency Settings: Review the fields involved in the report or query to ensure they are using the same currency. If they are not, you may need to adjust the query or report to ensure consistency.
  Currency Conversion: If you need to compare or aggregate data in different currencies, apply