on 05-12-2009 1:00 AM
Hi All,
I have 0CO_OM_OPA6 extractor which is for actuals so it extracts value type 10 to bw cube.
Now as per requirements i need to get value type (0VTYPE) 20 into the cube.
I know there is extractor 0CO_OM_OPA_3 extractor which is designed for plan. Which are the tables behind this extractor ? can some one give me the names of the tables ?
is there anyother way i can get value type for plan ?
Thanks,
KS
Please see note note 573962.
This note returns background information for the totals record and line item DataSources for costs in the area of overhead controlling.
These are DataSources for objects with an account assignment:
Cost center,
Process costs,
Requests,
WBS element,
Network,
Network activity and
Network activity element.
The following questions are answered in this note:
Why are there two different DataSources that extract costs for an object with an account assignment?
For which value types do the DataSources return data?
Which DataSources are delta-compatible?
When do the line item DataSources sometimes return values for the costs other than the totals records DataSources?
How do I avoid duplicate values for costs in the InfoCube?
Which selections should I use with the extraction?
7000000220000001
70000003
Some information is missing.
70000004
Why are there two different DataSources that extract costs for an object with an account assignment?
For which value types do the DataSources return data?
Which DataSources are delta-compatible?
Answer
Totals record DataSources
There is one totals record DataSource for each of the objects with an account assignment.
These are specifically the following DataSources: 0CO_OM_CCA_1, 0CO_OM_ABC_1, 0CO_OM_OPA_1, 0CO_OM_WBS_1, CO_OM_NTW_1, 0CO_OM_NWA_1, 0CO_OM_NAE_1.
The DataSources extract data for the following BW value types, InfoObject
0VTYPE:
10 Actual,
40 Commitment,
20 Cost element planning values
at totals record level from the COSS and COSP database tables.
Furthermore, target costs are still calculated for cost centers from the cost element planning values if the BW value type
30 Target
is selected explicitly.
The totals record DataSources do not support a delta extraction.
Line item DataSources
There is also one line item DataSource for each object with an account assignment.
These are specifically the following DataSources: 0CO_OM_CCA_9, 0CO_OM_ABC_7, 0CO_OM_OPA_6, 0CO_OM_WBS_6, CO_OM_NTW_2, 0CO_OM_NWA_2, 0CO_OM_NAE_2.
These DataSources only return data for the BW value type
10 Actual.
These are actual line items that are read via the COVP view from the COBK and COEP tables.
The line item DataSources support the delta extraction of data.
When do the line item DataSources sometimes return values for the costs other than the totals records DataSources?
Answer
The actual line item DataSources do not deliver any data from R/3 for historical periods if the line item information for these periods were already archived in R/3. We recommend that you then load the actual data for the historical periods into BW through the totals record DataSources.
5. How do I avoid duplicate values for costs in the InfoCube?
6. Which selections should I use with the extraction?
Answer
During the extraction, make sure that actual data in a certain period is either read through the totals record DataSource or the line item DataSource.
You can guarantee this by making a corresponding selection for the selection criterion periods for the line items and the totals record DataSources and by restricting the value types for the totals record DataSource.
If the values of a period are read simultaneously via the totals record and the line item DataSource and these are updated in the InfoCube, this causes duplicate values.
For old periods, the actual data is usually read at totals record level,
since the line items are already reorganized or
because the line items information are no longer required for historical data and, thus, the dataset transferred during the delta initialization of the line items DataSource can reduce.
Typical example for the selections:
0CO_OM_CCA_1
Period : 1995 001 to 2001 016
Value types: Plan, commitment, target, actual
0CO_OM_CCA_1
Period : 2002 001 to 2050 016
Value types: Plan, commitment, target
0CO_OM_CCA_9 Delta procedure for actual values
Period : 2002 001 to 2050 016.
regards,
Colin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for PS i use 0co_om_nwa_1 it has vtype 20 in it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Smith,
check table : COEP.
Thanks,
Vijay.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.