Symptom
Understanding how the Length of Service is calculated from the Headcount Data Source.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Business Analytics > Design Reports.
- Search for the report HCMPAB01.
- Open the Report and Execute it.
- Check the Length of Service field.
Cause
The Length of Service field in the Data Source HCMPAB01 was developed to calculate an employee's Length of Service as of a particular date (i.e., the Key Date).
Length of Service is calculated based on the difference between the Hire Date and the Key Date. If the Key Date is blank, the current date will be used.
Resolution
Currently, this is the expected system behavior. In order to have right Length of Service populated, you need to maintain the necessary date in Key Date.
Keywords
Length of Service formula, report, Business Analytics, Design Reports, HCMPAB01. , KBA , SRD-HR-PAD , Personnel Administration , How To