How to get cost and revenue data for sales order?

[Former Member]

Dear all,

We have a requiremrnt to develop a report on service margin profitability, and provide data for all the line items for the Costs and Revenues of all service orders.

Given the system design of Order and WBS settlements, we can not extract data from COPA, instead, this report needs to be developed from Overhead Cost Management (CO-OM).

As I am not familiar with CO-OM, can anybody guide me thru below questions:

1. Is there any standard datasource to get the revenue for each sales order on material level? And which ECC tables contain revenue data?

2. Is there any standard datasource from CO-OM to get the cost for each sales order on material level? And which ECC tables contain such information?

Any post will be appreciated, and thank you all for your time in advance!

Best regards,

Tim

[Derek_Fox · Accepted solution]

Hi Tim

Sounds like you are having a similar requirement that I had 7 years ago.

With regards to your questions:

1. Is there any standard datasource to get the revenue for each sales order on material level? And which ECC tables contain revenue data?
2. Is there any standard datasource from CO-OM to get the cost for each sales order on material level? And which ECC tables contain such information?

Unfortunately from the CO-OM side, there is no standard extractor  for sales order data - this will have to be a custom extractor. The data is stored in the following CO tables:

• COBK - CO Document Header
• COEP - CO Document Line Items

The object number that is for sales documents, starts with VB*.

For a custom extractor, you can use either a function module based extractor or an InfoSet based extractor. The InfoSet extractor is quicker to implement by joining the COEP and COBK tables.

Keep in mind that you'll have to convert the ERP Value Type field values (i.e. 04 - Actual) to the BW Value Type (0VTYPE) field values (i.e. 10 - Actual)

Also the keys of the DSO will be important as well:

• 0CO_AREA
• 0CO_DOC_NO
• 0CO_ITEM_NO
• 0CURTYPE
• 0VTYPE
• 0FISCVARNT

To view data for Services Orders (originating from Customer Service Orders aka CS Orders) you can also use the CO_OM_OPA extractors.

Regards

Derek

[Former Member · Accepted solution]

Hi Derek,

Thanks for your reply, points have been assigned.

After discussion with business, we only need to get the cost for service order, and thru AUFK-KDAUF to link to the sales order.

I took a look at the CO_OM_OPA datasouce but there is no filed KDAUF, which is critical to link between billing document and service order. Do you know if there is any standard CO extractor which contains such information?

Thanks and best regards,

Tim

[Derek_Fox · Accepted solution]

Hi Tim

What you could do is the following to obtain the data for CO_OM_OPA:

1. Enhance 0COORDER_ATTR to include the fields 0DOC_NUMBER and 0S_ORD_ITEM
2. Create a user exit for 0COORDER_ATTR and read table AUFK to fill the above fields
3. Add the fields 0DOC_NUMBER and 0S_ORD_ITEM to InfoObject 0COORDER (you can mark these as navigational objects if required)
4. Update the mappings in the Transformations
5. Check that the DTP is active
6. Load the necssary master data
7. Adjust the InfoCube and Queries with the navigational objects 0DOC_NUMBER and 0S_ORD_ITEM

Regards

Derek

[Former Member · Accepted solution]

Hi Derek,

Thanks again for your reply and I assigned the pointes. As you suggested, now I plan to pull sales order data from 0COORDER master data table which is based on AUFK.

Here I have another question: for cost data I plan to use standard extractor 0CO_OM_OPA_40 (Orders: Actual Costs-Line Items), and I did a initial load in BW. But now the problem is: On ECC side the COEP table has 3 million records, but this datasource only pulled around 1.5 million, which is only half the data of ECC table COEP. Do you know if this datasource only extract part of cost data? Or what else issue cause the data volume inconsistency?

Thanks and best regards,

Tim

[Derek_Fox · Accepted solution]

HI Tim

Winth regards to the COEP table, this contains all the data of the various CO Modules:

• Cost Center Accounting
  • records in table COEP are for this area, the object number starts with either KS (cost centers) and/or KL (activity allocation)
• Orders
  • records in table COEP are for this area, the object number starts with OR (Orders)
• Projects
  • records in table COEP are for this area, the object number starts with either PR (Projects), etc...
• Cost Object controlling
  • records in table COEP are for this area, the object number starts with either VB (Sales documents), etc...
• Profitability Analysis (Account based)
  • records in table COEP are for this area, the object number starts with EO (Profitability Segment)
  • costing based CO-PA data is stored in table CE1xxxx.

Each CO extractor only extracts a portion of the data from table COEP which is relevant for the extractor, for example, for the CO_OM_OPA extractor this will extract all records with the object number that starts with OR*.

Regards

Derek

[esjewett]

Since this is a question about Business Content & Extractors, it belongs in the Business Content & Extractors space and not the Data Warehousing space. I've moved the thread, but please use this space for these types of questions in the future.

Regards,

Ethan

(moderator)

[Former Member]

For revenue from sales orders join VBREVE with VBAP

VBREVE	MANDT	=	VBAP	MANDT
VBREVE	VBELN	=	VBAP	VBELN
VBREVE	POSNR	=	VBAP	POSNR

Similarly you can do it from billing

VBREVE	MANDT	=	VBRP	MANDT
VBREVE	VBELN	=	VBRP	VBELN
VBREVE	POSNR	=	VBRP	POSNR

[Former Member]

Hi Jangam,

Thanks for your reply and points have been assigned.

Do you know if there is any standard datasouce contains the link between service order and sales order/billing?

Thanks and best regards,

Tim