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
What are logical databases? : abap hr
Hi! I want to join SAP ABAP course in Hyderabad, can any one tell me where should I join? and Which is the best institute for SAP WORKSHOP? Thank you...
What are the requirements a dialog program must fulfill?
What is the table & field to identify the no of items (bottles) stored in one case?
What is the difference between collect and sum?
Can i Have Some Examples on Enhancements.
What is a transaction variant and why are they used?
How are the date abd time field values stored in sap?
How do you move on to the next screen in interactive reporting?
What data is contained in data dictionary? : abap data dictionary
Can you define a field without a data element? : abap data dictionary
Explain the uses of the simple maintenance interface? : sap abap hr
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary
SAP query how to use end users?