CO-OM-CCA: Activity Type Quantities and Prices (SAP Library

CO-OM-CCA: Activity Type Quantities and Prices

Technical name: 0CCA_C04

Use

This InfoCube contains all activity types that are entered in activity accounting. These were entered in plan and actual data based on quantity, and were transferred from the linked source system(s).

The InfoCube contains two types of data records, which have different key figures:

Quantities: Activity quantities, capacity, and so on

Prices, split

Note

You can also use this InfoCube to access your own fields. For more information, see Customer-Defined Fields.

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

Prerequisites in the SAP R/3 System

Before you can transfer actual prices into the BW, you need to calculate the actual prices.

Higher-Level Objects

Roles

This InfoCube provides information on the following subject:

0CCA_RO_0ROLE_COSTCENTER: Cost Center Accounting queries.

The following queries can access this InfoCube:

0CCA_C04_Q0002: Cost Center (Range): Analysis - Activity Quantity - Plan/Actual

CCA_C04_Q0004: Cost Center (Range): Analysis - Activity Type Price

0CCA_C04_Q0001: Cost Center (Detail): Analysis - Activity Quantity - Plan/Actual

0CCA_C04_Q0003: Cost Center (Detail): Analysis - Activity Type Price

0CCA_C04_Q0007: Cost Center (Detail): Analysis - Activity Type Price - Split

0CCA_C04_Q0005: Cost Center (Detail): Activity Quantity - Plan/Actual - Periods

0CCA_C04_Q0006: Cost Center (Detail): Planing Current Year/Comparison to Previous Year

0CCA_C04_Q0008: Cost Center (Detail): Activity Type Price - Plan/Actual - Periods

Notes on Query Definition

If you try to total across different valuation views and currency types, your query results will be incorrect. Calculating sums across different values of these characteristics does not serve any useful purpose

You can only calculate the totals if you restrict enough characteristics

For price reports, you need to restrict the currency type (0CURTYPE) in the query filter.

InfoSources

0CO_OM_CCA_3: Cost Centers: Activity Types

0CO_OM_CCA_8: Cost Centers: Prices

Loading Behavior

To keep the data to a minimum that is loaded into the BW, you should use the following characteristics to restrict the selection:

0CURTYPE Currency type

0VTYPE Value type for reporting

Each time you upload data, the system adds it to the existing values. You should therefore delete any existing values before repeating an upload.

Recommendation

SAP recommends that you load an InfoPackage (using certain characteristics, for example, FISCPER; selected dataset) for each posting period, once periodic tasks are complete. This has the advantage that you do not need to delete as much data when you reload. InfoPackages that are already complete can be retained.

Characteristics

InfoObject	Description
0COSTCENTER	Cost center
0ACTTYPE	Activity type
0CO_AREA	Controlling area
0METYPE	Key figure type
0VERSION	Version
0VTYPE	Value type for reporting
0VALUATION	Valuation view
0ACTPRIND	Price indicator
0CURTYPE	Currency type
0COSTCOMP	Cost component
0CCOMPSTRUC	Cost component structure

Navigation Attributes

The following navigation attributes have been activated: This is a sample selection. You are free to activate additional attributes, or deactivate attributes to improve performance.

InfoObject	Description
0COSTCENTER__PROFIT_CTR	Profit center

Time Characteristics

InfoObject	Description
0FISCPER	Fiscal year/period
0FISCVARNT	Fiscal year variant
0FISCPER3	Posting period
0FISCYEAR	Fiscal year

Key Figures

InfoObject	Description
0ACT_OUTPUT	Output
0ACT_CAPACT	Capacity
0ACT_QUANTY	Activity quantity
0ACT_SCHEDL	Scheduled activity quantity
0PRICE	Total price, no split
0PRICEFX	Fixed price, no split
0PRICEVR	Variable price, no split
0PRICECOM	Total price, split
0PRICECOMFX	Fixed price, split
0PRICECOMVR	Variable price, split
0PRICE_BASE	Price base quantity

Restricted Key Figures

The restricted key figures are divided into several groups.

Note

The basic key figures cannot be used without restricting some of the characteristics. For this reason you should use only the supplied restricted key figures in Queries you have defined yourself, or analyze the supplied restricted key figures and modify them to suit your requirements.

InfoObject	Restriction
"Price" Group
Data for all restricted key figures of the group	Valuation view = 0 (legal valuation) Version = 0 (current variant) Key figure = 0PRICECOM (Total price, split)
0CCA_C04_RK002 Actual price	Price indicator = 7, 6, 5 Key figure category = 1030 (overhead cost prices) Value type = 10 (actual)
0CCA_C04_RK010 Actual price, fixed	Price indicator = 7, 6, 5 Key figure category = 1030 (overhead cost prices) Value type = 10 (actual)
0CCA_C04_RK011 Actual price, variable	Price indicator = 7, 6, 5 Key figure category = 1030 (overhead cost prices) Value type = 10 (actual)
0CCA_C04_RK001 Plan price	Price indicator = 3, 2, 1 Key figure category = 1030 (overhead cost prices) Value type = 20 (plan)
0CCA_C04_RK012 Plan price, fixed	Price indicator = 3, 2, 1 Key figure category = 1030 (overhead cost prices) Value type = 20 (plan)
0CCA_C04_RK013 Plan price, variable	Price indicator = 3, 2, 1 Key figure category = 1030 (overhead cost prices) Value type = 20 (plan)
"Quantities" Group
Data for all restricted key figures of the group	Key figure category = 2030 (activity quantities) Version = 0 (current variant)
0CCA_C04_RK008 Scheduled activity	Value type = 20 (plan) Key figure = 0ACT_SCHEDU (quantity)
0CCA_C04_RK004 Actual activity	Value type = 10 (actual) Key figure = 0ACT_QUANTY (activity quantities)
0CCA_C04_RK003 Plan activity	Value type = 20 (plan) Key figure = 0ACT_QUANTY (activity quantities)
0CCA_C04_RK009 Allocated activity	Value type = 10 (actual) Key figure = 0ACT_SCHEDU (quantity)
0CCA_C04_RK007 Capacity (Plan)	Value type = 20 (plan) Key figure = 0ACT_CAPACT (capacity)
0CCA_C04_RK_005 Plan output	Value type = 20 (plan) Key figure = 0ACT_OUTPUT (output)
"Price Base Quantity" Group
0CCA_C04_RK015 Actual price - base quantity	Value type = 10 (actual) Key figure = 0PRICE_BASE (price base quantity)
0CCA_C04_RK014 Plan price - base quantity	Value type = 20 (plan) Key figure = 0PRICE_BASE (price base quantity)

Note

All restricted key figures for prices are based on the basic key figure total price, split (0PRICECOM), fixed price, split (0PRICECOMFX), variable price, split (0PRICECOMVR). The basic key figures total price, not split (0PRICE), fixed price, not split (0PRICEFX), variable price, not split (0PRICEVR) can only be used without a drilldown if by cost element. They are kept for the sake of data consistency in the InfoCube.
Use only restricted key figures in user-defined queries Check the restricted key figures provided by SAP and if required, define your own restricted key figures accordingly.

Units

InfoObject	Description
0ACT_UNIT	Activity unit
0OUTP_UNIT	Output unit
0CURRENCY	Currency key

Note

In data records for activity quantities, there are entries in the following key figures only: Output (0ACT_OUTPUT), Capacity (0ACT_CAPACT), Activity quantity (0ACT_QUANTY), and Scheduled activity quantity (0ACT_SCHEDL). The following characteristics do not have entries for data records for activity quantities: Valuation view (0VALUATION), Price indicator (0ACTPRIND) and Currency type (0CURTYPE)

In data records for activity prices, there are entries in the following key figures only: Total price (0PRICE), Fixed price (0PRICEFX), Variable price (0PRICEVR), Total price, split (0PRICECOM), Fixed price, split (0PRICECOMFX), Variable price, split (0PRICECOMVR). The 0CO_OM_CCA_8 (cost centers: prices) InfoCube provides the entries for the following characteristics, using data from the OLTP system: Valuation view (0VALUATION), Price indicator (0ACTPRIND) and Currency type (0CURTYPE).

Note

The fiscal year (0FISCYEAR) and posting period (0FISCPER3) characteristics are filled by the fiscal year period field (0FISCPER) in the InfoSource.