Wholesale Distribution

Wholesale Distribution

In Wholesale Distribution, you can extract, monitor, and evaluate the following data related to wholesale through prepared reports for the Business Views Senior Manager and Sales Manager.

For the Senior Manager Business View, you can extract the following data:

• Gross sales for branches
• Gross profit
• Open sales orders
• Day's sales of inventory (DSI)
• Inventory turnover
• Number of employees in each organizational unit

For the Sales Manager Business View, you can extract the following data:

• Top ten products a specific customer ordered last week or last month
• Top ten products ordered overall
• Top ten products with the highest gross sales and gross profit

This BI Content project also identified the most relevant characteristics and key figures for the Business Views Senior Manager and Sales Manager. See Business View: Senior Manager and Business View: Sales Manager for a list of these characteristics and key figures.

Technical Data

Available as of Release	SAP ERP 2005, Enhancement Pack 2
BI Content Add-On Release	SAP NetWeaver 7.0 BI Content Add-On 3 SP06

Features

The following diagram represents the data flow with the related valuation levels:

Wholesale Distribution data is uploaded to the SAP BI system with the following InfoSources:

• 2LIS_03_BF_TR: This InfoSource enriches InfoCube 0IC_C03 and InfoCube 0RT_C35 with material movement data.
• 2LIS_03_BX_TR: This InfoSource enriches InfoCube 0IC_C03 with material stock data.
• 2LIS_03_UM_TR: This InfoSource enriches InfoCube 0IC_C03 with revaluations data.
• 0CO_PA_1: This InfoSource enriches InfoCube 0COPA_C01 with data on published key figures.
• 2LIS_13_VDITM: This InfoSource enriches InfoCube 0WS_BVC01 with gross sales data.
• 0HR_PA_0: This InfoSource enriches InfoCube 0PA_C01 with employee data.
• 0HR_PA_1: This InfoSource enriches InfoCube 0PA_C01 with personnel actions data.
• 2LIS_45_VDLST: This InfoSource enriches DataStore Object 0WS_DS02 with purchasing data. This DSO then supplies chargeback request data to InfoCube0WS_BVC02.
• 2LIS_11_VAHDR: This InfoSource enriches InfoCube 0SD_C03 with sales order header data.
• 2LIS_11_VAITM: This InfoSource enriches InfoCube 0SD_C03 with sales order item data.

The following MultiProviders are also available:

Sales and Inventory with Employee Data (0WS_MC05): This MultiProvider receives sales, inventory, and employee data from the following InfoCubes:

• Chargeback Requests (0WS_BVC02)
• Gross Sales (0WS_BVC01)
• Sales Overview (0SD_C03)
• CO-PA Published Key Figures (0COPA_C01)
• Material Movements (0RT_C35)
• Material Stocks/Movements (0IC_C03)

Sales and Inventory without Employee Data (0WS_MC06): This MultiProvider receives sales and inventory data from the following InfoCubes:

• Headcount and Personnel Actions (0PA_C01)
• Gross Sales (0WS_BVC01)
• CO-PA: Published Key Figures (0COPA_C01)
• Material Stocks/Movements (0IC_C03)

The following queries are based on the MultiProviders listed above:

• 0WS_MC05_Q0001: This query provides information about the gross sales for branches.
• 0WS_MC05_Q0002: This query provides information about the gross profit. It does not include employee data.
• 0WS_MC05_Q0003: This query provides information about open sales orders.
• 0WS_MC05_Q0004: This query provides information about the day's sales of inventory (DSI).
• 0WS_MC05_Q0005: This query provides information about inventory turnover.
• 0WS_MC05_Q0006: This query provides information about the top ten products ordered (overall, by a specific customer), and the top ten products with the highest gross sales and gross profit.
• 0WS_MC06_Q0001: This query provides information about the gross profit. It includes employee data.
• 0WS_MC06_Q0002: This query provides information about the number of employees.