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
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)
How do you Export a session ?
What are the function modules used in f4 help?
Explain what are the different functions used in sap script?
hi,how to diable the popup window which is displayed afetr executing the SAP script program?
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
What are the advantages and disadvantages of using views in abap programming ?
HOW TO DIFFERENT CALL TRANSACTION ON THE BASIS OF DOUBLE CLICKING ON DIFFERENT FIELD.
What is narrow casting and wide casting?
It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization
What are the aggregate objects in the dictionary? : abap data dictionary
Can we use flow logic control key words in abap/4 and vice-verse?
How to read files and process BDC's automatically ?
In the MM module for finding out the standard cost what is the view one has to look at?
What takes most time in SAP script programming?