An explanation of SAP history inventory mb5b

1. Commanding:

Transaction code MB5B is a receive and save report within a query selection period

Among them, receiving, sending for the summary of the selection period of the receiving and sending information, the selection period of the beginning of the period, the final inventory data;

We can also use this report to query inventory for a day in history, but note some restrictions.
2, the query condition description:
1, the choice of inventory type
Select "Warehousing Location/Batch Inventory" (Storage Loc./bat stock)

Inventory is displayed only at the inventory location level and does not show inventory at the factory level (special stock and factory level in transit inventory)
Can only view the number of received and received, unable to view the amount;
Query results according to the material factory summary, if the material is batch management, according to the materials, factories, batches to summarize; Select "Evaluate Inventory" (valuated stock) to inquire about the receipt and storage of an item at the entire factory level, and to see the number of incoming and outgoing quantities as well as the amount.
Regardless of whether the material does batch management, the query results are summarized according to the material and factory.
Note: You cannot enter additional query criteria (such as inventory location, batch, special inventory indicator, evaluation type, movement type) Select "Special Stock" (speical stock), can query customer consignment, supplier consignment, sales order and other special inventory collection and storage summary situation
The results of the query are summarized according to the material, factory and special inventory types.
Note: Specific customer codes, sales order numbers that correspond to special inventory will not be displayed

2. Enter the movement type at the same time, you must enter the period, at which time the beginning of the period data may be inaccurate, because the movement type is restricted.
3, reversal of the processing of vouchers.

The system default on the receipt of the reversal, will appear in the "total issued quantity", which may not be our expectation, we may consider tick the button "No reversal move", but note that only when the reversal voucher and the reversed voucher in the same selection period, the button can be ticked "no reversal move", or the beginning of the end of the inventory may not be

4, set "display format", most enterprises are more accustomed to choose non-hierarchical display format.

3. Summary

With regard to MB5B, SAP does not recommend processing large amounts of data with mb5b, although it does not restrict the use of the report to handle large amounts of data, for users of this type of demand, SAP recommends a large volume of data for the company to optimize on the basis of SAP Standard report, please read the following SAP note

Note 1005901 mb5b:performance Problems

Note 773673 mb5b:accessibility Conver

Note 921165 mb5b:improving The runtime using the database hints

Note 195786–mb5b:collective Note