Q
Problem solve Get help with specific problems with your technologies, process and projects.

Creating Plant Material reports

I need to create a report that should list Plant Material combination, that was not appeared in MSEG for the past two years, and whose quantities in total must be equal to zero. Due to huge amount of record it is taking some 40 hours in background. Is there any way to reduce the time. And also it consumes much amount of DB resources.
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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close