Qualifications Month in Previous Year (Formatted Reporting)

Technical name: 0PAPD_C01_Q0201

Based on InfoCube: 0PAPD_C01

Use

This query displays employees’ qualifications for the month in the previous 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

0JOB

Job

0HRPOSITION

Position

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

0CALMONTH

Calendar Year/Month = current month of previous year (&0CMCMLY&)

= current calendar month (&0CMONTH&)

0CALYEAR

Calendar Year

0CO_MST_AR

Controlling Area of Master Cost Center

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

6LHXA53DYI3GMVRT7ZTY22D4M

Qualifications per employee – monthly comparison

9T88SRAJ30GB8IWLUUXSE2SQA

Qualifications per organizational unit – monthly comparison

9ZAFQPK3IKGU2ZF10THPCPVGY

Development of qualifications – monthly comparison

See also:

Crystal Reports for SAP Manager Self-Service (MSS)