Show TOC

Overtime and Illness/Details by Organizational Unit (SAP Analytics) Locate this document in the navigation structure

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.