Cost and Revenue Analysis 

Purpose

You can use this business process to monitor the profitability of your service organization and analyze the sources of revenue, costs, and profit. You can, for example, analyze the profit generated by customers and their installed bases. You can also monitor profitability trends over a period of time.

Process Flow

...

       1.      System provides product data (SAP CRM)

       2.      System provides service business transaction data (SAP CRM)

       3.      System provides customer data (SAP CRM)

       4.      System provides installed base data (SAP CRM)

       5.      System provides cost and revenue data (SAP R/3 Enterprise)

       6.      System updates service information (SAP CRM)

During scheduled data extraction from SAP CRM to SAP BW, the system updates product, customer, installed base, and profitability data in SAP BW.

       7.      Monitor profit per product or per service organization (SAP BW)

You can use the following queries for this analysis:

¡        Highest-Revenue Products (0CSRVMC02_Q0102)

¡        Top-Selling Products (0CSRVMC02_Q0103)

¡        Profit per Product (0CSRVMC02_Q0104)

¡        Profit-Sales Ratio per Product(0CSRVMC02_Q0105)

       8.      Monitor difference in revenue, costs, and profit per customer (SAP BW)

You can use the following queries for this analysis:

¡        Highest-Revenue Sold-To Parties (0CSRVMC05_Q0102)

¡        Profit per Sold-To Party (0CSRVMC05_Q0103)

¡        Profit-Sales Ratio per Sold-To Party (0CSRVMC05_Q0104)

       9.      Monitor profit per installed base (SAP BW)

You can use the query Profit per Product (0CSRVMC02_Q0104) for this analysis.

For more information on the predefined queries provided by SAP, see the SAP Library documentation for SAP BW, under BI Content ® Customer Relationship Management ® Service ® Queries.

For more information on the Business Explorer analytics tool in SAP BW, see the SAP Library documentation for SAP BW, under Business Explorer.