SAP Knowledge Base Article - Public

2668607 - Is it possible to fetch Level1, Level2 Manager's Data in the Report in same row?

Symptom

  • How to fetch Level1, Level2 Managers in Report in single Row?
  • Is it possible to fetch all managers along with employee details in same row?

Environment

 Advance Reporting

Resolution

  1. Go To Advance Reporting
  2. Select Employment 
  3. Go To Global Job Information Table
  4. Select User Sys ID, First Name, Last from Global Job Information Table
  5. Apply Filter on the User Sys ID
  6. Expand the Global Job Information Table on the Right Hand Panel 
  7. Select Supervisor Table 
  8. Select Supervisors Global Job Information table
  9. Select Supervisor User Sys ID and Supervisors Firstname and Last Name
  10. Then Navigate towards Right hand panel from Supervisor table 
  11. Select Supervisor's Supervisor table
  12. Navigate to Supervisor's Supervisor's global Job Information table
  13. Select Supervisor's Supervisor from this table
  14. Employee's and 1st level Manager and 2nd Level Manager's Data will appear in the same wor in advance reporting.

Keywords

  • Advance Reporting
  • Manager's Data
  • Supervisor
  • Supervisor's Supervisor
, KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Core 1805