You are running a report. It is taking long time for
execution. What steps will you do to reduce the
execution time.
Answers were Sorted based on User's Feedback
Answer / pavan
just go through st05 and se30.
inner select statements r not acceptable.
select ...endselect is not suitable
more inner joins r not recommanded
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / niladriroy_dgp
use select statement as -selext -- --- -- from -- into
table --- where <condition> to fater the data tranfer
instead of select end-select. and declare internal table
as occurs 0 not any specific no.
Is This Answer Correct ? | 1 Yes | 0 No |
What are field symbols?
What are the components of selection table?
Hi guru, In a report prg there is an event called : at SELECTION-SCREEN on VALUE-REQUEST FOR <fieldname>. pls tell me that when i am using a module pool prg how do I call the above event. In other words what is the module pool equivalent for the above event which is used in a report prg. Hope I am able explain my query.
Explain the difference between tables and structures?
How can we access the correction and transport system?
In select-options, how to get the default values as current month first date and last date by default?
Tell me MM related report that you have done?
What is the different between template and a table?
If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)
what is the various print modes available with SAP scripts?
How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc
Can i know some of the Realtime tickets that anyone has been faced ?