SAP Knowledge Base Article - Public

2608673 - Picklist labels are not available in the 'Edit Restrictions' filter in advanced reporting reports


Picklist labels are not available in object filter in advanced reporting queries / reports

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


  • SAP SuccessFactors HCM Suite
    • Advanced Reporting

Reproducing the Issue

  1. Edit or create an ORD/ Canvas Report that uses Advanced Reporting datasource
  2. Select a table that includes picklist data and click Edit Restrictions

  3. In the next screen, clikc 'Add Filter' and expand the listed table
  4. None of the External Code / Labelf fields corresponding to picklist fields are displayed


This is expected behavior as this filter has only raw data available for comparison and it does not offer calculated column or other tables.


  1. Once you are in the Filter section after clicking 'Edit Restrictions' , select the desired field
  2. Select Report Values and wait for the values to load
  3. Though only numbers are displayed (internal IDs), you will be able to see the corresponding External Code and lables when you hover your mouse over the numbers


    Note: If the picklist code and label have multiple locales defined, the value(s) displayed will depend on the logged in user's current locale


Picklist, Label, Filter, Report, Edit, Restriction, Advanced, Reporting, Internal , external, Code, Name, missing, sync, issue, canvas, center, Online, Designer, ORD , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite all versions