Performance can be enhanced by specifying fields in your select, rather than using SELECT *. Use SELECT into TABLE rather than SELECT... ENDSELECT. Make sure your where clause contains only ANDs, ORs and NOTs result in a sequential read. Finally, it may be worth creating an index on MSEG for this specific report. The danger there is that it may have an adverse impact on other programs - causing them to use your new index, rather than the one SAP defined.
Dig Deeper on SAP PM
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.