BW Scenario: Sales Analysis

This scenario enables you to analyze sales and distribution data from SAP R/3.

InfoCubes

  • Quotations / Orders (technical name OSD_C05)
  • Service Level - Order Quantities (technical name: 0SD_C11)
  • Service Level: Order Items (technical name: 0SD_C12)
  • Service Level: Orders (technical name: 0SD_C13)
  • Backorders (technical name: 0SD_C14)
  • Sales Overview (technical name: 0SD_C03)

Key Points

These InfoCubes enable you to view the following information:
  • Analysis of all transaction data from sales orders, deliveries and billing documents/invoices
  • Analysis of order fullfillment from R/3 such as:
     - Delivery Delays per Sold-to Party
     - Service Level - Order/ Item/ Quantity Level
     - Item Fulfillment Cycle Time

    You can also track average delivery processing times, such as time elapsed between the material availability date and the date on which the goods arrive at the customer.
  • Analysis of general figures for quotations including:
     - Number of quotations created
     - Net and gross values of the quotations
     - Number of quotations rejected

    You can also calculate the success rate of quotations by comparing quotation and order quantities. Information about the quotation success rate includes:
     - Comparisons with order probability
     - Orders that result from quotations

    Note:
    Although you can see whether the order resulted from a quotation, you cannot see whether a quotation led to an order.
 

Scenario Documentation
Scenario Overview
Business Process Procedure


Scenario Installation
Scenario Installation Guide
Building Blocks
I00: Essential Information for SAP Best Practices BI
B84: BW Connectivity
B03: General Settings BW Integration
BS3: Basic Configuration - Sales Analytics
SAA: Sales Analysis
B56: Offers / Orders
B33: R/3 Delivery Service Analysis