Overtime and Illness by Organizational Unit (SAP Analytics)

Query Query: 0PT_C01_Q0200

This Query shows key figures by organizational unit for the planned working times, overtime, and illness times in hours, and outputs the overtime and illness rate.

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 Calendar Year / Month 0CALMONTH

Filtered by the last month.

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Employee Group 0EMPLSGROUP
Characteristic Characteristic Employee Subgroup 0PERS_AREA
Characteristic Characteristic Personnel Area 0PERS_SAREA
Characteristic Characteristic Employee 0EMPLOYEE
Variables
Object Type Name Technical Name
Variable Variable Organizational Unit (Selection Option, Personalization) 0S_ORG_P
Variable Variable Last Month 0CMLMON
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
Structure Overtime and Illness Rate 0PT_C01_QT_SOT_RATE

Key Figure Key Figure Planned Hours 0R_PLAN_HRS
Key Figure Key Figure Overtime Hours 0R_OVER_HRS
Key Figure Key Figure Illness Hours 0R_SICK_HRS
Key Figure Key Figure Overtime Rate

Formula: Illness hours %A planned hours. Number of overtime hours expressed as a percentage of the number of planned hours.

Key Figure Key Figure Illness Rate

Formula: Illness hours %A planned hours. Number of illness hours expressed as a percentage of the number of planned hours.