0CO_OM_WBS_1 Vs 0CO_OM_WBS_6

[Former Member]

Hi,

Can someone help me to understand the actual differences between 0CO_OM_WBS_1 (Costs) and 0CO_OM_WBS_6 (Actuals) extractors? Currently, i am using the following extractors in my project to get the Project systems Controlling data:

0CO_OM_WBS_1	WBS elements: Costs	Plan (Budget & Forecast), Actuals & Commitments
0CO_OM_WBS_3	WBS elements: Plan	Plan (Budget & Forecast)
0CO_OM_WBS_6	WBS elements: Actuals	Actual Line Items
0CO_OM_WBS_7	WBS elements: Commitment	Commitment Line Items

The issue am facing is that the actual amounts are getting doubled when i load the data to cube, since the same transactions are getting from

0CO_OM_WBS_1 (Costs) and 0CO_OM_WBS_6 (Actuals) extractors..

My question over here is that, since am using the 3, 6 and 7 WBS extractors, do i still need to use the WBS_1 extractor? If yes, then what kind of data that may be different from the others extractors?

Appreciate your responses on this topic..

Advance Thanks

Chai

[RamanKorrapati]

Hi Venu,

0CO_OM_WBS_1 - Data source give all costs and quantities (plan)

0CO_OM_WBS_6 - Data source for historical data and Actual data also

there will be one info object which differences actual and plan is VALTYPE

But while loading to Cube in dtp you may need to sue routine on base of VALTYPE, then you won't get any records as doubled.

http://scn.sap.com/thread/597407

http://scn.sap.com/thread/730724

http://help.sap.com/saphelp_nw04/helpdata/en/33/6db6385443bd7ae10000009b38f8cf/content.htm

Regards

[Former Member]

Thanks for your reply KR..

The question i still have is that do i need to use WBS_1 extractor in case if we are getting Plan, Actual and Commitment data from WBS_3, WBS_6 and WBS_7 extractors.. Is there any reason that we need to still use WBS_1 and filter the data for Actuals??

[RamanKorrapati]

hi venu,

You would better to discuss with your functional people, bcaz their only knows what data and wht purpose these are loading into targets. There is some cause as your business needs loading into one target.

But plan and actual are differ by the Value type only. always using at sections while loading.

Regards