Compare Overview of Time and Labor to Previous Year

Technical Name: 0PT_C01_Q011

Based on InfoCube 0PT_C01

Use

This query is used to assign time and labor data from one year according to time types, and then based on the relation to planned time, compare time and labor from the previous year.

Free Characteristics

InfoObject

Description

0EMPLOYEE

Employee

0EMPLGROUP

Employee group

0EMPLSGROUP

Employee subgroup

0PERS_SAREA

Personnel subarea

0CO_MST_AR

Controlling area of master cost center                                   

0MAST_CCTR

Master cost center

0ORGUNIT

Organizational unit

Rows

InfoObject

Description of InfoObject
(and Restriction or Calculation Formula)

0PERS_AREA

Personnel area

0REPTT

Time type for reporting

Columns

InfoObject

Description of InfoObject
(and Restriction or Calculation Formula)

0QT_YEAR A_F

Compare current year with previous year

(Current year - previous year)/Previous year in %

Current year

used in Structure 0QT_YEAR A_F

Previous year

used in Structure 0QT_YEAR A_F

Difference in %

calculated in Structure 0QT_YEAR A_F

0QT_ACTPL

Compare actual/planned

Actual hours/Planned hours in %

0R_ACT_HRS

Actual hours

used in Structure 0QT_ACTPL

0R_PLAN_HRS

Planned hours

used in Structure 0QT_ACTPL

Planned hours (display hidden)

used in 0QT_ACTPL structure

Actual/Planned

calculated in 0QT_ACTPL structure