on 12-28-2012 6:14 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.