Author Justin Valley details how to define SAP report search criteria to narrow search results.
- [Instructor] Reporting in SAP is only useful when you're able to define and narrow your search results to a point where they become meaningful to you. The best way to do this is by defining your report selection criteria. Let's enter a report transaction. I'll enter mb51, which is the materials movement history report. This brings us to the report selection screen and this is a good example of what many report selection screens look like. It is broken down into four parts. At the top, the item data area allows us to define the objects we want to include or exclude in our report.
Defining by material or plant might be typical here. The next area is header data where you can narrow a report for materials that posted in a certain date range or by a certain user. Below that are the display options which have to do with the outputs of the reports. And at the bottom the data source area is where you want your data to come from. The data source area is usually quite technical and should be set up with defaults that will work for what most users are reporting on.
For a report like this, perhaps we want to see all the materials' movements that occur at a specific plant. I'll click in the plant field and press the match code button. This will bring up the 17 plants available. I'm working on plant 1710 so I'll click on that and press the green check to copy that information into our plant field. This could be quite a large report because I haven't narrowed the search criteria down very much. This is a really good time to point out the stop transaction feature.
If you're ever running a report, and the system is taking a very long time to return your results you can stop the transaction. This is done by clicking on the three bars in the top left corner of the screen and selecting stop transaction from the dropdown menu. I won't click it here but if I were to, it would take you all the way back to the easy access screen. Sometimes this is a good option if you realize you want to narrow your report further. Okay, let's execute this report. Now we see all the materials' movements that have occurred at plant 1710.
- Benefits and limitations of SAP ERP
- Exploring the different SAP modules
- SAP security roles
- Menu tree and transaction code navigation
- Searching for data and using wildcards
- SAP basic reporting
- Editing SAP report layouts
- Printing and exporting reports