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:
- 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.