CO-OM-CCA: Costs and Allocations

Technical name: 0CCA_C11

Use

This InfoCube contains all costs and quantities on cost centers (plan and actual using delta-extraction) that were transferred from the source system(s). In addition to complete information on variances, the InfoCube also contains the extended partner information (such as the partner cost center with master data) for the allocation relationships.

In allocations, the cost center can function as the sender or receiver of activities (quantities) or costs. The cost centers are credited or debited accordingly.

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

If you copy the Cube, note the following:

Both InfoSources for this cube can supply actual data. Do not create any InfoPackages with value type 10 for InfoSource 0CO_OM_CCA_1.

In the Cube supplied in the standard system, such double loading is prevented by the update rule.

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

Prerequisites in the SAP R/3 System

When you allocate activity from cost centers to internal orders, you can significantly reduce the memory requirements by deactivating or only partially activating the partner update for the corresponding internal orders.  The SAP R/3 system creates only one totals record on the allocating cost center, in which the values for all internal orders (to which the allocations are made) are cumulated. If you only partially activated the partner update, the partner information remains on the affected internal orders.

Higher-Level Objects

Queries

The titles of the Queries provide information on the contents and intended users. “Range” queries supply data on multiple objects, while “Detail” queries supply more specific information. “Analysis” queries are intended for cost management specialists. The other queries are intended for persons responsible for specific objects (such as cost center managers).

The following queries can access this InfoCube:

·         0CCA_C11_Q0052: Cost Center (Range): Actual Costs - Periods

·         0CCA_C11_Q0051: Cost Center (Range): Actual Costs - Quarterly

·         0CCA_C11_Q0050: Cost Center (Range): Actual Costs - Situation

·         0CCA_C11_Q0062: Cost Center (Range): Plan/Actual - Periods

·         0CCA_C11_Q0061: Cost Center (Range): Plan/Actual - Quarterly

·         0CCA_C11_Q0060: Cost Center (Range): Plan/Actual - Situation

·         0CCA_C11_Q0066: Cost Center (Range): Target/Actual - Periods

·         0CCA_C11_Q0065: Cost Center (Range): Target/Actual - Quarterly

·         0CCA_C11_Q0064: Cost Center (Range): Target/Actual - Situation

·         0CCA_C11_Q0055: Cost Center (Range): Analysis - TOP N - Internal Activities

·         0CCA_C11_Q0054: Cost Center (Range): Analysis - TOP N - Vendors

·         0CCA_C11_Q0072: Cost Center (Range): Planning Current Year/Previous Year

·         0CCA_C11_Q0070: Cost Center (Range): Planning - Periods

·         0CCA_C04_Q0001: Cost Center (Detail): Analysis - Plan/Actual - Costs and Quantities

·         0CCA_C11_Q0012: Cost Center (Detail): Debit/Credit - Current Year/Previous Year

·         0CCA_C11_Q005: Cost Center (Detail): Actual Debit/Credit - Periods

·         0CCA_C11_Q0014: Cost Center (Detail): Actual/Actual - Periods

·         0CCA_C11_Q0011: Cost Center (Detail): Actual/Actual - Current Year/Previous Year

·         0CCA_C11_Q0013: Cost Center (Detail): Actual/Actual - Quarterly

·         0CCA_C11_Q004: Cost Center (Detail): Actual/Plan - Periods

·         0CCA_C11_Q0002: Cost Center (Detail): Actual/Plan - Situation

·         0CCA_C11_Q0010: Cost Center (Detail): Planning Year

·         0CCA_C11_Q007: Cost Center (Detail): Planning - Periods

·         0CCA_C11_Q008: Cost Center (Detail): Target/Actual - Periods

·         0CCA_C11_Q007: Cost Center (Detail): Target/Actual - Quarterly

·         0CCA_C11_Q006: Cost Center (Detail): Target/Actual - Situation

·         0CCA_C11_Q003: Cost Center (Detail): Actual/Plan - Quarterly

·         0CCA_C11_Q0302: PSM: Cost Center (Detail): Actual/Plan - Situation

·         0CCA_C11_Q0304: PSM: Cost Center (Detail): Actual/Plan - Periods

·         0CCA_C11_Q0350: PSM: Cost Center (Range): Actual Costs - Situation

·         0CCA_C11_Q0360: PSM: Cost Center (Range): Plan/Actual - Situation

Notes on Query Definition

If you try to total across different valuation views and currency types, your query results are incorrect as a result. Totaling across different values of these characteristics is not useful.

InfoSources

·         0CO_OM_CCA_9:    Cost Centers: Actual Costs with Delta Extraction

·         0CO_OM_CCA_1:    Cost Centers: Costs and Allocations

Loading Behavior

The InfoCube is provided with information from InfoSources 0CO_OM_ABC_1 and 0CO_OM_ABC_7. This requires a special procedure when loading the data from the source systems into the Cube. We recommend the following procedure:

·        Create an InfoPackage for InfoSource 0CO_OM_CCA_9 to load the actual data.

Ў        Case A (with delta process): If you use the delta process, you can load your actual data at any time. You do not need to enter the period.

Ў        Case B (without delta process): If you do not use the delta process, it is best to load your actual data at the end of the period (after completion of the period-end closing process) by restricting the selection to the expired period.

SAP recommends the delta process.

·        To load the remaining data (such as plan, target or period-end closing) for your InfoSource 0CO_OM_CCA_1, create a separate InfoPackage for each type of data. This is necessary because of the different data transfer time points. Restrict selection to the relevant value type (such as plan) and the period or periods (such as 1 – 3 for the first quarter or 1 – 12 for the full year).

·        For more information on loading data, see InfoCubes in Controlling.

It is not possible to load actual data with this InfoSource.

