2226656 - MDF Position data in Ad Hoc reports display InternalId for Foundation object columns

SAP Knowledge Base Article - Public

2226656 - MDF Position data in Ad Hoc reports display InternalId for Foundation object columns

Symptom

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.

Environment

MDF Position Management

Employee Central 2.0

Reproducing the Issue

  1. Create a new Person and Employment Info (as of Date) Ad Hoc report
  2. Select any Foundation Object based fields under the column set - Job Info Position, such as Company, Business Unit, etc
  3. 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)

Cause

Caused by a functional gap in the Ad Hoc report schema for EC data

Resolution

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.

Keywords

MDF Position Ad Hoc Reporting Employee Central , KBA , LOD-SF-EC , Employee Central , LOD-SF-EC-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Core all versions