Symptom
You want to search the Accounts which have no City maintained by selecting Criteria = Is Initial in Advanced Search. However, the results are not consistent, as the Accounts with City maintained are also appearing in result.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Customers workcenter.
- Open Accounts view.
- In Accounts OWL, open the Advanced Search.
- Select a Country and criteria City = Is initial.
- The results contain the City names instead of blank data.
Cause
This is the current behavior of the system.
Resolution
An account can have multiple addresses and via the address parameters in the Account OWL, Advanced Search is performed in all addresses.
This means if you search for accounts with Country/Region = Germany (for example) and City = Is Initial, you will find all accounts having an address where this criteria is fulfilled.
There is also an Advanced Search parameter "main address" in the OWL which can be used to only search in the main address (pers. hidden). If you would perform the same search as mentioned above with additionally "main address" = true, some Accounts will not be returned.
Keywords
Advanced Search, Parameter, City, Is Initial, Blank, Found, Result, Incorrect , KBA , LOD-CRM-ACC , Account , How To