Qualifications Calendar Year (Formatted Reporting)

Technical name: 0PAPD_C01_Q0202

Based on InfoCube: 0PAPD_C01

Use

This query displays employees’ qualifications for the current calendar year. It serves as a data source for Crystal Reports, which can be used as a data source for iViews in the Business Package for Manager Self-Service.

Filters

InfoObject

Description of InfoObject (restriction or calculation formula)

0EMPLSTATUS

Employment Status

0EMPLGROUP

Employee Group

When the query is called, the Employment Status characteristic filters all employees with employment status 3 (=active) and the Employee Group characteristic filters all employees who belong to employee group 1 (=active). That is, the query only displays results for active employees.

Columns

InfoObject

Description of InfoObject (restriction or calculation formula)

0EMPLOYEE

Employee = employee (selection option, optional) (&0S_EMPLO&)

0GENDER

Gender

0ORGUNIT

Organizational Unit = = organizational unit (selection option, personalization) (&0S_ORG_P&)

0QUALIGROUP

Qualification Group

0QUALIFICTN

Qualification

0SCALE

Scale

0PROFCNCY

Proficiency Q/R

0MAST_CCTR

Master Cost Center = My Cost Centers (personalization) (&0SPCCTRM&)

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0CO_MST_AR

Controlling Area of Master Cost Center

0CALYEAR

Calendar Year = current calendar year (&0CYEAR&)

0HDCNT_CNT

Number of Employees

0QUALI_LAST

Number of Qualifications

0PRFCY_KYF

Proficiency

Crystal Reports

The following table contains Crystal Reports that use the BW query as a data source:

Crystal Report

Description

6LT1ARS9BT8LW710WA2VCA7BM

Development of qualifications – calendar year

9MAKXYTB7IUD24Z1CISER2XH2

Qualifications per organizational unit – calendar year

AQ5LTUUGMPITUR6ERLNU5ZG1I

Qualifications per employee – calendar year

CFADWSR8168M6O8I3L5G6GG6Q

Percentage distribution of qualifications – calendar year

See also:

Crystal Reports for SAP Manager Self-Service (MSS)