Store Replenishment

The Store Replenishment Benchmark is more comprehensive than the POS Inbound Benchmark. It comprises a pre-step for point-of-sale (POS) upload that provides the sales data for the replenishment process.

The Store Replenishment Benchmark consists of the following business scenario:

• POS Upload: The sales data from the stores is uploaded and posted into the central retail system. Note that this is only a pre-step of the POS upload in the POS Inbound Benchmark. In the Store Replenishment Benchmark, only the quantitative information of sold articles into specific database tables used for the replenishment run is updated.
• Requirement calculation: On the basis of sales data, forecast data, and stock data, a requirement calculation is conducted.
• Follow-on document creation: The results of the second step are taken to create follow-on documents such as purchase orders for external vendors and delivery and transfer orders for internal distribution centers.

Benchmark Results

Replenishment, SAP Retail 4.6C ›

Benchmark Description

The steps, above, are run for 1,000 stores. Every store contains 10,000 articles, distributed into 100 merchandise categories with 100 articles each. One half of the articles are received from 50 external vendors. The other half comes from internal distribution centers (DC). There are 10 DCs in total, and 100 stores are associated with each DC.

In the POS upload step, 100 IDOCs (WPUBON) with 1,000 line items have to be processed for each store. Every IDOC contains sales data for the 100 articles of a merchandise category. This means that 100,000 IDOCs with 100 million line items have to be processed in total. For each article, there are 10 line items in different receipts of an IDOC, so that aggregation reduces the data volume by a factor of 10. Due to the sales information in the IDOC, 2,000 articles must be replenished in every store.

During requirements calculation, the system checks the number of sold articles in every store (each with 10,000 articles) to determine whether a replenishment is required. As mentioned above, this will be the case for 20 percent of all articles (2,000) in every store.

In the final step, follow-on documents – purchase orders, deliveries, and transfer orders – are created for all articles determined in step 2. For the 1,000 articles that are delivered from an internal DC to a store, 10 deliveries with 100 items each are created. This triggers the creation of 10 corresponding transfer orders with 100 items. For the articles coming from external vendors, 50 purchase orders with 20 lines are created for each store. Consequently, 10,000 deliveries, 10,000 transfer orders, and 50,000 purchase orders are created in total.