SAP Knowledge Base Article - Public

2560028 - Lookup Rule Function Doesn't Consider Future Dated Records


While using a Lookup() function in the rule, the condition Effective Date has 2 options to select i.e "today" or "System Context.Effective Date".

System Context.Effective Date option doesn't consider the future effective date.



SAP Successfactors Employee Central - Global Benefits

Reproducing the Issue

  • Consider there are 2 benefits: Medical Insurance and Life Insurance.
  • Customer's requirement is that Employee should be allowed to enroll only one of these two benefits. So eligibility rule will check if one of the benefits is already enrolled (May be effective from future) the other one will be ineligible.
  • Most of the cases, benefits are effective from some future date/ period. So it is expected to determine the future enrolment record by looking up for future date. But currently in rule we can only fetch the records effective as of today.


This is expected behaviour currently. The system behavior is that it always fetches the current record that is effective as of today and doesn't consider the future dates.

The Product Management has confirmed that this is an enhancement.

Currently the Enhancement has no fix date, and is currently in discussion. You can track the release of this Enhancement by checking the release notes in each release for BEN-666.

Please reach out to your CSM if tracking of BEN-666 is required.


Rule System Context.Effective Date Lookup Effective BEN-666 Today , KBA , LOD-SF-EC-RUL , Business Rules & Event Derivation , Problem


SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Core 1711