Show TOC

 Family Members (Query FAMILY_MEMBERS)

Use

This report creates a list of employees who have information about their family members stored in the system.

You determine the employees using the subtype in the Family/Related Persons (0021) infotype.

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

Prerequisites

The data about an employee's family and related persons must be stored in the Family/Related Persons infotype (0021).

Features

Selection

You determine what data and who is to be taken into account during the evaluation under Period .

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 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

In the Type of family membership field; determine the subtype of the Family/Related Person infotype (0021). This will then be evaluated. You can delimit the selection to certain subtypes of infotype 0021 ( Family/Related Persons ) - for example, 1 for Spouse or 2 for Child .

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:

  • Personnel number

  • Name of employee or applicant

  • Entry

  • Family relationship

  • First name

  • Last name

  • Date of birth

Example

You want to create a list of people who you have to contact in case of an emergency. On the Type of Family Membership selection screen, select the Emergency contact subtype (=07).