u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?

Answer Posted / jesuvin

Performance of reports could be increased by avaioind nested
select statements. Instead use Select ... FOR ALL ENTRIES.

Restrict the use of Select... Endselect, instead go for
select .. inot table itab and then loop at itab.

Avoid nested loop statement, Do not use select within loop.

Do not call function module within loop statement.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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)

2063


How do you Export a session ?

1447


What are the function modules used in f4 help?

641


Explain what are the different functions used in sap script?

543


hi,how to diable the popup window which is displayed afetr executing the SAP script program?

1573






What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

597


What are the advantages and disadvantages of using views in abap programming ?

645


HOW TO DIFFERENT CALL TRANSACTION ON THE BASIS OF DOUBLE CLICKING ON DIFFERENT FIELD.

1782


What is narrow casting and wide casting?

1134


It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization

706


What are the aggregate objects in the dictionary? : abap data dictionary

741


Can we use flow logic control key words in abap/4 and vice-verse?

566


How to read files and process BDC's automatically ?

1535


In the MM module for finding out the standard cost what is the view one has to look at?

616


What takes most time in SAP script programming?

680