0PM_OM_OPA_1 & 2

[Former Member]

Hi Experts,

Can anyone please explain me the difference between extractors 0PM_OM_OPA_1 and 0PM_OM_OPA_2. i know one is delta enabled and the other is not, i just want to know the functionality changes in both the extractors, when and where they can be used etc etc.........

Regards,

MSS

[Former Member]

Hi

The datasource 0PM_OM_OPA_1 is NOT delta enabled. Only FULL upload can be done via this datasource because no TIMESTAMP field is present in the COPF table. Since the datasource is NOT delta enabled in order to improve the performance during FULL upload the field "VTYPE" was set to "Selectable" (Table - ROOSFIELD -> selection) in order to

restrict the number of records retrieved by 0PM_OM_OPA_1 extractor.

If you still want to proceed with delta extraction it may be possible to create a Generic datasource on the source table for

0PM_OM_OPA_1 from transaction RSO2 using Calender day or numeric pointer.

0PM_OM_OPA_2 Delta-Capable Extraction for Order Costs which is a diffrent datasource from maintain orders

Santosh

[Former Member]

Hi

0PM_OM_OPA_1 it is for the planning costs (vtype=20), actual costs (vtype=10) , commitment lines (vtype=40), ecc.

It's based on FM BWSM_PM_GET_ORDCST and provides data from

1) COSP : CO Object: Cost Totals for External Postings

2) COSS: CO Object: Cost Totals for Internal Postings

0PM_OM_OPA_2 it provides delta extraction of the actual costs.

It's based on and provides data from

COVP (database view on COEP and COBK): CO Object: Line Items (by Period and Document Header)

We upload data from both datasource:

from 0PM_OM_OPA_1 for planning costs and commitment lines (and we delete datapacKage actual records in start routine)

from 0PM_OM_OPA-2 for actual costs.

It depends from you scenario and your purpose.

Hope this help you.

[Former Member]

Hi Ferruccio

Thanks for your reply.

My scenario is we need to extract actual cost, if it is zero.

OPM_OM_OP_1 is not bringing if the actual cost, if zero.

Does OPM_OM_OP_2 brings the data with actual cost zero.

Kindly elaborate your reply.

Regards,

MSS

[Former Member]

Hi,

datasource OPM_OM_OP_2 , as well datasource 0PM_OM_OP_1, doesn't provide you records if they're null.

Probably you have to find a different solution, for example uploading data into your BI system from a flat file or a table to create null records in your datatarget.

Hope this help you.

[Former Member]

Hi,

That means at the time of data load to 0PM_C01 cube data loading from the data source 0pm_om_opa_1 datsource only updates the planned values , here 0pm_om_opa_2 loads actula data

if i loaded both the key value sare doubled so how it is happening.

that means start rotine not working fine .?

from 0PM_OM_OPA_1 for planning costs and commitment lines (and we delete datapacKage actual records in start routine)

Thanks & Regards,

Sathish

[Former Member]

A selection in the info package with correct value type would solve the problem.

-Vikram

[Former Member]

Dear MSS,

I am also getting the same issue, as you had referred, I could find few Maintenance orders not extracted to BW, it was found that actual cost which had "0" was not extracted. I understand there is a FM, BWOMR_READ_DATA for the datasource 0PM_OM_OPA_2 to extract actual data but we are not able to find any filters as such in the FM to filter those records. Could you please suggest how you had solved the issue.

Regards.

Jerry

[Former Member]

Hey Jerry, if you could fix this issue please share.

[Former Member]

Hi

0PM_OM_OPA_1 - is for the planning costs. It provides the movement data for maintenance orders.

0PM_OM_OPA_2 - Delta extraction of the actual costs (table COEP) of the maintenance orders

Thanks