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 currency conversion. This can be done by:
  
  Using a currency conversion function in your query.
  Ensuring that the relevant exchange rates are available in the system.
  
  
  Modify the Query: If you are using a custom query or report, modify it to either filter out the different currencies or convert them to a common currency before aggregation.
  Check Data Source: Ensure that the data sources being used are configured correctly and that they are pulling data in a consistent currency.
  
  Related Information:
  
  Currency Configuration in SAP: Familiarize yourself with how currencies are configured in your SAP system, including the use of currency types and exchange rates.
  SAP Documentation: Refer to SAP Help documentation for more details on handling currency in reports and queries.
  Transaction Codes: You may want to check transaction codes like OB08 (for maintaining exchange rates) or other relevant transaction codes that deal with currency settings.
  Consult with SAP Support: If the issue persists, consider reaching out to SAP support or your internal SAP team for further assistance.
  
  By addressing the currency mismatch and ensuring that all fields are in the same currency or properly converted, you should be able to resolve the AQ_AD_HOC064 error.