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

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

How many types of data classes are there in sap?

1039


What happens Update command is used without where clause ?

1178


What is direct input method ?

1936


What is the process to enhance the Infotype

3411


how can we enable hyperlink in screen painter?

3907


How to debug a sapscript?

1040


How can the standard tables of sap be modified?

1131


What are the attributes of the data? : abap data dictionary

1071


SM35 transaction, How to automate BDC ?

1175


Is main window mandatory in smartforms?

1180


How is conversion of data types done between abap/4 & external level?

1029


Is it possible to pass data to and from include programs explicitly? : abap modularization

1272


what are the critical issues u face in ur project?

2542


when are objects are passed from task to the change request?

2092


There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.

1376