SAP Knowledge Base Article - Preview

3675805 - Lookup Table with ranges are not returning value.

Symptom

  • There is a Lookup Table with the dimensions arranged.
  • This Lookup Table is referenced by a rule or formula.
  • When the pipeline runs and should generate a value using the Lookup Table, the value is not generated.
  • In the Worker log, when run with advanced logs for SQL and Verbose, the following error was found:
    • "Could not perform Value operation: add, because at least one of the values involved (null,<VALUE>) is null"

* The <NULL> value is the same used on the MDLT function, during the rule evaluation.


Read more...

Environment

SAP SuccessFactors Sales Performance Management

  • Incentive Management



Product

SAP SuccessFactors Incentive Management 2025 ; SAP SuccessFactors Incentive Management on hyperscalers 1.0

Keywords

lookup table, credits, incentives, not being generated, formula, MDLT, range, High value, Low value. , KBA , CEC-SAL-COM-PIP , Pipeline Runs and Calculations , CEC-SAL-COM , SuccessFactors Incentive Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.