SAP Knowledge Base Article - Public

3684643 - Addresses Model Not Accessible in Lookup() Filtering Conditions When Using the Dependents Model as the Base Object

Symptom

  • When creating a business rule using the lookup() function, certain objects (for example, Addresses Model) are not available for selection on the right-hand side of the lookup filter conditions.
  • As a result, address-related fields cannot be directly referenced from elements such as Dependents or Biographical Information within the lookup() function because they have a one-to-many association with the Addresses Model. 

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

Environment

SAP SuccessFactors Employee Central - Dependents Management

Reproducing the Issue

  1. Go to Admin Center → Configure Business Rules.
  2. Create a new rule using the scenario onChange, Cross-Entity, or onSave rule scenarios with the base object set to Dependents Model.
  3. Create an "If" condition that attempts to compare a field from the Dependents Model with the output of a lookup() function. 
  4. In the lookup configuration, add a lookup filter condition where the left-hand side (LHS) uses a field from the lookup base object.
  5. On the right-hand side (RHS) of the filter condition, attempt to access the Addresses Model associated with the Dependents object.
  6. Observe that the Addresses Model does not appear or cannot be selected.

Cause

This behavior is expected system design. The lookup() function only supports simple fields or objects with a one-to-one association on the right-hand side (RHS) of its filter conditions.

Since the Addresses Model is a one-to-many association with the Dependents Model, it cannot be directly accessed during lookup filtering. 

Resolution

To reference a field from a one-to-many associated object (such as the Addresses Model) in a lookup() filter condition, you must use a variable that resolves the object.

  1. Create a Rule Variable and map the variable to the Addresses model or field.

  2. In the lookup filter conditions, use the variable to access the addresses model fields on the right-hand side.

See Also

Lookup | SAP Help Portal

Keywords

INC16479520, lookup(), lookup function, business rules, one-to-many association, Addresses Model, Dependents Model, Biographical Information, variable, RHS, filter condition, field not available, address fields not accessible, rule variable, lookup filter. , KBA , LOD-SF-EC-DPD , Dependents Management , How To

Product

SAP SuccessFactors Employee Central 2505