2451373 - Cannot Report on Field "Country of Company" in AdHoc Report and ORD

SAP Knowledge Base Article - Public

2451373 - Cannot Report on Field "Country of Company" in AdHoc Report and ORD

Symptom

Cannot report on country-of-company in Adhoc report

we observed that Country of Company is showing as blank on the report.

We want to know whether this field is not populating in Job Information or is it no pulling to ORD.

Environment

Employee Central
Analytic
AdHoc Report

Reproducing the Issue

<hris-field max-length="256" id="country-of-company" visibility="view">
<label>Country</label>
<picklist id="ISOCountryList"/>
</hris-field>

Resolution

The Country of Company value is hard-coded to propagate based on Legal entity value

AdHoc Report:

Not Available in AdHoc Report Sub-domain:

  1. Person and Employment Audit
  2. Person and Employment Export

Available in AdHoc Report Sub-domain:

  1. Person and Employment Info (as of Date)
  2. Job Information (Date Range)


The field shows as “Country” and gives the Country of Company value

Advance Reporting:

Step 1:

  1. Go Analytic then Select Advance Reporting
  2. Select Employment then Global Job Information
  3. Select Users Sys Id
  4. Select Legal Entity

1country of company.png

Step 2 : Link to MDF

  1. in the search bar beside Employment: Type MDF and Click Enter
  2. Click on In foundation Objects Legal Entity
  3. Select Legal Entity
  4. Select Country
  5. Select Country(code)
  6. Select Country(Label)

22country of company.png

Link to MDF

4country of company.png

5country of company.png

Step 3: Report result
Click on Result

6country of company.png



Keywords

country-of-company AdHoc Report Person and Employment Audit Person and Employment Export Person and Employment Info (as of Date)
Job Information (Date Range) Advance Reporting , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC , Employee Central , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core 1611