Symptom
- Leads are not getting assigned to Respective owners as the Postal code is not being considered correctly.
- The same could happen respectively for other objects.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Sales work center
- Go to Leads view
- Select Show all and pick the sample test data
- Assign the postal code to the Lead as per sample test data
- Now based on Lead Distribution rules , the corresponding Owner against hat entry should be uploaded. Example: If the postal code range is defined as [YO10 *..YO95 *] , the Range is considering YO10 * but it is not considering YO95 * .
Cause
Postal code is of type character/text string.
In Leads Distribution Rules, is used 'Between' operator with From-value as YO10 * and To-value as YO95 * for postal code. If you arrange and compare these 3 string values (YO10 * , YO95 * , YO95 APS) and arrange in ascending order the sequence of the values in ascending order will be as follows: YO10 * followed by YO95 * followed by YO95 APS.
Hence, if input is YO95 APS, it does not match the definition [YO10 *..YO95 *]. This is the expected behavior with Between operator used with character/text values.
Similarly, if you remove the space between YO95 and * and maintain it like YO95* and compare these 3 values (YO10 * , YO95* , YO95 APS) and arrange in ascending order the sequence of the values in ascending order will be as follows: YO10 * followed by YO95 APS followed by YO95 *.
Resolution
Between operator on character string values does the string comparison and not the pattern match. This is the expected behavior between operator used with character/text string values.
Keywords
BRF LEAD, rule, Leads Distribution Rules, Leads, interval, postal code , KBA , LOD-CRM-BRF , C4C BRF Configuration , Problem
SAP Knowledge Base Article - Public