CO-OM: Costs and Allocations (Delta Extraction) (SAP Library

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.

Note

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.

Recommendation

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

Note

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

Note

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.

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