MB51 Display Material Document List

1 Date Revised: October 24, 2018 1 MB51 | Display Material Document List MB51 is used to Display a list of Material documents to view information about related transactions, such as goods movements. Use this transaction to Display transaction history for a variety of criteria. For example, materials, storage locations (SLocs), cost centers, etc. Display Material Document List 1. Type MB51 in the Command field and press Enter. In the Item Data area, 2. Enter search criteria into one or more of the fields. This job aid demonstrates the use of the Plant and Storage Location fields for a search. Note: Click beside the applicable search fields to specify multiple entries for the search. Refer to the Specify Multiple Entries and Add Column(s) section for an example.

2 In the Display Options area, 3. Click the Flat List radio button. 4. Click . Date Revised: October 24, 2018 2 Display Material Document List The Material Document List screen appears and displays all movements based on the selection criteria. In the Unit, Quant, EUn, and Amount columns: Green Rows represent transactions that resulted in a credit to a cost center or SLoc. Red Rows represent transactions that resulted in a debit to cost center or SLoc. MvT Column displays the numeric movement type code associated with the transaction. Common movement types: 919: Initial Upload of Material 101: Goods Receipt 102: Reverse Goods Receipt 122: Return Material to Vendor (original PO) 161: Return Material to Vendor (returns PO) 201: Goods Issue to a Cost Center 202: Reverse Goods Issue for Cost Center Date Revised: October 24, 2018 3 Display Material Document List To calculate the subtotal for a specific column, click the header for the column that you wish to subtotal by (column will highlight), click the header(s) for the column(s) you wish to total (column(s) will highlight), and then click.

3 O Refer to page 4 for an example screenshot that shows a subtotal by Material . Note: To select multiple columns for total and subtotal, press and hold down the Shift key and click each of the desired columns (all selected columns will highlight). In the example below, the Material , Quant, and Amount columns are selected. To calculate the total for a specific column: Click the header for a column that you wish to total (column will highlight) and click . Date Revised: October 24, 2018 4 Display Material Document List This following example shows the quantity and amount in LC (value) subtotaled by Material (each Material is isolated and the corresponding quantity and value total for each are displayed.)

4 Note: To export the report to an Excel format, click the List menu, select Export, and then select Spreadsheet. Displaying a Material Document list is complete. Date Revised: October 24, 2018 5 Specify Multiple Entries and Add Column(s) This section provides instruction for working with multiple entries, and adding additional columns for reporting, and picks up at Step 2 from the Display Material Document section. 1. Click beside the applicable fields to specify multiple entries for a search . Note: This example demonstrates specifying multiple movement types The Multiple Selection for Movement Type 2. Enter the applicable movement types in the Single Value fields. Note: This example uses return movements 161 and 122 as examples for multiple movement types.

5 3. Click . Date Revised: October 24, 2018 6 Specify Multiple Entries and Add Column(s) You return to the Material Document List screen. 4. Enter a posting period date range in the Posting Date fields within the Header Data section. 5. Click . The Material Document List displays with the results of the search. Note: The Material Document List report is capable of displaying additional columns that are not part of the standard report layout. The remaining steps detail how to add a column for the report in order to Display further detail. In this example, Text column is added to Display information that was entered in the Text field at the time the original goods movement was processed. 6. Click . Date Revised: October 24, 2018 7 Specify Multiple Entries and Add Column(s) The Change Layout screen appears.

6 7. Click Text under the Column Set heading on the right side of the screen. 8. Click to move Text under the Displayed Column on the right side of the screen. 9. Click . The Material Document List screen appears and now includes the Text column. Note: To export the report Specifiying multiple entries and adding a column is complete.