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

What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?

697


What is database utility?

695


What kind of deliverables you have on a day to day basis?

958


What is primary index?

528


What is Group by in Select statement?

646






Write syntax for message error (report)?

625


Sal abap on hana interview

697


What is the use of a pretty printer?

601


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

558


How to write a code for multiple transactions? : abap bdc

533


PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..

1649


Difference between .Include and .append?

729


Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?

528


The max number of calling modes stacked at one time is?

580


Did you create secondary index?

686