Show TOC

 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 are 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 Note

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

    End of the note.

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

Prerequisites for the ERP System

Before you can transfer actual prices into SAP NetWeaver BI, you need to calculate the actual price. For additional information on the actual price calculation, choose Start of the navigation path SAP ERP Central Component Next navigation step Accounting Next navigation step Controlling (CO) Next navigation step Cost Center Accounting (CO-OM-CCA) Next navigation step Period-End Closing (CO-OM-CCA) Next navigation step Actual Price Calculation End of the navigation path .

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:

Notes on Query Definition

  • If you try to total across different valuation views and currency types, your query results will be incorrect. Totaling across different values for 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

Loading Behavior

  • To keep the data to a minimum that is loaded into the BI, you are advised to use the following characteristics to restrict the selection:

    • 0CURTYPE Currency type

    • 0VTYPE Value type for reporting

  • Every time you upload data, the system adds it to the existing values. You should, therefore delete existing values where necessary, before repeating uploading.

    Recommendation 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 procedure has an advantage, in that you do not need to delete as much data when you reload. InfoPackages that are already complete, can be kept.

    End of the recommendation.

Characteristics

Info Object

Description

0COSTCENTER

Cost Centers

0ACTTYPE

Activity Type

0CO_AREA

Controlling Area

0METYPE

Key Figure Category

0VERSION

Version

0VTYPE

Value type for Reporting

0VALUATION

Valuation View

0ACTPRIND

Price Indicator

0CURTYPE

Currency Type

0COSTCOMP

Cost Component

0CCOMPSTRUC

Cost Component Structure

Navigational 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.

Info Object

Description

0COSTCENTER__PROFIT_CTR

Profit center

Time Characteristics

Info Object

Description

0FISCPER

F iscal Year/Period

0FISCVARNT

Fiscal Year Variant

0FISCPER3

Posting Period

0FISCYEAR

Fiscal Year

Key Figures

Info Object

Description

0ACT_OUTPUT

Output

0ACT_CAPACT

Capacity

0ACT_QUANTY

Activity Quantity

0ACT_SCHEDL

Scheduled Activity Quantity

0PRICE

Price, No Split (Total Cost)

0PRICEFX

Price, No Split (Fixed Cost)

0PRICEVR

Price, No Split (Variable Cost)

0PRICECOM

Price, Split (Total Cost)

0PRICECOMFX

Price, Split (Fixed Cost)

0PRICECOMVR

Price, Split (Variable Cost)

0PRICE_BASE

Price Base Quantity

Restricted Key Figures

The restricted key figures are divided into several groups.

Note 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.

End of the note.

Info Object

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 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.

End of the note.

Units

Info Object

Description

0ACT_UNIT

Activity Unit

0OUTP_UNIT

Output Unit

0CURRENCY

Currency Key

Note 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).

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

End of the note.