What are steps you follow to improve the performance of a
report ?

Answer Posted / lokesh

Performance of the report can be improved by reducing the
data transfer .
1) Having an internal table without a work area is better
for performance.
2) Use FOR ALL ENTRIES in your SELECT statement to retrieve
the matching records at one shot.
3) Avoid using nested SELECT statement, SELECT within
LOOPs.
4) Avoid using INTO CORRESPONDING FIELDS OF TABLE. Instead
use INTO TABLE.
5) Avoid using if/endif instead use CASE/ENDCASE

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is For-period and In-period

1944


What are the list of screen elements?

730


What is the difference between a pool table and a transparent table?

733


Explain the different types of data dictionary objects?

687


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary

911






Did you create primary index?

734


Differentiate between static and dynamic step loops?

756


Explain how data is stored in cluster table?

879


What is foreign key relationship? : abap hr

783


Difference between select option and ranges ?

824


What are the uses of the information in the data dictionary? : abap data dictionary

960


What is lock object ? : abap data dictionary

780


Explain badi in abap.

761


What is the function of a data element?

799


Module Pool Programming: Events and Table Control handling.

1053