Headcount/Headcount FTE (CE) 
Query: 0PA_MP03_Q0001
For a fixed calendar day, this query displays the headcount per organizational unit, sorted according to Personnel Assignments, Main Personnel Assignments, and Person ID. The query also shows the full-time equivalents (FTE) per personnel assignment (= column FTE) and per person ID (= column FTE (Person ID)).
The FTEs are displayed as a percentage. The percentages are calulated using the formula employment fraction/100. The FTEs per person total all employment fractions from the various personnel assignments and therefore encompass all of an employee's personnel assignments.
You can sort the displayed information according to additional criteria, for example, by employees, employee groups, the main assignment indicator, or the personnel actions date.
Note
The Number of Personnel Assignments key figure is hidden in the standard system. You can display it by navigating to the query output.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
 Variable | Key Date | 0P_KEYDA | — |
Object Type | Name | Technical Name |
|---|---|---|
 Characteristic | Main Assignment Indicator | 0PA_IS12___F50 |
| Characteristic | Master Cost Center | 0PA_IS12___F24 |
| Characteristic | Organizational Unit | 0PA_IS12___F25 |
| Characteristic | Employee Group | 0PA_IS12___F15 |
| Characteristic | Person ID | 0PA_IS12___F51 |
| Characteristic | Employee | 0PA_IS12___F6 |
| Characteristic | Employee Subgroup | 0PA_IS12___F17 |
| Characteristic | Personnel Actions Day | 0PA_IS12___F80 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Characteristic | Organizational Unit | 0PA_IS12___F25 |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
 Key Figure | Number of Assignments | 0PA_MP03_RK006 |
— |
| Key Figure | Headcount (Person ID) | 0PA_MP03_CK007 |
— |
| Key Figure | Number of Main Assignments | 0PA_MP03_RK007 |
— |
| Key Figure | FTE | 0PA_MP03_CK008 |
— |
| Key Figure | Number of Personnel Assignments | 0PA_IS12___F52 |
— |
| Key Figure | FTE (Person ID) | 0PA_MP03_CK009 |
— |