Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are logical databases? : abap hr

1194


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...

1498


What are the requirements a dialog program must fulfill?

1147


What is the table & field to identify the no of items (bottles) stored in one case?

2499


What is the difference between collect and sum?

1272


Can i Have Some Examples on Enhancements.

2520


What is a transaction variant and why are they used?

1136


How are the date abd time field values stored in sap?

1137


How do you move on to the next screen in interactive reporting?

1227


What data is contained in data dictionary? : abap data dictionary

1167


Can you define a field without a data element? : abap data dictionary

1204


Explain the uses of the simple maintenance interface? : sap abap hr

1112


dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?

3003


What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary

1087


SAP query how to use end users?

2250