SAP Knowledge Base Article - Public

2652285 - Filter Search for Table Report not loading Picklist values


While creating an Table report you try to filter the result for a Picklist field and notice you cannot find the value from the filter search result.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SuccessFactors HXM Suite

Reproducing the Issue

  1. Home > Reporting > Table Report > Create an Table report (e.g. RBP Permission to User domain) 
  2. Go To Filter Tab > Select a Field which is Picklist (e.g. Permission) > By My Selection > Search for a value (e.g. Address 1 Edit)
  3. The Search does not fetch the value Address 1 Edit
    No items to display.jpg
  4. If you preview the Permission field values the Address 1 Edit is available


The Auto-Search on Table filter (By My Selection) does not display all values for picklist and when the number of values in Picklist field is more than 200.

This is a know limitation of the Ad Hoc Reporting tool and cannot be changed/altered.


1.) As a workaround you can use the page navigation to find the desired value. e.g. Address 1 Edit

items displayed.jpg

If the desired value (Address 1 Edit) is not available even by navigating to the next pages make sure the below provisioning option is selected.

Note: Such option should be configured only by Implementation Partner & Professional services after understanding the impact of such option on the current functionalities.

From Provisioning:

  1. Company Settings
  2. Select Sort Picklist Columns Based On Labels
  3. Save

Please be aware that enabling "Sort Picklist Columns Based On Labels" can cause issues in the filters 3026737 - Filter keeps loading forever in Report Center

2.) Another workaround is using the ORD tool instead and using Detailed Reporting as the data source of the report since this is a known limitation of the Ad Hoc Reporting tool.

Note: Detailed Reporting tool and Ad Hoc reporting tool share the same data source which is Live Data.

See Also

2537325 - Detailed Reporting in the Online Report Designer/Canvas Reporting - User Assistance Documentation link


By My Selection search, Filter search, Report Values, Ad Hoc, Ad-Hoc, AdHoc, Report - Table, Filter, 200, Table, Table report   , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem


SAP SuccessFactors HCM suite all versions