Attendances and Cancellations Current Month

Technical name: 0PE_C01_Q0200

Based on InfoCube: 0PE_C01

Use

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

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

0CO_MST_AR

Controlling Area of Master Cost Center

0ORGUNIT

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

0CALMONTH

Calendar Year/Month = 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

60IMX7IOAIQRFOLXQQSMHIMLU

Attendances per organizational unit – current month

AHSDIUNCH2PJRH469P4TCARXU

Attendances per employee – current month

DZYSTG93C98BYFZB6G1H1J8XI

Attendances per business event – current month

0BRTQQV3QDS8EA0T5T4CS23UA

Cancellations per organizational unit – current month

65XGNI3SJAQN8AAWQT60LU5F6

Cancellations per employee – current month

1VI4CX519CBQT8WJKAWI8SF76

Cancellations per business event – current month

4B3Z8VAMHRB8MIBI1XHN8MS2A

Attendance costs per employee – TOP 10 - current month

DYIO6GAVVURJURR79ZVQBBA8I

Cancellation costs per employee – TOP 10 - current month

78IMN0EQX8L6566EWMFM5533M

Time consumed per organizational unit – current month

1UGC6U025OKJ4NUBLIBGALV9U

Time consumed per employee – current month

See also:

Crystal Reports for SAP Manager Self-Service (MSS)