Attendances and Cancellations Month in Previous Year

Technical name: 0PE_C01_Q0201

Based on InfoCube: 0PE_C01

Use

This query displays attendances and cancellations 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.

Columns

InfoObject

Description of InfoObject (restriction or calculation formula)

0EVENTGROUP

Business Event Group

0EVENT

Business Event

0EVDAYS

Business Event Duration in Days

0EVHOURS

Business Event Duration in Hours

0C_REASON

Cancellation Reason

0EMPLOYEE

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

0EMPLPCT

Employment Percentage

0PAYPCT

Capacity Utilization Level in Percent

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0MAST_CCTR

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

0CO_MST_AR

Controlling Area of Master Cost Center

0ORGUNIT

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

0CALYEAR

Calendar Year

0CALMONTH

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

= current calendar month (&0CMONTH&)

0BOOKING_NO

Number of Attendances

0CANCEL_NO

Number of Cancellations

0BOOKINGFEE

Attendance Fee

0CANCELFEE

Cancellation Fee

0EVENTCOSTS

Business Event Costs

The key figures 0EVHOURS and 0EVDAYS are display attributes for the Business Event (0EVENT) characteristic. The key figures 0EMPLPCT and 0PAYPCT are display attributes for the Employee (0EMPLOYEE) characteristic.

Crystal Reports

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

Crystal Report

Description

CEI7N4VTRE7SDVL01XHH1G3O2

Attendances per organizational unit – monthly comparison

See also:

Crystal Reports for SAP Manager Self-Service (MSS)