Attendances and Cancellations Previous Year

Technical name: 0PE_C01_Q0203

Based on InfoCube: 0PE_C01

Use

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

0EVHOURS

Business Event Duration in Hours

0EVDAYS

Business Event Duration in Days

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 = current calendar year-1 (&0CYEAR&-1)

= current calendar year (&0CYEAR&)

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

6X2J4VR80ARE6046IVQC8CXDE

Attendances per organizational unit – annual comparison

5AXCTW0OYAMUJOQURIB4L4OSY

Attendances per business event – annual comparison

ACNRWLLE6I0VLGXNDQML7X3P8

Cancellations per organizational unit – annual comparison

5FRHM0SPK5HEHZU7DHED0YWAK

Cancellations per employee – annual comparison

69D9J704XHA3RSVFFVI1CLEAA

Cancellations per business event – annual comparison

57DDNIZPU3ET52OWZEMR7YQ36

Time consumed per employee – annual comparison

See also:

Crystal Reports for SAP Manager Self-Service (MSS)