How To Fix FDT_EXPRESSIONS139 - Mandatory input missing in row &1/column &2

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 139

• Message text: Mandatory input missing in row &1/column &2

What causes this issue?

In row &v1& of the decision table, no value has been predefined for
column &v2& against which input data should be compared. However, this
column has been flagged as 'input mandatory'.

System Response

The decision table cannot be activated.

How to fix this error?

Proceed as follows to solve the problem:
If a value is required in column &v2& for the decision table to
calculate a result, enter the missing value.
If a value is not required, remove the 'mandatory' flag for the column.

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_EXPRESSIONS139 - Mandatory input missing in row &1/column &2 ?

  The SAP error message FDT_EXPRESSIONS139 indicates that there is a mandatory input missing in a specific row and column of a data entry or configuration process. This error typically occurs in the context of using SAP's Flexible Data Import (FDI) or similar data processing tools where certain fields are required for the operation to proceed.
  Cause:
  
  Missing Mandatory Fields: The most common cause of this error is that a required field in the data entry form or configuration is left blank. This could be due to user oversight or incorrect data mapping.
  Incorrect Data Format: Sometimes, even if a field is filled, if the data format does not meet the expected criteria (e.g., date format, numeric values), it may trigger this error.
  Configuration Issues: If the system configuration does not align with the data being processed, it may lead to missing mandatory inputs.
  
  Solution:
  
  Check Required Fields: Review the data entry form or configuration settings to ensure that all mandatory fields are filled out correctly. Look for any indicators (like asterisks) that denote required fields.
  Validate Data Format: Ensure that the data entered in the fields meets the expected format. For example, if a date is required, it should be in the correct date format.
  Review Mapping: If you are importing data, check the mapping of the source data to the target fields in SAP. Ensure that all required fields in SAP are being populated from the source.
  Consult Documentation: Refer to the relevant SAP documentation or help files for the specific transaction or process you are working with to understand which fields are mandatory.
  Error Log Review: If available, check the error logs or messages for additional context that might help identify the specific row and column causing the issue.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Transaction Codes: Familiarize yourself with the transaction codes related to the data entry or import process you are working on, as they may have specific requirements.
  User Forums: Consider visiting SAP community forums or user groups where similar issues may have been discussed, providing insights or solutions from other users.
  
  By following these steps, you should be able to identify and resolve the issue causing the FDT_EXPRESSIONS139 error in SAP.