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

Explain the difference between function group and function module?

837


What are conversion routines? : abap data dictionary

791


What are the advantages of different types of bdc's?

715


What are the system fields? Explain?

857


How to combine multiple billing into one RV document ( Step by Step)?

1737


What are the different attributes that can be assigned to a variant?

789


What is a predefined type in abap?

855


What are the kinds of foreign key fields?

739


what is the process of creating quotation using BAPIs.

1801


How to transfer data into line items using batch input session method? : abap bdc

791


What is the max no of match code id's that can be defined for one match code object? : abap data dictionary

865


What is asynchronous and synchronous update?

769


What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?

1112


What are advantages and disadvantages of logical data base

1971


If yes then why do we require logical database

2901