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

Explain the difference between call screen and leave screen?

609


Explain what are standard layouts sets in the sap script?

946


What is the syntax for ‘call transaction’?

614


What is the abap program name to process the batch input session automatically? : abap bdc

654


Why do we use logical blocks in abap program?

1453






What is value table?

584


Explain the disadvantages of logical databases?

555


What is a transaction variant and why are they used?

560


How the at-user command serves mainly in lists?

620


What are the two ways of producing a list within a transaction?

623


Can you print decimals in type n?

570


Does the table can have multiple foreign keys?

597


I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?

1537


What are authorization objects and what statement is used to perform an authorization check in an abap program?

569


In what ways we can get the context sensitive f1 help on a field?

602