Symptom
You are trying to search for postal code in Accounts using lower case alphabets and you see that no records are found
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Customers Workcenter
- Go to Accounts view
- Select the advanced search option
- In the section Address , we see a field Postal Code
You see that the field postal code doesn't give any result if the entry term is in lower case , even if it is valid
Cause
Postal code is on data base level of type code/character; for these data types, the search is case sensitive, for other data types (i.e. Name, Text, Note, Description, ...) the search is case insensitive.
The basic search is a kind of text search which always works case-insensitive
Resolution
This is an expected system behavior.
Keywords
Postal code, records not found , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To