How To Fix FDT_EXPRESSIONS482 - Types do not match for 'Is between/Is not between' comparisons

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 482

• Message text: Types do not match for 'Is between/Is not between' comparisons

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 and the high value of the range
are not of the same type. This is not allowed.
A possible example of this problem could be if you have inadvertently
assigned a number and an amount as low and high value of a range serving
as comparison parameter. Here, the system would not extract the number
part from the amount. Rather, it would simply determine that the
involved data types are not the same and send a warning message.

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 they are referring to the same data type.

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_EXPRESSIONS482 - Types do not match for 'Is between/Is not between' comparisons ?

  The SAP error message FDT_EXPRESSIONS482 indicates that there is a type mismatch in a comparison operation, specifically when using the "Is between" or "Is not between" expressions in a formula or expression within the SAP system. This typically occurs in the context of SAP's Flexible Data Import (FDI) or similar data processing scenarios where data types must be compatible for comparisons.
  Cause:
  The error arises when the data types of the values being compared do not match. For example, if you are trying to compare a string with a number, or a date with a string, the system will throw this error because it cannot logically evaluate the comparison.
  Solution:
  To resolve this error, you should ensure that the data types of the values being compared are compatible. Here are some steps you can take:
  
  
  Check Data Types: Review the data types of the fields or variables involved in the comparison. Ensure that they are of the same type (e.g., both should be integers, both should be strings, etc.).
  
  
  Type Conversion: If the data types do not match, consider converting one of the values to the appropriate type. For example:
  
  If comparing a string to a number, convert the string to a number using appropriate conversion functions.
  If comparing dates, ensure both values are in date format.
  
  
  
  Review Expression Logic: Double-check the logic of your expression. Ensure that the conditions you are trying to evaluate make sense and that you are using the correct fields.
  
  
  Testing: After making changes, test the expression again to ensure that the error is resolved.
  
  
  Related Information:
  
  SAP Documentation: Refer to the official SAP documentation for more details on data types and expressions in the context of the specific module you are working with.
  Data Type Compatibility: Familiarize yourself with the data types supported by SAP and their compatibility rules.
  Debugging Tools: Use debugging tools available in SAP to trace the execution of your expressions and identify where the type mismatch occurs.
  
  By ensuring that the data types are compatible and making necessary adjustments, you should be able to resolve the FDT_EXPRESSIONS482 error.