Show TOC

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

 

This report can help key account managers and sales directors to analyze out-of-stock situations at retailer locations. Out-of-stock data is aggregated at location 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.

Locations Out-of-Stock

The Locations Out-of-Stock table shows all the locations that have products out-of-stock during the period you selected.

By default, the results are shown in a hierarchy view. If you have used a location hierarchy in the selection criteria, the results are shown as a hierarchy, otherwise, they are shown as a list. You can choose to show the results in a list view, where you can drill down the data using additional characteristics.

Products Out-of-Stock for Store

You can select a store from the Locations Out-of-Stock table, then the Products Out-of-Stock for Store <Selected Store> table will show all the products that are out-of-stock at that store.

By default, the results are shown in a hierarchy view. If you have used a product hierarchy in the selection criteria, the results are shown as a hierarchy, otherwise, they are shown as a list. You can choose to show the results in a list view, where 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

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)