Entering content frame

Query Cost Center (Detail): Analysis - Plan/Actual - Costs & Quantities Locate the document in its SAP Library structure

Technical name: 0CCA_C11_Q0001

If you want to modify this query, note the special features of the 0CCA_C11 CO-OM-CCA: Costs and Allocations InfoCube

Use

This query provides the cost accountant and the cost center manager with an overview of the costs and consumption quantities incurred on a cost center in the reporting time frame. It enables you to make a plan or actual analysis of these costs taking cost elements, debits/credits and the corresponding allocation partners into account.

Unlike query 0CCA_C01_0015 (Cost Centers: Plan/Actual/Variance), query 0CCA_C11_Q0001 also contains delta datasets.

To enable you to enter delta datasets, DataSources have been created in the OLTP system for actual costs/quantities. These DataSources select the data from the COEP line item table. This enables additional fields to be transferred to the BIW, which are not contained in the COSP and COSS totals tables.

For more information, see Delta Extraction.

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

Filters

InfoObject

Description

0CO_AREA

Controlling area (variable 0P_COAR; single value entry, required)

0CURTYPE

Currency type (fixed value 10, company code currency)

0FISCVARNT

Fiscal year variant (SAP exit variable 0P_FVAEX)

 

Note

This query displays only true costs (VSTAT = 0).

 

User-Defined Characteristics

InfoObject

Description

0COSTCENTER

Cost center (variable 0S_CCTR)

0FISCPER

Fiscal year/period (variable 0I_FPER)

0PIOBJSV

Short partner

0PIOVALUE

Partner object

0PART_ACTTY

Activity type for the partner cost center

0PART_COORDER

Partner order

0PART_CCTR

Partner cost center

0GL_ACCOUNT

Structure link G/L Account

0CREDITOR

Structure link Vendor

0DEBITOR

Structure link Customer

 

Rows

InfoObject

Description

0COSTELMNT

Cost element

 

Columns

InfoObject

Description

Costs: Plan

Plan costs within the reporting timeframe (controlling area currency)

Costs: Actual

Actual costs within the reporting timeframe (controlling area currency)

Costs: Variance

Difference between plan and actual costs within the reporting timeframe

Costs: Variance (%)

Percentage variance between plan and actual costs with reference to the plan within the reporting time frame

Quantities: Plan

Plan quantity within the reporting timeframe

Quantities: Actual

Actual quantity within the reporting timeframe

Quantities: Variance

Difference between actual and plan quantities in the reporting time frame

Quantities: Variance (%)

Percentage variance between plan and actual quantities with reference to the plan within the reporting time frame

 

 

 

Leaving content frame