Warehouse Stock Age Reports Made Easier

  • by Aneesh Gupta, Consultant, Business Information Warehouse, International Consulting Group, SAP Consulting
  • December 1, 2003
Reporting on the age of stock in your warehouse can be troublesome and slow in R/3. SAP’s Business Information Warehouse (BW), however, is better equipped to deal with this load-intensive calculation. This article shows you how to calculate stock age based on first-in, first-out logic using BW.

One commonly requested report is to show the age of stock in your warehouse. I've found that the easiest way to get this information is through SAP Business Information Warehouse (BW). This is the best way when batch management is not implemented or batch sizes are large and multiple in and out movements occur for a batch.

Here's why: The stock age calculation is load-intensive because it happens at the lowest level and is a back calculation. BW is meant for this type of reporting, while R/3 could bog down on the calculation. With BW, you can also change the age buckets and, with some formula variables, leave it to the user to decide which age buckets to use.

I will show you how to calculate the stock age based on first in, first out (FIFO) logic. The calculation is done using the Boolean operators available in the BW Query Designer. No changes to the data model of the InfoCube are necessary.

This query works at the level at which material movements take place. If batch management is implemented, then the lowest level is plant/material/batch. Without batch management, the lowest level is plant/material. With this query, you can trace a material back based on the material documents. If a material document changes the identity of the material in any way — for example, a material-to- material transfer — then this query won't work for that material as the documents cannot be traced back.

Because this query is based on holding time, you can use it for all industries. If the location is a producing plant, then the holding location is a factory and it starts from the goods receipt after production. If the holding location is a warehouse, then it is based on the goods receipt at the warehouse, which in effect becomes holding time.

Because it relies on holding time, this query does not always produce precise results, but it provides a general idea of stock age. Without batch management, this query is probably the best way to get stock age

Aneesh Gupta

Aneesh Gupta is an SAP consultant with experience in Business Information Warehouse, the SAP R/3 SD module, and SEM-BPS. His roles have ranged from core team member to handling integration of SD with all other modules in R/3 and from module consultant to expert guidance on handling almost all R/3 modules in BW. He has a working knowledge of ASAP and possesses a good understanding of the processes in R/3 and the necessary reporting requirements on them.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.