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.

What are the various types of selection screen event?

0 Answers  

---

scripts are client independent then how to transfer from one client to (i know RSTXR3TR AND SCC1 TCODE )another client?

2 Answers   Satyam,

---

Hi, can any one tell me the follwoing question's answer 1.How can we validate single selection screen field and multiple selection screen field in report and also in module pool programming.pls give answer in brief with example. 2.What is search help ? pls tell search help type breifly with example?

1 Answers   CTS,

---

what do u mean by assistance class ?(definition)

1 Answers   PWC,

---

project preparation,prepare blue print and realization what do u mean by this?

1 Answers  

---

---

Difference between domain and data element? What are aggregate object?

0 Answers  

---

What is the use of AT Selection Screen output when we have At selection screen?Can u explain?

6 Answers   Genpact, Wipro,

---

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

0 Answers  

---

What are logical data bases used in hr module

1 Answers  

---

How do you call a report from a transaction ?

3 Answers  

---

How to get that a secondary index is attached to a select query?

0 Answers   Infosys,

---

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

2 Answers  

---