Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Sales Performance Report in SAP

Posted by Dylan Wan on January 27, 2007

I studied a sales performance reports found in SAP Sales Information System.

This report analyzes the monthly sales performance of a number of sales reporting structure.

In SAP, the key sales reporting structure are Sales Organization, Distribution Channel, and Sales Districts.

This report can be designed as  a pivot table, but a simple table format is used in this report:

  • Month
  • Sales Organization
  • Distribution Channel
  • Sales District
  • Invoiced Sales

You can filter the amount by specifying the Sales Organization, Distribution Channel, or Sales District. The “All” value can be used to show the summary amount of the invoiced sales.

Depending on the industry, I feel that that sales performance may be further analyzed by sales person, by product, or by customers. I do not find these dimensions in this report.

About Invoiced Sales: Although the dimensions come from the Sales Order application, the order status is updated when the sales order is picked by Account Receivables or Billing application. Typically I guess that this is already handled by the OLTP so the report does not really need to go to the Account Receivables to get the invoice data.

The report is run against the currency assigned at the sales organization level. In SAP R/3, this is called statistics currency. The combinations of Sales Organization, Distribution Channel, and the Sales Districts are called Sales Areas. Each Sales Area is tight to a Company Code which is assigned a local currency. The local currency cannot be used since you will not be able to summarized the data to the sales organization level to get the total sales by sales organizations.

Advertisements

One Response to “Sales Performance Report in SAP”

  1. motorcycle performance tuning…

    […]Sales Performance Report in SAP « Dylan’s BI Study Notes[…]…

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s