cancel
Showing results for 
Search instead for 
Did you mean: 

getting value type 20 (plan) from 0CO_OM_OPA* extractor

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Colin4
Employee
Employee
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

for PS i use 0co_om_nwa_1 it has vtype 20 in it.

Former Member
0 Kudos

Hi Smith,

check table : COEP.

Thanks,

Vijay.

Former Member
0 Kudos

Hi,

0CO_OM_OPA_3 dont have values for valuetype i need. it is for plan but the numbers are different.

Thanks,

KS