Attendances and Cancellations Current Calendar Year

Technical name: 0PE_C01_Q0202

Based on InfoCube: 0PE_C01

Use

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

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 (&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

ASQ7J7EMJ0L7ATRZ3E7IVWRUA

Attendances per organizational unit – calendar year

2AS2XFRCI0ZVIXB62YHAFB2LY

Attendances per employee – calendar year

3EWEMPDHBI76X66RZZOKL9VCI

Attendances per business event – calendar year

1GL1BLF5DPRVI10OCM6R52S2A

Cancellations per organizational unit – calendar year

CFWBD7WIPY8RAKH1W78G09JMA

Cancellations per employee – calendar year

E8ZQ1XEQJZ5RKQI8FPGURDTW2

Cancellations per business event – calendar year

5E21LWY5K81WFL9WTWKHY3W5U

Attendance costs per employee – TOP 10 – calendar year

DUWWOP5BC43RHVLBU1I7X2D1U

Cancellation costs per employee – TOP 10 – calendar year

84E8W3BBVOBB5QM2I24CNOF06

Time consumed per organizational unit – calendar year

723BB8R7FACAMI7KZ56VSTS70

Time consumed per employee – calendar year

See also:

Crystal Reports for SAP Manager Self-Service (MSS)