SAP Knowledge Base Article - Public

3271777 - How To Retrieve National ID Record In Canvas Report

Symptom

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. 

Environment

  • SAP SuccessFactors HCM Suite
  • Canvas Report
  • Employee Central - National ID

Resolution

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 Canvas: Implementing and Using Canvas Reports

     Guide National ID / Country/Region Specifics in Employee Central - Chapter : Check all countries Example- Identity - Malaysia

Q) Is it possible to report on the attachment information?

A) View : 2397810 - Is it possible to report on the attachment information?

Check Manage Documents Feature:

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
  • 2526193 - Manage Business Configuration: How to Create or Edit National ID Card formats in BCUI
  • 2397810 - Is it possible to report on the attachment information?
  • 2518360 - Manage Documents Feature

Keywords

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

Product

SAP SuccessFactors HXM Suite Core 2205