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
- Go to Admin Center → Configure Business Rules.
- Create a new rule using the scenario onChange, Cross-Entity, or onSave rule scenarios with the base object set to Dependents Model.
- Create an "If" condition that attempts to compare a field from the Dependents Model with the output of a lookup() function.
- In the lookup configuration, add a lookup filter condition where the left-hand side (LHS) uses a field from the lookup base object.
- On the right-hand side (RHS) of the filter condition, attempt to access the Addresses Model associated with the Dependents object.
- 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.
-
Create a Rule Variable and map the variable to the Addresses model or field.
-
In the lookup filter conditions, use the variable to access the addresses model fields on the right-hand side.
See Also
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
SAP Knowledge Base Article - Public