Simplify the Process for Creating BW Monthly Inventory Reports

  • by Sam Gassem, Senior Business Consultant/BW Lead, Rural Sourcing, Inc.
  • January 31, 2013
Meet the challenge of creating SAP NetWeaver BW monthly inventory data targets, including reports. Learn how to create a customized report that quickly displays opening balance, receipts, issues, end balance, and valuated stock for the current month and previous month. Sample code is included.
Key Concept

Receipts and issues are important points to be familiar with when monitoring inventory levels. Receipts refer to all material coming into stock, and issues refer to all materials going out of stock.

Every company needs to know about its inventory and stock. Your organization might require a monthly inventory report that shows the starting balance for the given month, end balance, receipts, issues, and valuated amount. This report may need to correctly sum and filter by material group and material.

One place to have this kind of information is in SAP NetWeaver BW. SAP has delivered objects for material stocks and movements, but they are cumbersome to follow because you have to maintain several tables, run three different InfoPackages, and complete many other necessary steps. The SAP-delivered objects also require users to be locked out of SAP ERP Central Component (SAP ECC) to initialize setup tables. I have seen several articles about how to design monthly inventory snapshots, all of which are cumbersome.

Also, with SAP-delivered objects, when users run reports, processing and displaying the results take a long time because an InfoCube contains millions of records and the query has many calculations. However, I developed a method in which it takes about 15 seconds to display data for two months.

I explain step-by-step instructions of how to create a custom database view and a DataSource in SAP ECC. With my method, no user needs to be locked out of SAP ECC, and there is no marker update involved.

Note
This article assumes you have basic knowledge of SAP NetWeaver BW. You also need to know how to create a Data Transfer Process, transformations, InfoPackages, DataStore objects, InfoCubes, MultiProviders, and SAP ECC database views.

Sam Gassem

Sam Gassem is senior business consultant and SAP BW lead at Rural Sourcing, Inc. (RSI). He has 13 years of experience on SAP NetWeaver BW. RSI is a leader in domestic sourcing, a cost-effective, on-shore alternative to the traditional model for IT outsourcing. RSI specializes in software development and support and maintenance for critical business applications. Its development centers are located in second- and third-tier cities across the United States. RSI was founded in 2004 by the former CIO of Baxter Healthcare with the intention of bringing jobs to areas of the United States in which historically the job market was dominated by agriculture and manufacturing.

See more by this author


Comments

3/20/2015 11:20:29 AM
Kalyan Dittakavi

Very nice article Sam.

One question - How are you going to get the Re-valuations? I see you are using MBEW: Material valuation which is the Cost in my eyes.
But in Retail Industry, Retail revaluation happens and they are not stored in MBEW.

Please log in to post a comment.

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