Answer / pnrao.abap

Select Statement
Inner join
Subroutines
Debugging Techniques-Watch Point
- Breack Point
Runtime Analasys-SE30
SQL Trace-ST05
Data browser-se16

Answer / venkata ramamohana rao s

in select statement mainntain the list of field of what do
u want to fetch the information from DB instead of "select
* " and mention the primary key in where condition ins.

remove select and endselect statement.

using FOR ALL ENTRIES.

remove the nested loops.

never maintain the select statement between the loop.

remove the move-corresponding statement.

using select single

Answer / raghunath

check the select statements and use all the key fields in
the select statement.
Try using for all entrie where ever possible
Avoid select end select statement
Avoid select statement in a loop
use run time analysis nd try to redude the data base time
as low as possible.

Answer / supriya

1. Should be the sequence of fields in Internal Tables n in
SELECT statement same as Database table fields sequence, 3
of the sequence should b same.

2. Try to use SELECT SINGLE statement
3. Always use BINARY SEARCH
4. Make use of Primary keys
5. Use ST05, SE30, SQLTrace
6. Avoid SELECT statement in Between LOOP ENDLOOP.

how to debug dialog box?

3 Answers  

---

What are labels in scripts..? why are they not accpeted in smartforms..?

2 Answers   IBM,

---

I have two structures s1 and s2 have same struture of five fields each how can u transfer data from s1 to s2

3 Answers   Unilogic Software,

---

Can we use same DATA ELEMENT for more than one field?

7 Answers   HCL, Unilogic Software,

---

How will you insert record in a sorted table

0 Answers   Infosys,

---

What is abap dictionary or data dictionary? What is the transaction to access abap dictionary? : abap data dictionary

0 Answers  

---

What is difference between dialog program and a report?

0 Answers  

---

what is session and what is the use of that one?

2 Answers   Keane India Ltd,

---

what are ALV reports? how they are different from normal reports?

2 Answers  

---

How did you test the form you developed? How did you taken print?

0 Answers  

---

WHAT IS FIELD-SYMBOLS?

2 Answers   Sony,

---

Name a few data dictionary objects? : abap data dictionary

0 Answers  

---