3641368 - [custom MDF] Lookup Function behaviors if multiple criterias added from same field but different values

This KBA explains the Lookup Function behaviors when multiple criteria were added from same field but different values in a custom MDF object business rules.

** Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental **  

• SAP SuccessFactors HCM Suite

Behaviors of Lookup Function when multiple criteria were added from same field but different values in a custom MDF object business rules.

Scenario 1: 

When in a lookup function, customer added multiple criterias using:

1. same field name 
2. the same operator - is equal to 
3. different values 

Only the first criteria was considered, the rest was ignored as a duplicates.This kind of rule configuration will be considered that both statements are validated by AND operator. Same field cannot have two different values at the same time.  (As this AND doesn’t show up in the UI customers might have configured such a rule assuming it is using OR operator instead.):

Result of above Lookup function configured in business rule:

The system ignored the second line “Last Name is equal to “Miller”. > “Miller” was never found, “Smith” might be found if existing.

Scenario 2:

When in a lookup function, customer added multiple criterias using:

1. same field name 
2. the same operator - is not equal to 
3. different values 

Both criterias will be considered, it is completely valid for statements like below, a user's Last Name could be not "Smith" AND "Miller":

Recommendation for fixing the issue:

Customers need to understand that all statements in the lookup function are validated by an AND. Please kindly check the rule configuration and validate further.

If your aim was defining a statement like:

Singer.LastName.is equal to.Text.Smith OR Singer.LastName.is equal to.Text.Miller

Please kindly consider change the related rule configuration and configure 2 separate lookup functions instead.

Support colleagues, please see internal memo for more details.

• Lookup | SAP Help Portal

Lookup function, custom MDF, business rule, operator, AND, OR, same field , different values, MDF Business rule, Lookup, statement, multiple criteria , KBA , LOD-SF-MDF-RUL , Custom Oject based Business Rules , How To