How To Fix FDT_EXPRESSIONS017 - Invalid range parameters defined for 'Is ( Not ) Between' comparison

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 017

• Message text: Invalid range parameters defined for 'Is ( Not ) Between' comparison

What causes this issue?

You have defined a comparison of type "is between" or "is not between"
where the incoming test parameter is compared against a range between a
low and a high value. However, the low value cannot be greater than or
equal to the high value. This is not allowed.

System Response

The expression containing the comparison cannot be activated.

How to fix this error?

Check the low and high value of the range serving as comparison
parameter and make sure that the high value is greater than the low
value.

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 FDT_EXPRESSIONS017 - Invalid range parameters defined for 'Is ( Not ) Between' comparison ?

  The SAP error message FDT_EXPRESSIONS017 indicates that there is an issue with the range parameters defined for a comparison operation using the "Is (Not) Between" condition in a formula or expression. This typically occurs in the context of SAP's Flexible Data Import (FDI) or similar data processing scenarios where expressions are evaluated.
  Cause:
  The error is caused by one or more of the following issues:
  
  Invalid Range Values: The lower and upper bounds of the range are not defined correctly. For example, the lower bound may be greater than the upper bound.
  Data Type Mismatch: The data types of the values being compared may not be compatible. For instance, comparing a string with a number.
  Null or Empty Values: One or both of the range parameters may be null or empty, which is not allowed for a "Between" comparison.
  Incorrect Syntax: There may be a syntax error in how the expression is written.
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Check Range Values: Ensure that the lower and upper bounds of the range are defined correctly. The lower bound should always be less than or equal to the upper bound.
  
  Example: If you have Is Between 10 and 5, this is invalid. It should be Is Between 5 and 10.
  
  
  
  Verify Data Types: Make sure that the data types of the values being compared are compatible. If you are comparing numbers, ensure both values are numeric.
  
  
  Handle Null or Empty Values: Ensure that both range parameters are populated with valid values. If necessary, add checks to handle null or empty values before performing the comparison.
  
  
  Review Syntax: Double-check the syntax of your expression to ensure it adheres to the expected format. Refer to the documentation for the correct syntax for "Is (Not) Between" comparisons.
  
  
  Testing: After making the necessary adjustments, test the expression again to ensure that it evaluates correctly without errors.
  
  
  Related Information:
  
  Documentation: Refer to the SAP documentation for Flexible Data Import or the specific module you are working with for more details on expression syntax and valid data types.
  Debugging Tools: Use debugging tools available in SAP to trace the execution of the expression and identify where the error occurs.
  Community Forums: If the issue persists, consider reaching out to SAP community forums or support for additional assistance.
  
  By following these steps, you should be able to identify and resolve the cause of the FDT_EXPRESSIONS017 error in your SAP environment.