How To Fix FDT_EXPRESSIONS069 - The pattern used in the range comparison does not contain any wildcards

FDT_EXPRESSIONS069 - Overview

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 069

• Message text: The pattern used in the range comparison does not contain any wildcards

What causes this issue?

For the current range expression, you have defined a value comparison
which uses one of the following comparison operations:
matches pattern
does not match pattern
Usage of these comparison operations is only useful if the test value
against which you want to compare the input data does contain one or
more wildcard characters ('*' for any number of characters, '+' for
exactly one character). However, the test value does not contain any
wildcards. As a consequence, incoming data would satisfy the range
condition only if they are identical with the test value.
Although such a range definition is not an error, it will lead to a
system behavior which is exactly the same as it would be with the 'is
equal to'/'is not equal to' operations. The only difference is that the
equality comparison can be performed much faster by the system.

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?

Check if the current range definition meets the requirements of your use
case. Depending on the result, do one of the following:
If you are interested only in input data that are identical to your test
value, use the equality operations instead.
If you want the system to do a pattern comparison, change the test value
by replacing static text by wildcards where appropriate.

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 FDT_EXPRESSIONS069 - The pattern used in the range comparison does not contain any wildcards ?

  The SAP error message FDT_EXPRESSIONS069 indicates that there is an issue with a range comparison in a field that is expected to use wildcards, but none were provided. This error typically occurs in the context of using the SAP Fiori Design Time (FDT) or in scenarios involving expressions and conditions in SAP applications.
  
  Cause:
  The error arises when a range comparison is performed without the necessary wildcards. In SAP, wildcards (like * for multiple characters or ? for a single character) are often used in string comparisons to allow for flexible matching. If a range comparison is defined without these wildcards, the system cannot interpret the comparison correctly, leading to this error.
  
  Solution:
  To resolve this error, you should:
  
  
  Check the Expression: Review the expression or condition that is causing the error. Ensure that any string comparisons that are meant to be flexible include the appropriate wildcards.
  
  
  Modify the Range: If you are using a range