Birthday List (Query BIRTHDAY_LIST) (SAP Library - Reports in Personnel Administration)

Birthday List (Query BIRTHDAY_LIST)

Use

You use this report to create an overview of employee's birthdays. You can modify such overviews to your own company specific requirements. For example, you can create an overview list for each month, or determine coming anniversary birthdays.

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

Features

Selection

You determine who is to be evaluated and what data is to be evaluated under the Period section.

Note

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

In the Personnel number field under Selection, enter the personnel numbers to be included 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

Determine the type of birthday list that the system should output under Program selections.

Annual overview or monthly overview

If you want to print such a list, enter data in the fields Year of birth or Birthday (within a month/year).

List of coming anniversary birthdays

Should you want to create such a list, there are entries in the Year of birth or Employee's age fields which assist you.

List related to key date

Use the Date of birth or Day and month of birthday fields to create this list.

List according to employee gender

If you want to draw up a gender-specific list of employee's birthdays, enter 1 for men and 2 women in the Gender key field.

The following fields are also available:

Cost center

Organizational unit

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

For more information on printing lists, see the Basis documentation under ABAP Workbench (BC-DWB) ® SAP Query and the Quickviewer ® SAP Query ® Application ® Interactive Functions for Further List Processing.

Output

Depending on the selected output option, the evaluation results are displayed.

The following columns can be used when formatting the evaluation results:

PersNo. (Personnel number)

Last name

First name

Entry

Leaving

Date of birth

Day

Birthday (Birthday within current year)

Year

Age

Gender

Cost center

OrgUnit (Organizational unit)

Example

You want to generate a list of all employees within a certain cost center whose birthday falls within the next quarter. Select Other period under the Period section and enter the specific dates for the quarter that is to be evaluated. In the Cost center field, enter the appropriate cost center. The system creates a list of birthdays based on cost center.