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, in our example we are looking at the Leads BO.
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 correspdoing 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 * .
Postal code is of type character/text string.
In Leads Distribution Rules, customer is using '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 *.
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.
BRF LEAD , KBA , LOD-CRM-BRF , C4C BRF Configuration , Problem