SAP Knowledge Base Article - Public

2665276 - Adhoc Report using Job Information Position column shows incorrect object codes

Symptom

Adhoc Report result:

2.png

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Employee Central v2.0 - Adhoc reporting

Reproducing the Issue

1. Create an Adhoc report using Person and Employment Info (as of Date) domain.

2. Select Job Information Position Column Generic object entities e.g. Company, Division, Department, Job Code.

3. Run online or extract the report.

1.png

Result (Observe the codes listed from the report highlighted in Yellow and red):

7.png

Cause

internalId / internalCode of the respective MDF object data is being fetched instead of the externalCode:

1. Take a sample output data for e.g. Company - 804012

2.png

2. Go to Configure Object Definitions > Object Definition > Legal Entity > search for the internalId field and set the visibility to Read Only:

3.png

4.png

3. Add internalId as a searchable field for Company / Legal Entity MDF Object:

5.png

4. Search for Company / Legal Entity - 804012 from Manage Data:

6.png

This is also true for other Domain Types like: Succession (MDF Position based nominations), Job Information (Date Range) and other domains that could access employee MDF data from EC HRIS elements.

Resolution

This is a known limitation with Ad Hoc Reports pulling data from MDF object fields. Currently this is pending for a solution from our Development team.

 

Solution:

The Advanced Reporting feature should be leveraged in this scenario to generate the same report. The ODS report can be configured to return the Code/Name values instead of the internalCode value.

Keywords

Adhoc Reports, internalId, internalCode, Job Information Position, adhoc report fetching internalId, ECT-83833, ad-hoc, ad hoc, position, , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC-POS , Position Management , Bug Filed

Product

SAP SuccessFactors HCM Core 1805