Skip to Content
0
Nov 15, 2006 at 12:08 PM

CO data extraction: report table CO object product cost accounting

213 Views

In <b>R/3</b> I have a report which has been created with the <u>Report Writer</u> (tCode GR31). It uses a <u>library</u> based on the <i>report table CO object product cost accounting</i> (KKBC).

The interesting aspect is that this library contains the <u>characteristic</u> <i>sales order number</i> (KDAUF). Using it as well as other characteristics (<i>cost element</i>, <i>value type</i>, <i>results analysis version</i>), the <u>key figure</u> <i>total costs</i> SWKG has been <u>restricted</u> (in the BI meaning) in a variety of ways, giving several restricted key figures.

I am looking for the corrisponding <u>content objects</u> in <b>BW</b> which could allow obtaining the same result. My issue is that all the objects I've found apparently don't have the detail of <u>0DOC_NUMBER</u>.

After reading the manual page InfoCubes" target="_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/cb/149b3979e90e1be10000000a114084/frameset.htm">InfoCubes in Controlling I've considered the following InfoCubes:

CO-PC-OBJ" target="_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/64/0a6937adf79120e10000009b38f842/frameset.htm">CO-PC-OBJ: Cost Object Controlling (0PC_C01)

It contains only the data of <u>cost elements</u> linked to <u>production orders</u>. As a consequence, the costs elements linked generically to the <u>customer orders</u> are not present. Please notice that the <u>navigational attribute</u> 0DOC_NUMBER is an attribute of 0PRODORDER.

CO-OM" target="_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/33/6db6385443bd7ae10000009b38f8cf/content.htm">CO-OM: Costs and Allocations (Delta Extraction) (0COOM_C02)

It contains all the <u>cost elements</u>, thus also those which are linked to the <u>customer orders</u>. Unfortunately the data are not at the desired level of detail, being aggregated with respect to 0DOC_NUMBER. When a cost element is linked to a production order, the characteristic <i>partner object</i> (0PIOVALUE) contains the <i>production order number</i>. However for those cost elements which are linked to sales documents, the characteristic <i>partner object</i> has no value.

Do you have any idea what <u>DataSource</u> could give me all the data I need, currentrly extracted in R/3 through the KKBC reporting structure?

Cheers, Davide