The Costs and Allocations (Cost Centers) (0CCA_C11) InfoCube contains the content of the older InfoCube release Costs and Allocations (Full Costs, old version).

If you want to provide the new cube with old data from a previous cube, create an InfoPackage for the corresponding InfoSource, 0CO_OM_CCA_1 Cost Centers: Costs and Allocations, then load your old data for the required period of time.

Characteristics

InfoObject

Description

0COSTCENTER

Cost center

0COSTELMNT

Cost element

0PART_CCTR

Partner cost center

0PART_ACTTY

Activity type of partner cost center

0PART_COORDER

Partner order

0CO_AREA

Controlling area

0CURTYPE

Currency type

0PIOBJSV

Partner object type

0PIOVALUE

Partner object

0METYPE

Key figure category

0VERSION

Version

0VTDETAIL

Details of value type

0VTYPE

Value type for reporting

0DB_CR_IND

Sender/receiver indicator

0VALUATION

Valuation view

0VTSTAT

Statistics indicator for value type

0DEBITOR

Customer number

0CREDITOR

Vendor number

0GL_ACCOUNT

G/L account

0CHRT_ACCTS

Chart of accounts

0FM_AREA

FM area

0FUND

Fund

0FUNC_AREA

Functional area

0GRANT_NBR

Grant

0PFUND

Partner fund

0PFUNC_AREA

Partner functional area

0PGRANT_NBR

Partner grant

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__0PROFIT_CTR

Profit center

Time Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0FISCVARNT

Fiscal year variant

0FISCPER3

Posting period

0FISCYEAR

Fiscal year

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

Key Figures

InfoObject

Description

0AMOUNT

Amount

0QUANTITY

Consumption quantity

Restricted Key Figures

The restricted key figures are divided into four groups.

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

“Variance Category” Group

Data for all restricted key figures of the group

Key figure category = 1300 (variance)

Valuation view = 0 (legal valuation)

Version = &0P_SVERS& (target cost version, single value entry, required)

Value type = 70 (variance)

Key figure = 0AMOUNT (amount)

0CCA_C16_RK030 Input price variance

Detail for value type = 1

0CCA_C11_RK015 Input quantity variance

Detail for value type = 4

0CCA_C11_RK032
Resource usage variance

Detail for value type = 6

0CCA_C11_RK033 Remaining input variance

Detail for value type = 11

0CCA_C11_RK034 Total input variance

Sum of the above variance types / Detail for value type = 1; 4; 6 and 11

0CCA_C11_RK035 Output price variance

Detail for value type = 21

0CCA_C11_RK036 Output quantity variance

Detail for value type = 24

0CCA_C11_RK037 Fixed cost variance

Detail for value type = 22

0CCA_C11_RK040 Remaining variance

Detail for value type = 31

0CCA_C11_RK038 Total output variance

Sum of the above four variance types / Detail for value type = 21; 22; 24 and 31

0CCA_C11_RK039 Total variance

Sum of all variance types / No further restrictions

“Credits” Group

Data for all restricted key figures of the group

Sender/receiver = H (credit posting or sender debit)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0AMOUNT (amount)

0CCA_C11_RK010 Actual credit: Revenues

Detail for value type = 1

Value type = 10 (actual)

Statistics ID = 1

Key figure category = 1001 (revenues and associated quantities)

0CCA_C11_RK006 Actual credit: IAA

Detail for value type = 4

Value type = 10 (actual)

Key figure category = 1000 (costs and associated quantities)

0CCA_C11_RK005 Actual credit: Allocation to Profitability Analysis

Partner object type = 0PSG (profitability segment)

Detail for value type = 3

Value type = 10 (actual)

Key figure category = 1000 (costs and associated quantities)

0CCA_C11_RK006 Actual credit: Allocations

Partner object type is not 0PSG (profitability segment)

Detail for value type = 3

Value type = 10 (actual)

Key figure category = 1000 (costs and associated quantities)

0CCA_C11_RK008 Actual credit

Key figure category = 1000 (costs and associated quantities) and 1001 (revenues and associated quantities)

Value type = 10 (actual)

0CCA_C11_RK007 Plan credit

Key figure category = 1000 (costs and associated quantities) and 1001 (revenues and associated quantities)

Value type = 20 (plan)

“Costs” Group

Data for all restricted key figures of the group

Sender/receiver = S (debit posting or receiver debit)

Key figure category = 1000 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Statistics indicator = 0

Key figure = 0AMOUNT (amount)

0CCA_C11_RK002 Actual costs

Value type = 10 (actual)

0CCA_C11_RK001 Planned costs

Value type = 20 (plan)

0CCA_C11_RK003 Target costs

Value type = 30 (target)

“Quantities” Group

Data for all restricted key figures of the group

Key figure category = 1000 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0QUANTITY (quantity)

0CCA_C11_RK025 Actual activity quantity

Sender/receiver = H (credit posting or sender debit)

Value type = 10 (actual)

0CCA_C11_RK024 Plan activity quantity

Sender/receiver = H (credit posting or sender debit)

Value type = 20 (plan)

0CCAC11_RK005 Commitments

Sender/receiver = S (debit posting or receiver debit)

Statistics indicator = 0

Value type = 40

0CCA_C11_RK021 Actual consumption quantity

Sender/receiver = S (debit posting or receiver debit)

Statistics indicator = 0

Value type = 10 (actual)

0CCA_C11_RK020 Plan consumption quantity

Sender/receiver = S (debit posting or receiver debit)

Statistics indicator = 0

Value type = 20 (plan)

0CCA_C116_RK022 Target consumption quantity

Sender/receiver = S (debit posting or receiver debit)

Statistics indicator = 0

Value type = 30 (target)

Units

InfoObject

Description

0CURRENCY

Currency key

0UNIT

Unit of measure