SAP Knowledge Base Article - Public

2638392 - Employees Excluded From an Account Query Are Still Returned by the System When They are the Owner of the Account


Whenever you exclude an Employee from an Account query, you can still see them appear in the results if they are the Owner of the Account.



Reproducing the Issue

  1. Go to the Customer workcenter.
  2. Go to the Accounts view.
  3. Click the Magnifying glass icon, to reach the Advanced search.
  4. Next to the Employee filter, select the More Details.
  5. Check the box under But, exclude.
  6. Select ABC (ABC represents the Employee you wish to exclude from your query) from the value List.
  7. Complete the filtering for your query.
  8. Click Go.

Result: Among the Accounts returned, you find Accounts whose Owner is the excluded Employee.


When you resort to the Advanced Find from parameter Employee in the Account ObjectWorkList, the system fetches data in two places of the tenant; First in the Account team and second in the Sales Territory team.

If you look to exclude Employee ABC, the search will return all Accounts in which Employee ABC is not part of one team OR is not part of the other.


This is the designed behaviour.

To exclude totally Employee ABC, you may further the advanced search. Additionally to the exclusion of Employee ABC from the Employee filter, you may Set the Responsibility Source to Account Team Only or Sales Territory only, so those Accounts will not appear in your query.


Account Query, Sales Team, Account Team, Advanced Find, Advanced Search, , KBA , LOD-CRM-ACC , Account , How To


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions