How To Fix FDT_EXPRESSIONS119 - Usage of boolean constant in row &1/column &2 is not useful

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 119

• Message text: Usage of boolean constant in row &1/column &2 is not useful

What causes this issue?

A boolean constant is used in a condition cell. However, using boolean
constants in condition cells is not useful:
If the constant value is 'FALSE', the line will never match and
therefore never return a result.
If the constant value is 'TRUE', the line will always match and return a
result. This is equivalent to having an empty cell. An empty cell is not
taken into consideration when the line is evaluated. Therefore, empty
cells are always 'TRUE'.

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?

Reconsider the desired behavior of the application and change the
condition accordingly. Maybe using an expression that yields a boolean
result for the condition cell will better suit the intended behavior.
You can accomplish this easily by assigning a boolean value with the
<ZH>Direct Value Input</> command from the cell context menu.

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_EXPRESSIONS119 - Usage of boolean constant in row &1/column &2 is not useful ?

  The SAP error message FDT_EXPRESSIONS119 indicates that there is a usage of a boolean constant in a specific row and column of a data expression that is deemed not useful. 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 arises when a boolean constant (true/false) is used in a way that does not contribute to the logic of the expression. For example, if you have an expression that evaluates to a boolean value but the constant does not affect the outcome, it is considered redundant. This can happen in various scenarios, such as:
  
  Using a boolean constant in a condition that is always true or always false.
  Including a boolean constant in a calculation or expression where it does not change the result.
  
  
  Solution:
  To resolve this error, you should review the expression in the specified row and column. Here are