SAP Knowledge Base Article - Public

3271777 - How To Retrieve National ID Record In Canvas Report


How To Retrieve National ID  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 - National ID


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 National ID Information

  • National ID Information
  • Select and drag all information regarding national ID

Example: National ID Card Type , National Info ID

Step 3:

  1. Save Report
  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 National ID

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)
  • 2162838 - National ID Column is not visible in reporting
  • 2701612 - How to Import National ID Information
  • 2472343 - How to Manage National ID Formats via Manage Business Configuration (BCUI)


Report, Canvas, Advance reporting, ODS, ROD,National ID Card Type , National Info ID, is primary , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , How To


SAP SuccessFactors HXM Suite Core 2205