Overtime and Illness/Details by Organizational Unit (SAP Analytics)

Query Query: 0PT_C01_Q0201

This Query shows the following key figures for each employee for the last month:

  • Overtime Hours

  • Illness Hours

  • Overtime Rate

  • 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 0EMPLGROUP
Characteristic Characteristic Employee Subgroup 0EMPLSGROUP
Characteristic Characteristic Personnel Area 0PERS_AREA
Characteristic Characteristic Personnel Subarea 0PERS_SAREA
Characteristic Characteristic Organizational Unit 0ORGUNIT
Variables
Object Type Name Technical Name
Variable Variable Last Month 0CMLMON
Variable Variable Organizational Unit (Selection Option, Personalization) 0S_ORG_P
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Employee 0EMPLOYEE

No row is output if no overtime or illness hours have been recorded for an employee in the last month.

Columns
Object Type Name Technical Name Value Restriction / Calculation
Structure Overtime and Illness Rate 0PT_C01_SIOV_RATE

No column is output if there have been no overtime or illness times for an employee in the last month.

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

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

Key Figure Key Figure Illness Rate

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