Start of Content Area

Query Web: My Cost Centers – Key Figures – Current and YTD  Locate the document in its SAP Library structure

Technical name: 0CCA_C03_Q1000

Based on InfoCube CO-OM-CCA: Statistical Key Figures

Use

This query provides a comparison of the planned and actual values of statistical key figures for cost centers for the last four quarters. The variances are displayed by quarter.

You can personalize the controlling area and cost center(s) so that they are selected automatically. Without personalization, you must enter this information when you start the query.

See also: WEB: Personalization.

This query is designed for use in the Web Cockpit My Cost Centers – Current Situation.

IDs for integration with the Web Cockpit:

<BW_URL>&CMD=LDOC&WBID=6P6XSB4NMGAVES3DCTF431LKL&PAGEID=costctr_start

In the Web Cockpit, it functions together with the following query:

My Cost Centers – Key Figures – Quarterly

Note

This query is included in the workbook My Cost Centers – Key Figures – Current and YTD.

For background information on the concept of queries, see Queries in Controlling.

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0FISCVARNT

Fiscal year variant (SAP exit variable &OP_FVAEX&: the system derives the fiscal year variant from the controlling area)

0CO_AREA

Controlling area (variable &OP_COARP&, my controlling area, single value entry, personalization)

User-Defined Characteristics

InfoObject

Description

0COSTCENTER

Cost center (variable &0S_CCTRP&, my cost center, selection options, personalization)

Rows

Row Name

Description (or Restrictions or Calculation Formula)

0STKEYFIG

Statistical key figure

Columns

Column Name

Description (or Restrictions or Calculation Formula)

If an SAP exit variable is used, the time periods for which the quantities are calculated are determined automatically (see also Queries in Controlling under SAP Exit Time Variables).

Structure Quarters

 

Period &0T_FPER&

Characteristic: Fiscal Year/Period 0FISCPER, SAP exit variable &0P_PRFP1&, previous period of the current fiscal year

Year to Date &0T_FPERY&

Characteristic: Fiscal Year/Period 0FISCPER, SAP exit variable &0FYTCFP&, cumulated up to current period

Actual Quantity

0CCA_C03_RK002

Actual Quantity (Non-Cumulative Value)

0CCA_C03_RK004

Plan Quantity

0CCA_C03_RK001

Plan Quantity (Non-Cumulative Value)

0CCA_C03_RK003

Actual

Actual quantity + Actual quantity (non-cumulative value)

Plan

Planned quantity + Planned quantity (non-cumulative value)

Variance

Actual % plan

 

 

 

 

 

End of Content Area