SAP Knowledge Base Article - Public

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


  • The client is running an Ad Hoc report and selecting a number of fields that use pick lists.  When the report is run, the id numbers for that field show but not the descriptions.  Why is this happening?


  • Employee Central


  • If you select the report definition type Person and Employment Export in Ad Hoc reports, you will only see id numbers in Picklist/Foundation Object fields, and not a description.  The reason is that this type of report is designed to be used in creating import files so just the id # of a picklist/Foundation Object shows up, and not the description.  
  • To get the description to show up in the report, you need to select one of the other EC report types as the report definition type instead.


Please review the following Knowledge Base Article for more information on EC Ad Hoc reports -:

  • If the report you are running is one of the other report schema’s (“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.


KBA , sf employee central , sf adhoc reports , LOD-SF-EC , Employee Central , How To


SAP SuccessFactors HCM Core all versions