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

SAP Error Message - Details

• 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 comparison, ensure that the values in the range are correctly defined with wildcards where necessary. For example, if you are checking for a pattern, you might need to change value to value* or *value* depending on your requirements.
  
  
  Test the Changes: After making the necessary adjustments, test the changes to ensure that the error no longer occurs and that the logic behaves as expected.
  
  
  Consult Documentation: If you are unsure about how to implement wildcards in your specific scenario, refer to the SAP documentation or help resources related to the FDT or the specific module you are working with.
  
  
  Related Information:
  
  Wildcards in SAP: Understanding how wildcards work in SAP can help prevent similar errors. The * wildcard represents any number of characters, while ? represents a single character.
  SAP Fiori and FDT: Familiarize yourself with the Fiori Design Time (FDT) environment, as it often involves creating expressions and conditions that may require specific syntax and formatting.
  Debugging: If the error persists, consider using debugging tools within SAP to trace the execution and identify where the expression is failing.
  
  By following these steps, you should be able to resolve the FDT_EXPRESSIONS069 error and ensure that your range comparisons are correctly defined.