Using Classic Stock Lists and Document Lists

Analyses in Inventory Management

Inventory Management provides you with various functions for monitoring your stocks and goods movements. Some of these evaluations can only be called as SAP Fiori apps using the SAP Fiori launchpad. The other evaluations can be used as transaction using the SAP GUI and as app using the launchpad.

In the SAP GUI, in the Inventory Management standard menu, you can find evaluations under Environment and Periodic Processing. This lesson deals with analyses under the Environment heading.

Almost all the lists in inventory management display with the SAP List Viewer (ALV). In some lists (such as Material Documents, Stock in Transit, or Stock with Subcontractor), you can switch to an alternative display by choosing Goto→Detail Lists. The detail list is nonhierarchical. In this list, you can generate accurate subtotals of any columns or totals of different units.

If you display a list with the SAP List Viewer, you can expand the current layout or select one that has been created by choosing Settings→Display Variants or Settings→Layout.

For more information on the individual analyses, see the program documentation for the respective function. To display this documentation from the analysis selection screen, choose  (Program Documentation).

itil certification training courses malaysia

Document Lists

• List of material documents (MB51 transaction) / Display Material Document List  app:This report displays a list of material documents that were posted for one or more materials.The selection fields available include the Plant, Storage Location, Movement Type, and the Special Stock Indicator. You can also restrict the selection according to the user, the posting date, and the transaction type.(For information on customizing settings for the material document list, see the “Customizing” section of this lesson.)
• Accounting documents for material (MR51 transaction) / Accounting Document List for Materials app:This report issues a list with all accounting documents that are relevant for a selected material. You can make selections based on the material, company code, valuation area, posting date, document date, and the document type of the accounting document.
• Archived material documents (MBAL transaction) / Material Documents: Read Archive app):This report reads archives for material documents and issues the corresponding documents according to the selection criteria.
• Canceled materials documents (MBSM transaction) / Display Cancelled Material Documents app):This report issues a list with reversal documents and the corresponding original documents. You can make selections based on the number of the reversal document or the number of the original document, as well as the material, plant, posting date, and name of the user who created the document.
• Material documents with reason for movement (MBGR transaction) / Display Material Documents with Reason for Movement app):According to your selection, this report displays a list of all goods movements in which a reason for movement was specified during entry. The report selects documents according to two criteria:
  • Without reference to purchase orders:The system evaluates all document items where you have entered a reason for the movement. If you set the No Vendor indicator on the initial screen, the system only evaluates those documents that do not have a reference to either a purchase order or to a vendor.
  • With reference to purchase orders:This criteria is valid if the document contains at least one item with a reason for the movement, and if it has a reference to a purchase order. Using the PO history, the system reads all other GR documents for the PO item.
  You can restrict the selection using the material, plant, posting date, vendor, and purchasing document. For items with purchase order reference, the system displays the total delivered and returned quantities and their values, and the percentage of the returned quantity to the total delivered quantity.
