SAP Knowledge Base Article - Public

3368563 - How To Retrieve Work Permit record in Canvas Report


How To Retrieve Work Permit  record in Canvas Report

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


  • SAP SuccessFactors HXM Suite
  • Report Canvas
  • Employee Central - Work Permit


Create a New report

  1. Go to Report Center
  2. Click on Report Canvas -Then Select
  3. Give your report a name
  4. Mouse over table and Drag down 

  1. Click on: Edit Query
  2. Select Advance Reporting
  3. New
  4. OK

Step 1: Select Parent or Root table

  1. Person
  2. Select Person Child Table Personal Information
  3. Select and drag First Name - Last Name - UserID or SuccessFactors ID

 Step 2: Select Child Table Work Permit

  • Work Permit
  • Select and drag all information regarding Work Permit

Example: Document Type , Document Title

Step 3:

  1. Save Report ( View : 2543169 - How to Save the Query in Report Center for future use)
  2. Click Objects and View Report overview 

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide:SAP SuccessFactors People Analytics | SAP Help Portal or Work Permit Info

See Also

  • 2543169 - How to Save the Query in Report Center for future use
  • 2368375 - How to Set Up and Use Date Options in Advanced Reporting
  • 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)
  • 2503535 - Picklist Label field is missing from a table in Advanced Reporting


KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To


SAP SuccessFactors HXM Core 2305