When running a Person and Employment Ad Hoc report which has the option to report on MDF Position data (Job Info Position), strange ID numbers are returned for Foundation Object related fields, when reporting on Position object data.
Succession By MDF Position Ad Hoc report returns internalCode instead of Labels for Foundation Objects - Legal Entity, Business Group, Cost center, Department, Division.
MDF Position Management
Employee Central 2.0
Reproducing the Issue
- Create a new Person and Employment Info (as of Date) Ad Hoc report
- Select any Foundation Object based fields under the column set - Job Info Position, such as Company, Business Unit, etc
- Run the report and note that ID's are displayed in these columns instead of the expected Label/externalCode value
The following reports are so far reported as impacted -:
Succession (MDF Position based nominations, with Employee Central)
Inclusive Succession (MDF Position based nominations, with Employee Central)
Succession History (MDF Position based nominations, with Employee Central)
Person and Employment (as of date)
Caused by a functional gap in the Ad Hoc report schema for EC data
Currently there is no available work-around and this is expected as behaviour.
The alternative solution is to report on this data via Advanced Reporting (ODS) which will return the valid Label/Code instead of the database InternalId for the record
Engineering are working to support the Position Object data in all related Ad Hoc reports in a future release. Please look for ECT-41374 in release notes.
This is a known limitation with Succession By MDF Position Ad Hoc report. Currently the foundation object is not supported well in all of the succession ad-hoc reports. Please refer internal SAP ticket - SCM-7860.
MDF Position Ad Hoc Reporting Employee Central , KBA , LOD-SF-EC , Employee Central , LOD-SF-EC-REP , Reporting Data , Problem