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 |
|
0COSTELMNT |
|
0CO_AREA |
|
0CURTYPE |
|
0PIOBJSV |
|
0PIOVALUE |
|
0METYPE |
|
0VERSION |
|
0VTDETAIL |
|
0VTYPE |
|
0DB_CR_IND |
|
0VALUATION |
|
0VTSTAT |
|
0FM_AREA |
|
0FUND |
|
0FUNC_AREA |
|
0GRANT_NBR |
|
0PFUND |
|
0PFUNC_AREA |
|
0PGRANT_NBR |
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 |
|
0FISCVARNT |
|
0FISCPER3 |
|
0FISCYEAR |
· 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 |
|
0QUANTITY |
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 |
|
0UNIT |