How To Fix DB670 - No range allowed for generic entries

DB670 - Overview

• Message type: E = Error

• Message class: DB - Messages for logical databases and background processing

• Message number: 670

• Message text: No range allowed for generic entries

What causes this issue?

You have selected the <LS>CP</> (Contains Pattern) option and specified
a pattern in the <LS>To</> field.

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?

With <LS>CP</>, you should specify only one pattern (in the <LS>From</>
field).

Error message extract from SAP system. Copyright SAP SE.

DB670 - Details

• The SAP error message DB670 "No range allowed for generic entries" typically occurs when you are trying to execute a database operation that involves a generic entry (like a wildcard search) but the system does not allow ranges for that type of entry. This can happen in various scenarios, such as when using selection criteria in reports or queries.
  
  Cause:
  
  Generic Entries: The error arises when a generic entry (like a wildcard) is used in a context where a range is not permitted. For example, if you are trying to filter data using a wildcard character (like % or *) in a field that does not support it.
  Incorrect Selection Criteria: The selection criteria defined in your query or report may be incorrectly set up, leading to the system interpreting it as a range when it should not be.
  Database Constraints: Some database tables or fields may have constraints that do not allow for