CO-OM: Costs and Allocations (Delta Extraction)

Technical name: 0COOM_C02

Use

This InfoCube contains all costs and quantities on cost centers, internal orders, WBS elements, networks, network activities, and network activity elements that were downloaded from the source systems using delta extraction. The InfoCube also contains the partner information for the allocation relationships.

Before you make entries in this InfoCube, you need to load the master data for orders, WBS elements, networks and network activities. If you do not do so, the system cannot determine the responsible cost center or enter it in 0COSTCENTER.

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.

Higher-Level Objects

Queries

The following queries can access this InfoCube:

·         0COOM_C02_Q0004: Cost Center Orders: Plan/Actual - Situation

·         0COOM_C02_Q0002: Account Assignment Objects for the Cost Center: Plan/Actual - Situation

·         0COOM_C02_Q0003: Cost Center: Plan/Actual - Situation

·         0COOM_C02_Q0005: WBS Elements for the Cost Center: Plan/Actual - Situation

·         0COOM_C02_Q0303: PSM: Cost Center: Plan/Actual - Situation

·         0COOM_C02_Q0304: PSM: Cost Center Orders: Plan/Actual - Situation

·         0COOM_C02_Q0305: PSM: WBS Elements for Cost Center: Plan/Actual - Situation

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_CCA_9 Cost Centers: Actual Costs with Delta Extraction

·        0CO_OM_CCA_1 Cost Centers: Costs

·        0CO_OM_OPA_6 Internal Orders: Actual Costs Using Delta Extraction

·        0CO_OM_OPA_1 Internal Orders: Costs

·        0CO_OM_WBS_6 WBS Elements: Actual Costs Using Delta Extraction

·        0CO_OM_WBS_1 WBS Elements: Costs

·        0CO_OM_NTW_2 Network: Actual Costs Using Delta Extraction

·        0CO_OM_NTW_1 Networks: Costs

·        0CO_OM_NWA_2 Network Activity: Actual Costs Using Delta Extraction

·        0CO_OM_NWA_1 Network Activities: Costs

·        0CO_OM_NAE_2 Network Activity Elements: Actual Costs Using Delta Extraction

·        0CO_OM_NAE_1 Network Activity Elements: Costs

Loading Behavior

The InfoCube is supplied with information from the above mentioned InfoSources. 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 InfoSources 0CO_OM_CCA_9, 0CO_OM_OPA_6, 0CO_OM_WBS_6, 0CO_OM_NTW_2,  0CO_OM_NWA_2 and 0CO_OM_NAE_2 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 InfoSources 0CO_OM_CCA_1, 0CO_OM_OPA_1, 0CO_OM_WBS_1, 0CO_OM_NTW_1, 0CO_OM_NWA_1 and 0CO_OM_NAE_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.

Characteristics

InfoObject

Description

0COSTCENTER

Cost center

0COORDER

Order number

0WBS_ELEMT

WBS element

0NETWORK

Network

0PROJECT

Project definition

0ACTY_ELEMT

Network activity element

0ACTIVITY

Network activity

0PROFIT_CTR

Profit center

0COSTELEMT

Cost element

0CO_AREA

Controlling area

0CURTYPE

Currency type

0PIOJSV

Partner object type

0IOBJSV

InfoObject (4 characters)

0PIOVALUE

Partner object

0VERSION

Version

0VTDETAIL

Details of value type

0VTYPE

Value type for reporting

0VTSTAT

Statistics indicator for the value type (= 0)

0DB_CR_IND

Sender/receiver indicator

0VALUATION

Valuation view

0METYPE

Key figure type

0CHRTS_ACCTS

Chart of accounts

0GL_ACCOUNT

G/L account

0CREDITOR

Vendor

0DEBITOR

Customer

0AUXACCTYPE

Type of auxiliary account assignment

0AUXACCVAL

Auxiliary account assignment

0COMP_CODE

Company code

0BUS_AREA

Business area

0FUNC_AREA

Functional area

0PCOMP_CODE

Partner company code

0PFUNC_AREA

Partner functional area

0PLANT

Plant

0MATERIAL

Material

0EMPLOYEE

Employee

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

The system enters the responsible cost center for the order, WBS element, network, network activities, and network activity elements in the 0COSTCENTER (cost center) InfoCube. This takes place in the data records for orders, WBS elements, networks, and network activities.

The system determines the responsible cost center in the routine for the update rule from the master data of the order, WBS element, network, network activity, or the network activity element.

In data records for cost centers, entries are not made in the following InfoObjects: 0COORDER (order), 0WBS_ELEMT (WBS element), 0NETWORK (network), 0ACTIVITY (network activity) and 0ACTY_ELEMT (network activity element).

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

0COSTCENTER__0PROFIT_CTR

Profit center

Time Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0FISVARNT

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

0QUANTITYFX

Fixed consumption quantity

0QUANTITY

Consumption quantity

0QUANTITYVR

Variable consumption quantity

0AMOUNTFX

Fixed amount

0AMOUNT

Amount

0AMOUNTVR

Variable amount

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

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

Key figure category = 1000 (revenues and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0AMOUNT (amount)

0COOM_C02_RK001 Actual costs

Value type = 10 (actual)

0COOM_C02_RK003 Planned costs

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

0COOM_C02_RK005 Actual revenues

Value type = 10 (actual)

0COOM_C02_RK006 Planned revenue

Value type = 20 (plan)

“Credits” Group

Data for all restricted key figures of the group

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

Key figure category = 1000 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0AMOUNT (amount)

0COOM_C02_RK008 Actual credit

Value type = 10 (actual)

0COOM_C02_RK009 Plan credit

Value type = 20 (plan)

Units

InfoObject

Description

0CURRENCY

Currency key

0UNIT

Unit of measure