• Stock Lists
• Stock overview (MMBE transaction) / Display Stock Overview app:This report gives you an overview of the stocks for one material across all organizational levels. You can restrict your selection according to the material, plant, storage location, and batch (for materials subject to the batch management requirement). On the initial screen, you can decide whether you want to display special stocks in the stock overview and, if so, which ones.For the list display, you can specify that zero-stock lines are hidden and you can select the levels that display in the basic list.The stock types that displays in the basic list is determined by the display version that you specify on the initial screen. This display version also determines the sequence in which the selected stock types display. Display versions are defined in Customizing for Inventory Management.
• Stock/requirements list (MD04 transaction):The stock/requirements list displays the stock situation and requirements situation that currently applies to a material. The system reads the MRP (material requirement s planning) elements (for example, plant stock, purchase requisitions, POs, and reservations) each time the list is created. The stock/requirements list, therefore, always shows the current availability status of the material. The stock/requirements list contains information about one material in one plant.
• Plant stock availability (MB53 transaction) / Display Plant Stock Availability app:This report gives you an overview of the available stock of one material in selected plants using the static availability check.
• Availability overview (CO09 transaction) / Monitor Product Availability app:This analysis uses a dynamic availability check to give you an overview of the stocks that exist for a material. The quantity available on the day of analysis is specified.
• Warehouse stock (MB52 transaction) / Display Warehouse Stock app:With this report, you can display the total stock of several materials with quantities and values at plant and storage location level. As with the stock overview, you can make selections based on materials, plants, storage locations, and batches. For this report, you can also make selections based on material type, material group, and purchasing group.On the initial screen, you can specify whether special stocks are to be analyzed, and if so, which ones. When analyzing warehouse stock, you can monitor materials with negative stocks. To analyze the warehouse stock, select the Display Negative Stocks Only checkbox on the initial screen.
• Stock for posting date (MB5B transaction) / Stocks for Posting Date app:This report lists stocks in a time interval (00:00 on the start date to 24:00 on the end date). Starting with the current stock, the system uses the existing material documents to calculate the stock on the specified posting date.The list displays the stock quantity and stock value on the start and end date, the sum and value of all receipts, the sum and value of all issues, and a list of the material documents in the selection period.
• Stock in transit (MB5T transaction) / Display Stock in Transit app:This report displays a list of materials for a plant that are in transit. It includes both cross-plant stock transport orders and cross-company-code stock transport orders. On the selection screen, you can choose which types of POs to display. You can also include delivered or deleted POs. If you enter a special stock indicator, you can specifically select stock transfers of the sales order stock.
• Stock in transit on key date (MB5TD transaction) / Stock in Transit on Key Date app:This is an evaluation similar to transaction MB5T. However, you can restrict it using a key date. The system only selects and processes purchase order history entries whose posting date is before or the same as the key date entered.
• Valuated GR blocked stock (MB5OA transaction) / Display Valuated GR Blocked Stock app:The report selects the records from the purchase order history on the basis of the selection criteria entered. If you wish to select purchase orders according to the Acceptance at Origin indicator, the stock quantities determined from the PO history are assigned to the corresponding transactions of origin acceptance. After this, the system calculates the proportional valuated GR blocked stocks at the level of the PO document item. The system displays the results of this calculation in an output list.
• Valuated special stock (MBBS transaction) / Display List of Stock Values – Sales Order and Project Stock app:This report issues a list with the valuated sales order stock and the valuated project stock.
• Stock with subcontractor (MBLB transaction) / Stocks at Subcontractor app:This report analyzes which materials and material quantities are found with a particular subcontractor.
• Customizing for Lists in Inventory Management
• In Customizing for Inventory Management and Physical Inventory, the Reporting node contains the functions for configuring the analysis in inventory management.
• Define Stock List Display
• To define the display versions for the stock overview, go to Customizing for Materials Management under Inventory Management and Physical Inventory→Reporting→Define Stock List Display (OMBG). The settings for stock display in the stock overview (MMBE) are divided into three steps:
• Display version:Definition of a display version by assigning a version number and a description.
• Rules for display of stock balances:Version-dependent definition of the stocks that are displayed in the basic list. Thereby it is defined which stocks appear on which screen and in which column of the screen.
• Detail screen for stock balance display:Definition of the stocks and their sequence for the detail list of the stock overview. These settings depend on organizational level and, if applicable, on special stock.

java ee enterprise edition training courses malaysia

Set Up Print Functions for Reporting

You can specify which additional information is printed along with the output list for inventory management reports in Customizing for Materials Management under Inventory Management and Physical Inventory→Reporting→Set Up Print Functions for Reporting.

You can also specify whether the detail list (non-hierarchical list) for a report displays in the ALV Grid Control instead of the SAP List Viewer.

Group Movement Types for Stock Lists

You assign movement types to a movement type group in Customizing for Materials Management under Inventory Management and Physical Inventory→Reporting→Group Movement Types for Stock Lists.

This assignment can be used in the Stock for Posting Date report for evaluation purposes. This enables you, for example, to group together all movement types that affect purchasing. In the output list of the report, you can then filter out material documents using this group without individually specifying all purchasing-relevant movement types.

dynamics 365 marketing training courses malaysia