Symptom
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.
Environment
- SAP SuccessFactors HXM Suite
- Report Canvas
- Employee Central - Dependents Management
Resolution
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
- Go to Report Center
- Click on Report Canvas -Then Select
- Give your report a name
- Mouse over table
- Click table and Drag down
- Click on: Edit Query
- Select Advance Reporting
- New
- OK
Step 1: Select Parent or Root table
- Person
- Select Person Child Table Personal Information
- Select: Person ID
Step 2: Select Child Table Dependents
- Select: Effective Start date
- Select: Relationship (Picklist Label)
Step 3: Select Dependents Child Table Dependent Personal Info
- Select: Dependent Person ID
Step 4: Save Report
- Save Report
- 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
See Also
- 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
Keywords
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