Show TOC

Out-of-Stock Analysis by Product Locate this document in the navigation structure

 

This report can help supply and demand planners and sales directors to analyze out-of-stock situations at retailer locations. Out-of-stock data is aggregated at product level.

This report also shows the cumulative net sales values that retailers have lost due to out-of-stock situations. It is also possible to navigate directly to SAP ERP and check for open orders and outbound deliveries for a product.

Prerequisites

To allow the navigation to SAP ERP transactions, the launchpad settings have been made in Customizing and in the configuration of the user interface. For more information, enter the keyword Launchpads in the documentation for SAP NetWeaver on SAP Help Portal at http://help.sap.com.

Structure

Selection Criteria

To run the report, you can use any selection criteria. We recommend that you always use dates as part of your selection criteria.

Products Out-of-Stock

The Products Out-of-Stock table shows all the products that are out-of-stock at a store during the period you selected.

By default, the results are shown as a hierarchy. You can choose to show the results as a list. You can drill down the data using additional characteristics.

After you analyze the out-of-stock data, you can select a product and navigate directly to one of the following:

  • Stock Analysis by Product report and analyze the stock data for that product

  • List of Sales Orders (VA05) transaction in SAP ERP and check if there are any open orders for that product

  • General Delivery List – Outbound Deliveries (VL06F) transaction in SAP ERP to check if there are any outbound deliveries for that product

Stores Out-of-Stock for Product

You can select a product from the Products Out-of-Stock table, then the Stores Out-of-Stock for Product <Selected Product> table will show all the stores where that product is out-of-stock.

By default, the results are shown as a hierarchy. You can choose to show the results as a list. You can drill down the data using additional characteristics.

Side Panel CHIPs

The following CHIPs are available in the Out-of-Stock CHIP category in the side panel:

  • Out-of-Stock Situations (Last 6 Months)

  • Stock History (Last 14 Days)