3277779 - How to Find Dependent Person Id or Related Person Id External

How to find Dependent Person Id or Related Personid External

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 - Dependents Management

Via Data Inspector

Example For user: 27000007

Step 1: Retrieve Person ID under: Table_PER_PERSON

• Go to data inspector
• Select: Table_PER_PERSON
• Under Define Filter Criteria

• select: Person ID External Equals userid
• ( example:  Person ID External Equals 27000007)
• click on Show Data
• Result:  Person ID = 527

Step 2: Retrieve Related Person ID  under: Table_PER_PERSON_RELATION_T

• Go to data inspector
• Select: Table_PER_PERSON
• Under Define Filter Criteria

• Select: Person ID  Equals  Person ID
• ( example:  Person ID External Equals 527)
• click on Show Data
• Result:  Related Person ID  = 4961 

Step 3: Retrieve Person ID External or Dependent Person Id Under: Table_PER_PERSON

• Go to data inspector
• Select: Table_PER_PERSON
• Under Define Filter Criteria

• Select: Person ID  Equals  Related Person ID
• ( example:  Person ID  Equals 4961)
• click on Show Data
• Result:  Person ID External or Dependent Person Id  = 527_d4961 

 View Data Inspector Summary result

Via Canvas Report

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
5. Click 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: Person ID

 Step 2: Select Child Table Dependents

1. Select: Effective Start date
2. Select: Relationship (Picklist Label)

Step 3: Select Dependents Child Table Dependent Personal Info

1. Select: Dependent Person ID

Step 4: Save Report

1. Save Report
2. Click Objects and View Report overview 

 View Canvas Report Summary result

Important: Save your canvas report: 2543169 - How to Save the Query in Report Center for future use

FAQ - Additional Information

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

A) Guide: Implementing Dependents

• 2806252 - How To Retrieve Dependents Related Information via ORD
• 2368375 - How to Set Up and Use Date Options in Advanced Reporting
• 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)

• 2092840 - Importing Dependent Information into Employee Central
• 2368375 - How to Set Up and Use Date Options in Advanced Reporting,
• 2470903 - How to use "Effective From" and "Effective To" filters to obtain historical/future records - Integration Center
• 2186440 - Employee Central: Error Importing new Dependents via Compound Dependent import using Incremental mode
• 2274679 - How to Delete/Delimit Dependents Data via Import
• 2323484 - Error: Unable to import Consolidated Dependents data
• 2280959 - Unable to generate an Ad Hoc Report for Dependents data
• 2543169 - How to Save the Query in Report Center for future use 
• 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)
• 2186440 - Error: Importing new Dependents via Compound Dependent import using Incremental mode
• Example: 3058601 - How To Check Soft or Permanent Purge User
• 2584658 - How to Check if a User is an EC User using the Integration Center - isECRecord Boolean

Related Person ID is Invalid, canvas, import, Person Relationships,dependent, delimit, delete, Person ID External, Data Inspector , Table_PER_PERSON,Table_PER_PERSON_RELATION_T, Person ID, Incremental Load  , KBA , LOD-SF-EC-EDP-DPD , Person Relationship & Consolidated Dependents Import , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-EC-DPD , Dependents Management , How To