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
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 pageThis 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.