How To Fix FDT_EXPRESSIONS874 - Define result data object first to use "Return all matches found" mode

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 874

• Message text: Define result data object first to use "Return all matches found" mode

What causes this issue?

For the current decision table, you have tried to set the multiple match
mode by activating the "Return all matches found" option. However, the
system has determined that at current, no result data object has been
defined for the decision table. This is not permitted.

System Response

The "Return all matches found" option is deactivated by the system.

How to fix this error?

To use the "Return all matches found" option, define a result data
object of type table.
In general, a decision table without a result data object defined does
not make much sense. Therefore, we recommend defining a result data
object for the decision table.

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_EXPRESSIONS874 - Define result data object first to use "Return all matches found" mode ?

  The SAP error message FDT_EXPRESSIONS874 indicates that there is an issue with the configuration of a data object in the context of using the "Return all matches found" mode in the SAP Fiori Data Transformation (FDT) framework. This error typically arises when you attempt to use this mode without having defined a result data object.
  Cause:
  The error occurs because the "Return all matches found" mode requires a result data object to be defined. This mode is used when you want to retrieve multiple matches from a data source, but if the system does not know where to store these results (i.e., the result data object is not defined), it cannot proceed.
  Solution:
  To resolve this error, you need to define a result data object in your FDT configuration. Here are the steps to do this:
  
  
  Access the FDT Configuration:
  
  Go to the relevant FDT configuration area in your SAP system.
  
  
  
  Define a Result Data Object:
  
  Create or select a data object that will serve as the result container for the matches found.
  Ensure that this data object is properly configured to hold the expected results.
  
  
  
  Configure the Expression:
  
  In the expression where you are using the "Return all matches found" mode, ensure that you reference the newly defined result data object.
  
  
  
  Test the Configuration:
  
  After making the changes, test the configuration to ensure that the error no longer appears and that the expected results are returned.
  
  
  
  Related Information:
  
  FDT Framework: The FDT framework is used for data transformation and manipulation in SAP systems, allowing users to define how data is processed and transformed.
  Data Objects: In FDT, data objects are used to represent the data being processed. They can be input data objects (source) or result data objects (output).
  Error Handling: Always check the configuration settings and ensure that all required objects are defined before executing transformations that involve multiple matches.
  
  If you continue to experience issues after following these steps, consider consulting SAP documentation or reaching out to SAP support for further assistance.