SAP Knowledge Base Article - Public

3350591 - How is the Length of Service calculated from the Headcount Data Source?

Symptom

Understanding how the Length of Service is calculated from the Headcount Data Source.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Business Analytics > Design Reports.
  2. Search for the report HCMPAB01.
  3. Open the Report and Execute it.
  4. 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

Product

SAP Business ByDesign all versions