How To Fix RSRTS_CDS006 - Select option cannot be created; condition is too complex

RSRTS_CDS006 - Overview

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 006

• Message text: Select option cannot be created; condition is too complex

What causes this issue?

The CDS View contains a condition which cannot be converted into a
select option table.

System Response

Generation of BW Query based on this CDS View will result in an error

How to fix this error?

To support conversion of the condition into a select option table, you
must comply with the following rules:
Combine conditions for different elements with AND
Combine negated conditions for any element with AND
Combine conditions for same elements with OR (unless NOT is used)
Only use parentheses for OR expressions (enforcing OR to be evaluated
prior to AND)
Example: ( sales_region = 'SOUTH' OR sales_region = 'WEST' ) AND
( product_category = 'CAT29' OR product_category between 'CAT01'
and 'CAT20' ) AND NOT product_category = 'CAT17'

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRTS_CDS006 - Select option cannot be created; condition is too complex ?

  The SAP error message RSRTS_CDS006 indicates that a select option cannot be created because the condition defined in the query is too complex. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when working with queries that involve complex conditions or filters.
  
  Cause:
  
  Complex Conditions: The query may have too many conditions or filters that exceed the system's limitations for processing.
  Data Source Limitations: The underlying data source (like a CDS view or InfoProvider) may have restrictions on the complexity of the conditions that can be applied.
  Performance Issues: The complexity of the query may lead to performance issues, prompting the system to restrict the creation of certain select options.
  
  
  Solution:
  
  
  Simplify the Query: Review the query and try to simplify the conditions. This may involve:
  
  Reducing the number of filters.
  Combining similar conditions.
  Breaking down complex conditions into simpler ones.
  
  
  
  Use Variables: Instead of using multiple static filters, consider using variables that can dynamically