CO-OM-OPA: Costs and Allocations

Technical name: 0OPA_C11

Use

This InfoCube contains all costs and quantities on internal orders (plan and actual using delta extraction, budget, commitment) that were transferred from the source system(s). The InfoCube also contains the extended partner information (such as partner cost center with master data) for the allocation relationships.

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.

If you copy the Cube, note the following:

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

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

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

The following queries can access this InfoCube:

·         0OPA_C11_Q0002: Internal Order (Detail): Plan/Actual

·         0OPA_C11_Q0005: Internal Orders (Group): Budget/Actual/Commitment

·         0OPA_C11_Q0007: Internal Orders (Group): Total Plan/Actual/Commitment

·         0OPA_C11_Q0003: Internal Orders (Group): Plan/Actual

·         0OPA_C11_Q0004: Internal Orders (List): Budget/Actual/Commitment

·         0OPA_C11_Q0006: Internal Orders (List): Total Plan/Actual/Commitment

·         0OPA_C11_Q0001: Internal Orders (List): Plan/Actual

·         0OPA_C11_Q0302: PSM: Internal Order (Detail): Plan/Actual

·         0OPA_C11_Q0303: PSM: Internal Orders (Group): Plan/Actual

·         0OPA_C11_Q0301: PSM: Internal Orders (List): Plan/Actual

Notes on Query Definition

If you attempt to sum across different valuation views and currency types, your query results will be incorrect. Summing across different values of these characteristics does not provide useful information.

InfoSources

·         0CO_OM_OPA_1: Internal Orders: Costs and Allocations

·         0CO_OM_OPA_2: Internal Orders: Budget

·         0CO_OM_OPA_3: Internal Orders: Overall/Annual Plan Values

·         0CO_OM_OPA_5: Internal Orders: Accruals

·         0CO_OM_OPA_6: Internal Orders: Actual Costs using Delta Extraction

Loading Behavior

The InfoCube is provided with information from InfoSources 0CO_OM_OPA_1 and 0CO_OM_OPA_2, 0CO_OM_OPA_3 , 0CO_OM_OPA_5 and 0CO_OM_OPA_6. 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_OPA_6 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 InfoSource 0CO_OM_OPA_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 the 0CO_OM_OPA_1 InfoSource to this InfoCube.

The Costs and Allocations (Orders) (0OPA_C11) InfoCube contains the content of the older InfoCube release Costs and Allocations (Orders, 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_OPA_1 Orders: Costs and Allocations, then load your old data for the required period of time.

Characteristics

InfoObject

Description

0COORDER

Order number

0COSTELMNT

Cost element

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

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

0COORDER__0COORD_TYPE

Order type

0COORDER__0CO_AREA

Controlling area

0COORDER__0PROFIT_CTR

Profit center

0COORDER__0RESP_CCTR

Responsible cost center

0COORDER__0STATUSSYS0

Status

Time Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0FISCVARNT

Fiscal year variant

0FISCPER3

Posting period

0FISCYEAR

Fiscal year

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

·        The characteristics and the cost element are not filled for overall budgets or overall plan values. The posting period and the cost element characteristic are not filled for annual budgets or annual plan values. This provides values with the format of 000.YYY (Y = the fiscal year), particularly for the 0FISCPER characteristic.

Key Figures

InfoObject

Description

0AMOUNT

Amount

0QUANTITY

Consumption quantity

Restricted Key Figures

The restricted key figures are divided into several 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

“Costs” 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 = 0AMOUNT (amount)

0OPA_C11_RK002 Actual costs

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

Value type = 10 (actual)

0OPA_C11_RK0016 Planned costs

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

Value type = 20 (plan)

0OPA_C11_RK0001 Settled costs

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

Value type = 10 (actual)

0OPA_C11_RK0014 Commitments

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

Value type = 40 (commitment)

0OPA_C11_RK0002 Budget (per fiscal year)

Value type = 50 (budget)

0OPA_C11_RK0010 overall planning (per fiscal year)

Value type = 20 (plan)

“Revenues” Group

Data for all restricted key figures of the group

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

Key figure category = 1001 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0QUANTITY (quantity)

0OPA_C11_RK0011 Actual revenue

Value type = 10 (actual)

0OPA_C11_RK0015 Planned revenue

Value type = 20 (plan)

“Quantities” 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)

Key figure = 0QUANTITY (quantity)

0OPA_C11_RK010 Actual consumption quantity

Value type = 10 (actual)

0OPA_C11_RK009 Plan consumption quantity

Value type = 20 (plan)

“WIP” Group

Data for all restricted key figures of the group

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

Key figure category = 1410 (inventory (WIP))

Valuation view = 0 (legal valuation), version = results analysis version

Value type = 80 (results analysis)

Key figure = 0AMOUNT (amount)

0OPA_C11_RK0021 WIP: Revenue in excess of billings

Detail for value type = 10

0OPA_C11_RK0023 WIP: Work in process

Detail for value type = 1, 2

0OPA_C11_RK0022 WIP: Cannot be activated

Detail for value type = 3

“Results” Group

Data for all restricted key figures of the group

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

Key figure category = 1400 (accrual calculation)

Valuation view = 0 (legal valuation)

Version = accrual version

Value type = 80 (results analysis)

Key figure = 0QUANTITY (quantity)

0OPA_C11_RK0003 Revenue affecting net income

Detail for value type = 12

0OPA_C11_RK0004 Cost of sales

Detail for value type = 3, 4

0OPA_C11_RK0005 Cost of sales (cannot be activated)

Detail for value type = 5

0OPA_C11_RK0006 Realized loss

Detail for value type = 11

0OPA_C11_RK0007 Reserves for imminent losses

Detail for value type = 1

0OPA_C11_RK0008 Reserves for imminent losses - inclusion cannot be activated

Detail for value type = 2

0OPA_C11_RK0008 Loss

Detail for value type = 10

“Reserves” Group

Data for all restricted key figures of the group

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

Key figure category = 1420 (reserves)

Valuation view = 0 (legal valuation), version = results analysis version

Value type = 80 (results analysis)

Key figure = 0AMOUNT (amount)

0OPA_C11_RK0017 Reserve: unrealized costs

Detail for value type = 1, 2

0OPA_C11_RK0018 Reserve: unrealized costs, not capitalized

Detail for value type = 3

Units

InfoObject

Description

0CURRENCY

Currency key

0UNIT

Unit of measure