SAP Knowledge Base Article - Preview

2731560 - Advanced Reporting doesn't fetch the 'External Code' and 'Label' for a few picklist fields.


Behavior in Advanced Reporting:
Running an Advanced Reporting report with the Date Options set to 'Current Date', fetches the 'External Code' and 'Label' for the affected picklists.
But setting the date options to 'As Of Date' and choosing certain dates in the past or in the future fetches no data for these fields.

Behavior in the UI:
Setting the same dates as the effective date in the People Profile / Employee Files > Employment Information does fetch data for these fields.
If the picklist is associated to MDF Objects, data along with effective dates is displayed as expected when we check the data in UI for them.
i.e. 'Manage Data' or 'Manage Positions', depending on the MDF object under consideration.

Behavior in Ad Hoc (Report - Table) reports:
If the fields are reportable in Ad Hoc (Report - Table) report Sub Domain Schema with effective dating (As Of Date or Date Range), creating and running a report with the past or future dates does fetch the data seen in the UI.

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


SAP SuccessFactors HXM Suite all versions


Advanced Reporting, Realms, Picklist, MDF Picklists, Effective Dating, Future Effective Dated Picklists, Blank, Missing, Past, Effective Dated, Report - Canvas, current effective dated MDF picklists , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.