basically MB51 is a report thru which u can find out the various material documents based on posting date,movement type etc as the selection criterion
Purpose
This report provides you with a list of the material documents which were posted for one or more materials. You can display a material document from the output list.
You can choose whether you want to read a material directly from the database or from the archive. You can also display short documents for archived material documents from the database. The end of the document shows you how to define an additional field for the archived material documents and add it to the table MARI (Short documents for goods movements). You can only use data contained in the table MARI to select and display short documents.
Prerequisites
Authorization check
You need authorization to display material documents for all chosen plants (authorization object for material documents: plant, activity 03).
If you want to display value fields from the document, you also need authorization to display accounting documents for the relevant company code (authorization object for accounting document: authorization for company codes, Activity 03).
Displaying archived material documents and short documents
To read material documents from the archive, you have to archive them first. To do this, choose Material document -> Archive -> Create archive from the Inventory Management menu.
To display short documents from the database, the short documents and the index table must have been created during archiving. You can subsequently compile the short documents using the program RM07MARI; you can create the index table using the program RM07MAIC.
Features
Authorization check
If the check failed for at least one authorization check because you do not have authorizations, the list output may be incomplete. In this case, the system issues a message and you see the following pushbutton in the application toolbar:
(Display Authorization Checks)
You can display an overview of the authorization checks that have been carried out by choosing Goto -> Display authorization checks. The overview is broken down according to the type of message, the authorization object, and the plants checked.
The following messages can occur:
Red Traffic Light: Error
The system deleted the data records in the output list.
Yellow traffic light: Warning
The system deleted some fields in the data records (for example, values) in the output list.
Green traffic light: Successful
The authorization checks were successful; all the data you require is displayed.
Improving performance
To improve the performance of data selection, you should enter at least one material or posting date.
Coloring numerical values
In Customizing for Inventory Management under Reporting -> Set Up Printing Functions for Reporting, you can use the Without Color indicator to specify whether the output list should display quantities and values highlighted in colors:
If this indicator is not set, only the fields with quantities and values are displayed in color in this report. In lines containing receipt postings, the system displays positive numbers highlighted in in green. Negative numbers are highlighted in red.
If the indicator is set, the system colors all fields for a line in the same color. Lines with receipt postings and positive numbers are light gray, lines with issue postings and negative numbers are dark gray.
SAP recommends making this setting to improve performance in cases where the output lists are extensive.
Selection
On the initial screen, you can restrict your selection.
Choosing a data source
The report can read the document data both directly from the database and with the help of short documents from the archive. Note that the short documents may not contain fields that are contained on the selection screen. In this case, entering these selection criteria has no effect.
If errors occur when the documents are being read, the system informs you of these errors via a dialog box.
Output
In the standard system, the report issues a list with the following information for each material:
Plant
Storage location
Movement type
Special stock indicator (for example K for consignment stock)
Material document and material document item
Posting date
Qty moved and unit of measure
From the output list, you can display the following by choosing Environment:
To go to the material document, place the cursor on a material document item and choose Material document.
If a purchase order is assigned to the material document, you can go to the purchase order by choosing Purchase order.
To call up the stock overview for the material in question, choose Stock overview.
To call up the accounting document, choose FI document.
By double-clicking in the output list, you go directly to one of the following functions, depending on the field you choose:
Stock overview: double click on a header line.
Purchase order: double click on a purchase order number.
Purchase order item: double click on a purchase order item.
Document item: double click on the document item.
Material document: All other columns.
Detail list
To display the data in a different format (non-hierarchical list), choose Goto -> Detail list.
In this non-hierarchical list, you can calculate sub-totals over the number of columns you wish (including several levels), as well as totals over various units.
For the detail list, you can maintain separate display variants and specify them as a default.
You can convert the detail list to an alternative format that provides more functions and is more convenient to use. To do so choose the step Set Up Print Functions for Reporting in Customizing for Inventory Management.
Configuring the selection screen and the field catalog
You can configure both the selection screen and the number of fields contained in the ABAP List Viewer for all clients. To do so, choose Define Field Selection for Material Document List in Customizing for Inventory Management.
You can improve the performance of the report by decreasing the number of fields in the field catalog.
Display further information
If you require more data and want a detailed evaluation, you can enhance the current layout or choose another existing layout via Settings -> Layout.
For more information on all of the SAP list viewer's functions, see the SAP Library under SAP R/3 Enterprise Application Components -> General Application Functions (CA-GTF) -> SAP List Viewer (ALV): Classic.
Example
This example shows you how to define an additional field for the archived material documents and add it to the table MARI.
Firstly, you have to decompile the short documents and the index tables. This ensures that you can only work with current data. You use program RM07MAID to decompile the short documents and index tables.
In the dictionary (transaction SE11), call up the table with object name MARI. The table MARI contains a field for a customer include. You use this to assign a new customer-defined field to the structure CI_MARISEL. The field you want to add must be contained in the table of material document items (MSEG).
Finally, you must recompile the index tables and short documents to activate the changes. You do this with program RM07MAIC.
You can now use the redefined field in the table MARI to select and display short documents
regrads,
indranil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.