Qualifications Current Month (Formatted Reporting)

Technical name: 0PAPD_C01_Q0200

Based on InfoCube: 0PAPD_C01

Use

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

0EGX2WQ38F5N7N5G98FWJYZ1Y

Percentage distribution of qualifications – current month

12Y2YNSM9HAOHU87IRQZF8IOI

Qualifications per organizational unit – current month

6EEAH5HEMIYEZAJHJZITS8R8Y

Development of qualifications – current month

ADBECJHW93C0NO0YC6RLVWJ2Q

Qualifications per employee – current month

See also:

Crystal Reports for SAP Manager Self-Service (MSS)