SAP Knowledge Base Article - Public

2080032 - EC Ad Hoc is only showing pick list id's and not the descriptions

Symptom

  • In Ad Hoc report selecting a number of fields that has picklist, the option id numbers for that shows up in report results but not the description/value of the picklist.

Environment

  • SAP SuccessFactors Employee Central

Resolution

  • If the report you are running is one of the other report schemas (“as of date”, “Date Range” or “Audit”), then you have the “Enable Ad Hoc Configuration Pill” feature enabled in your instance, which adds the “Configuration” tab to Ad Hoc Reports.
  • The “Configuration” tab allows you to specify whether to report on the picklist/Foundation Object value or ID.
  • Please review the following Knowledge Base Article for more information on EC Ad Hoc reports -:

Keywords

ad-hoc report shows picklist option id, ad hoc report shows numbers codes instead of values/labels, Configuration tab in ad hoc reports , KBA , sf employee central , sf adhoc reports , LOD-SF-EC-REP , Reporting Data (EC core only) , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core all versions