Shulou(Shulou.com)06/01 Report--

This article introduces the knowledge of "does SAP WM keep the Table of WM Level historical inventory". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

At the IM level, we have historical inventory data sheets such as MARDH/MBEWH/EBEWH, which can provide support when reporting stock, sales and inventory.

At the WM level, real-time inventory is stored in the LQUA table. It has been found that there is no table like LQUAH in the SAP system.

After looking up the information on the Internet, I found that some colleagues had asked this question on the Internet, and the answer was that there was no Table to keep the historical inventory of WM in the SAP system.

Is it possible to calculate WM historical inventory through self-development? That is, first get the current WM inventory, combined with TO history to push back the inventory at the WM level at a certain point in time? For example, how much stock did a material have on which shelves at the end of last month?

The author believes that there is a possibility. If you want to do this report, the following table will be used:

LQUA:WM level real-time stock

LTAK<AP: transfer order

The logic of fetching is roughly as follows:

1) fetch to WM Level's current inventory first

2) then TO History; takes the source storage type/source storage bin and destination storage type/storage bin in these TO from the specified date to the current date, as well as the key information such as quantity, material number, special inventory type, stock category and so on. The inventory of the material under each storage bin at the time of the specified date is the WM historical inventory of the specified date.

However, this logic may have the following problems:

Performance problems, there may be many historical TO orders

If you post a goods movement in IM where the posting date is not the current date, in WM this will be not reflected.

This is the end of the introduction to "does SAP WM have a Table that keeps the historical inventory of WM Level?" Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.