SAP Knowledge Base Article - Public

2280606 - How to Report on Leave Start Date and Actual Return Date for Leave of Absence

Symptom

You have requested a Leave of Absence for an user and would like to report on the 'Leave Start Date' and 'Actual Return Date' fields. However, upon creating an AdHoc Report, you are unable to find these fields.

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 Employee Central
  • SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Admin is requesting a Leave Of Absence for an user;

  1. Check the Leave record in the Job Information Portlet;

 

Cause

Expected behavior. It is not possible to report on the fields 'Leave Start Date' and 'Actual Return Date', due to the fact they do not exist in the Succession Data Model - they are only displayed on the UI. 

Resolution

  • However, there is a way to report on similar fields that will retrieve the data from the Job Information record;
  • Go to Report Center > New > Table > Select the domain 'Person and Employment Export' and select the columns under 'Employee Job Inf: 'user-id', 'department', 'event-reason', 'expected-return-date', 'start-date' and 'end-date', as shown below:

  • After doing so, go to Filters > Refine Criteria > User/Employee ID (or any other filter method you prefer) > Done > Preview;
  • Result:

  • 'start-date' is equal to Event Reason 'LOALOA', matching the 'Leave of Absence' record on Job Information: May 16th, 2023;
  • 'end-date' is equal to Event Reason 'RETLEAVE', matching the 'Return from Leave' record on Job Information, which is the field 'Actual Return Date' on the Manager Self Service UI: May 24th, 2023.

Keywords

Adhoc Report, Leave Of Absence, Leave Start Date, Actual Return Date, Start Date, End Date, how to, leave report , KBA , LOD-SF-EC-TIM-JOB , Time Management in Job Info - Records & Objects , LOD-SF-EC-TIM , Time Off , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC-REP , Reporting Data (EC core only) , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions