Show TOC

On-Shelf Availability by Product Locate this document in the navigation structure

 

This report can help supply and demand planners to monitor product on-shelf availability at retailer locations. On-shelf availability data is aggregated at product level.

This report also shows the cumulative net sales values that retailers have lost due to out-of-shelf 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. However, the time period for the search is set to seven days, where the end date is the current date.

Products Out-of-Shelf

The Products Out-of-Shelf table shows all the products that meet your selection criteria and that have been out-of-shelf at a store within the last seven days.

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. For example, you can add Calendar Day to the vertical drilldown to show the data at day level.

After you analyze the on-shelf availability 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-Shelf for Product

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

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.

Side Panel CHIPs

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

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

  • Stock History (Last 14 Days)