How To Fix FDT_EXPRESSIONS098 - Case sensitivity has no effect on "contains (no) string" operations

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 098

• Message text: Case sensitivity has no effect on "contains (no) string" operations

What causes this issue?

For this value range expression, the operation type has been defined
either as 'contains string' or 'does not contain string'. In addition,
you have selected the 'Case sensitive' flag. However, for technical
reasons the string containment operations are always carried out as
case-insensitive by the system, regardless of the setting of this flag.

System Response

The system will not discriminate between upper or lower case strings
when the expression is evaluated.

How to fix this error?

If it is crucial for your use case to let the system behave differently
depending on the capitalization of strings, you will have to remodel the
application so that upper and lower case strings can be treated
differently. For example, this can be accomplished by using the
'equals' operations.

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_EXPRESSIONS098 - Case sensitivity has no effect on "contains (no) string" operations ?

  The SAP error message FDT_EXPRESSIONS098 indicates that there is an issue related to case sensitivity in string operations, specifically when using the "contains" or "does not contain" string functions in the context of the SAP Fiori Design Time (FDT) or similar environments.
  Cause:
  The error arises because the "contains" and "does not contain" operations in the context of the FDT are case insensitive. This means that when you are checking if a string contains another string, the operation does not differentiate between uppercase and lowercase letters. If your logic or expressions are expecting case sensitivity, this can lead to unexpected results or errors.
  Solution:
  To resolve this error, you should ensure that your string comparisons are designed with the understanding that these operations are case insensitive. Here are some steps you can take:
  
  
  Review Your Expressions: Check the expressions where you are using "contains" or "does not contain" to ensure that you are not relying on case sensitivity.
  
  
  Use Lower/Upper Functions: If you need to perform case-sensitive comparisons, consider converting both strings to either lower case or upper case using functions like LOWER() or UPPER(). For example:
  LOWER(field_name) CONTAINS LOWER('search_string')
  
  
  Adjust Logic: If your application logic requires case sensitivity, you may need to implement additional logic to handle this, such as using regular expressions or other string manipulation techniques that respect case.
  
  
  Testing: After making changes, thoroughly test your expressions to ensure they behave as expected under various scenarios.
  
  
  Related Information:
  
  Documentation: Refer to the SAP documentation for the specific version you are using to understand the behavior of string operations in FDT.
  Community Forums: Check SAP community forums or support channels for similar issues and solutions shared by other users.
  SAP Notes: Look for any relevant SAP Notes that might address this specific error or provide additional context.
  
  By understanding the case insensitivity of the "contains" operations and adjusting your expressions accordingly, you should be able to resolve the FDT_EXPRESSIONS098 error effectively.