SAP Knowledge Base Article - Public

2433905 - How to fetch HR Approver's data in Relams Query?

Symptom

  • How to fetch HR Approver's data in Relams Query?
  • Unable to view First Name, Last Name of HR Approverin Realms Query.
  • How to fetch data present in "Assignment Relationship" portlet in Realms query?

Teva 3.png

Environment

  • Advance Reporting

Resolution

  1. Go To Advance Reporting
  2. Employment > Global Job Information > Pull Fetch Employee ID/ Global ID field in Realms query
  3. Advance Reporting > Employment > Global Job Information > Assignment Relationship
  4. Pull "Relationship Type(Label), Name (Preferred First Name) and Name (Last Name)" fields from "Assignment Relationship" table

Teva 1.png

Teva 2.png

Keywords

Assignment Relationship
HR Approver
Advance Reporting , KBA , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors HCM Core all versions