SAP Knowledge Base Article - Public

3134826 - How to query specific Referrals for Candidates that have been referred multiple times? - Recruiting Management


How to report specific referrals from a Candidate that has been referred more than one time? 

"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 Recruiting Management 


A useful way to make a query to one specific referral only would be choosing the "Create Date" from "Referrals linked on [Candidate, Application, Job Requisition]" table: 

These fields can be used to first query the Create Date and observe the older date that system will bring. The respective date can be collected and used as a filter, so the Report result will display only this referral: 

This is how the Report will response: 

In this example the Created Date and Created Date (Timestamp) has been used, but any of both will get the same data, the only difference is that one has a Timestamp which shows more accurately the referral date; it can be used this specific field if the Candidate has been referred more than once at the same day. 


candidate referral, employee referral, report referral, multiple referrals  , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem


SAP SuccessFactors Recruiting all versions