Headcount and Headcount FTE (SAP Analytics)

Query Query: 0PA_C01_Q0200

This query shows the headcount by organizational unit, expressed as the number of employees and number of full-time equivalents (FTEs).

The query is part of the SAP_BW_0ROLE_0021 role (Human Resources Analyst).

Structure

Filters
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Employment Status 0EMPLSTATUS

Only employees with the employee status 3 (Active Employees) are evaluated.

Characteristic Characteristic Employee Group 0EMPLGROUP

Only employees from employee group 1 (Active Employees) are evaluated.

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Employee 0EMPLOYEE
Characteristic Characteristic Employee Subgroup 0EMPLSGROUP
Characteristic Characteristic Personnel Area 0PERS_AREA
Characteristic Characteristic Personnel Subarea 0PERS_SAREA
Characteristic Characteristic Master Cost Center 0MAST_CCTR
Characteristic Characteristic Capacity Utilization Level % 0PAYPCT_CHA
Characteristic Characteristic Age Range 0AGE_RANGE
Variables
Object Type Name Technical Name
Variable Variable Organizational Unit (Selection Option, Personalization) 0S_ORG_P
Variable Variable Last Month Where Postings Were Made * 0LYMONTH*
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Organizational Unit 0ORGUNIT

Personalization required

Columns
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Calendar Year/Month 0CALMONTH

Is restricted to the last five years.

Key Figure Key Figure Number of Employees 0HDCNT_LAST
Key Figure Key Figure Headcount FTE 0HDCNT_FTE
Views
Object Type Name Technical Name Description
Query Query Headcount and FTE Time Series (SAP Analytics) 0PA_C01_Q0200_V01
Query Query Headcount and FTE per Organizational Unit (SAP Analytics) 0PA_C01_Q0200_V02
Query Query Headcount and FTE per Capacity Utilization Level (SAP Analytics) 0PA_C01_Q0200_V03
Query Query Headcount and FTE per Age Group (SAP Analytics) 0PA_C01_Q0200_V04