Show TOC

 Anniversaries (Query JUBILEE_LIST)

Use

This report creates a list of employees who have a seniority anniversary within a year.

This query is assigned to user group HR: Personnel Administration (/SAPQUERY/H2) within the global area .

Features

Selection

Under Period, you determine the dates or person selection period for which you want to evaluate employee data.

Note Note

Note: You can only make an entry in the Person selection period if you have selected Other period .

End of the note.

In the Personnel number field under Selection , enter the personnel number that you want to include in the evaluation . If you want to get an overview of many employees, enter the corresponding personnel numbers or the personnel number range in the field Personnel number under the Selection section. You can also restrict the selection using the following fields:

  • Employment status

  • Personnel area

  • Personnel subarea

  • Employee group

  • Employee subgroup

In the Anniversary in years field under Program selections, specify which anniversary you want to evaluate. If you use this, you can restrict the selection to certain anniversaries (for example, 01 for first year anniversaries or 10 for a ten year anniversary of years of service)

You define the output list form under the section Further processing options .

For more information on printing lists, see the Basis documentation under Start of the navigation path ABAP Workbench (BC-DWB) Next navigation step SAP Query and the Quickviewer Next navigation step SAP Query Next navigation step Application Next navigation step Interactive Functions for Further List Processing End of the navigation path .

Output

The evaluation results are formatted according to the selected output option. The following columns can be used when formatting the evaluation results:

  • PersNo. (Personnel number)

  • Last name

  • First name

  • Entry

  • Year

Example

You want to create a company wide list of all employees who celebrate their ten year anniversary of service within the current year. You delimit the evaluation in the Anniversary in service years field with the anniversary desired (=10); the system will then display the employees according to the restrictions you have entered.