How To Fix AQ_AD_HOC802 - Some selection fields are not available

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 802

• Message text: Some selection fields are not available

What causes this issue?

You opened a query when the object selection was switched on. The
query contains selection fields that are not supported by the object
selection unterstntzt werden.

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

System Response

The fields affected are not available for selection.

How to fix this error?

If you accept this restriction, you may continue. If not, you should
switch off the object selection and open the query again. You can then
select according to all fields. However, the object selection options
(for example, compiling a hitlist, restricting reporting sets, and so
on) are no longer available.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message AQ_AD_HOC802 - Some selection fields are not available ?

  The SAP error message AQ_AD_HOC802, which states "Some selection fields are not available," typically occurs in the context of using the SAP Query or Ad Hoc Query tools. This error indicates that certain fields you are trying to use in your selection criteria are not available for the query you are attempting to execute. Here are some potential causes, solutions, and related information:
  Causes:
  
  Field Availability: The fields you are trying to select may not be part of the data source or the InfoSet you are using for your query.
  Authorization Issues: You may not have the necessary authorizations to access certain fields in the database.
  Data Source Changes: The underlying data structure may have changed (e.g., fields were removed or renamed) since the query was last saved or executed.
  Query Configuration: The query may not be properly configured to include the fields you want to use.
  
  Solutions:
  
  
  Check Field Availability:
  
  Verify that the fields you are trying to use are indeed part of the InfoSet or data source you are querying. You can do this by checking the InfoSet definition in transaction SQ02 or the relevant data source.
  
  
  
  Review Authorizations:
  
  Ensure that you have the necessary authorizations to access the fields in question. You may need to consult with your SAP security team to verify your access rights.
  
  
  
  Update the Query:
  
  If the data structure has changed, you may need to update your query. Go to transaction SQ01, select your query, and check the field list to ensure all required fields are included.
  
  
  
  Recreate the Query:
  
  If the query is significantly outdated or misconfigured, consider recreating it from scratch using the current InfoSet.
  
  
  
  Check for Filters:
  
  Sometimes, filters applied to the query can restrict the visibility of certain fields. Review any filters that may be in place.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for more detailed information on the specific query or data source you are working with.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  SQ01: Query Management
  SQ02: InfoSet Query
  SQ03: User Groups for Queries
  
  
  
  SAP Notes: Check SAP Notes for any known issues or patches related to the AQ_AD_HOC802 error.
  
  
  Community Forums: Consider searching or posting in SAP community forums for additional insights from other users who may have encountered the same issue.
  
  
  By following these steps, you should be able to identify the cause of the AQ_AD_HOC802 error and implement a suitable solution.