How To Fix /BCV/QRM679 - Query &1: No reference field was entered for currency field &2

SAP Error Message - Details

• Message type: E = Error

• Message class: /BCV/QRM -

• Message number: 679

• Message text: Query &1: No reference field was entered for currency field &2

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message /BCV/QRM679 - Query &1: No reference field was entered for currency field &2 ?

  The SAP error message /BCV/QRM679 indicates that there is an issue with a query where a reference field has not been specified for a currency field. This typically occurs in the context of queries or reports that involve currency values, and it is essential for the system to know which reference field to use for currency conversion or comparison.
  Cause:
  The error is caused by the absence of a reference field for a currency field in the query definition. In SAP, when dealing with currency fields, the system needs to know which field to use as a reference for currency conversion or to determine the currency context. If this reference field is not specified, the system cannot process the query correctly, leading to this error message.
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Check Query Definition: Go to the query definition in the SAP system where the error occurred. Look for the currency field that is causing the issue.
  
  
  Specify Reference Field: Ensure that a reference field is specified for the currency field. This could be a field that indicates the currency type or a related field that provides context for the currency value.
  
  
  Adjust Query Settings: If you are using a query tool (like SAP Query or InfoSet Query), check the settings and ensure that all necessary fields, including reference fields for currency, are included in the query.
  
  
  Test the Query: After making the necessary adjustments, test the query again to see if the error persists. If it does, double-check the configuration and ensure that all required fields are correctly set up.
  
  
  Consult Documentation: If you are unsure about which reference field to use, consult the SAP documentation or reach out to your SAP support team for guidance on the specific query and currency fields involved.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional context on handling currency fields in queries.
  Transaction Codes: Familiarize yourself with transaction codes related to query management, such as SQ01 (SAP Query) or SQ02 (InfoSet Query), to navigate and modify queries effectively.
  Currency Configuration: Review the configuration of currency types in your SAP system to ensure that they are set up correctly and that all necessary reference fields are available.
  
  By following these steps, you should be able to resolve the error and successfully run your query.