SAP Knowledge Base Article - Public

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

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

  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)

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

Product

SAP SuccessFactors HXM Core 2211