Interested to Buy Any Domain ? << Click Here >> for more details...
Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 10053 Views
- I also Faced
- E-Mail Answers
Answer Posted / sukhbir
Best option will be to select the data before loop and
inside loop use read statement.
select f1 f2 f3(key fields) from db into
iNtertab
for all entries in itab
where condition.
sort intertab by f1.
loop at itab.
read intertab with key f1 = itab-f1
binary search.
Endloop.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
What are the disadvantages of different types of bdc's?
What is a sequence of event-triggered in report?
If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
How many ways you can create table? : abap data dictionary
What is amdp (abap managed data procedures)?
How many types of size categories and data classes are there?
What is the transaction code to display the payroll results ? : abap hr
How would you suppress the display of a parameter on the selection screen?
What is the role of ‘refresh’ in internal table?
How can we upload a text file having delimiters in to legacy system?
What is the project you are currently working and work that you are doing
What are the steps to be followed to set lockobjects? : sap abap data dictionary
