Duplicate rules
Access through: Duplicate search > Duplicate rules
Duplicate rules is part of the Duplicate search feature in Snow Optimizer for SAP® Software. Duplicate rules define the system type combinations and the search criteria for identifying duplicate users in a duplicate search. The search criteria consist of condition types that you can combine with logical operators. In the duplicate rule editor, you insert condition types and logical operators line by line.
Before you can use a duplicate rule in a duplicate search execution, you must activate the duplicate rule. Upon activation, the duplicate rule is checked for errors, saved, and marked as ready to use.
As a starting point, you can find templates of duplicate rules in Snow Optimizer for SAP® Software.
Condition types and operators
In duplicate rules, you can use the following condition types and operators:
| Condition type | Description |
|---|---|
| User master data comparison | Compares the values in a selected field of user 1 and user 2. Beyond the exact comparison, you can specify a Maximum edit distance. The edit distance enables the search for potential duplicates that resemble each other. Note: The edit distance of two strings is the minimal number of changes to single characters which converts one string to another. Allowed operations are:
To make the comparison case sensitive, you can select Case sensitive. If SAP systems contain fields that are not maintained but are part of the duplicate search, these are classified as potential duplicates. Therefore, the Compare only non-initial values checkbox is selected by default and should stay activated. |
| User master data | An extra condition that compares a field of the user data of user 1 or user 2 to a comparison value. To make the comparison case sensitive, you can select the Case sensitive. If SAP systems contain fields that are not maintained but are part of the duplicate search, these are classified as potential duplicates. To prevent this, you can select Compare only non-initial values . |
| System data | An extra condition that compares a field of the system data of user 1 or user 2 to a comparison value. To make the comparison case sensitive, you can select the Case sensitive. If SAP systems contain fields that are not maintained but are part of the duplicate search, these are classified as potential duplicates. To prevent this, you can select Compare only non-initial values. |
| Own implementation | Self-developed condition that corresponds to special environments or interests, using an ABAP method implemented in your own class. |
| Operator | Description |
|---|---|
| ( | Opening bracket |
| ) | Closing bracket |
| AND | Logical and |
| OR | Logical or |
| NOT | Negotiation |
EXAMPLE
Check for users with the same email addresses by comparing user master data from different systems considering the user ID and email address.
-
Operator: NOT
-
Condition type: User master data comparison
Condition value for fields: User Name in User Master Record
-
Operator: AND
-
Condition type: User master data comparison
Condition value for fields: Email Address
This duplicate rule does not compare same user names (first operator and condition type) but compares same email addresses (second operator and condition type) in the user master data.