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 can we declare a table control in the abap/4 program?

0 Answers  

---

Explain some essential objects in abap dictionary?

0 Answers  

---

tcode to find applicatin server directories?

1 Answers  

---

how many times a main window can be placed on placed on the same page in a layout

1 Answers   IBM,

---

Can a transparent table exist in data dictionary but not in the data base physically?

2 Answers  

---

You are given functional specs for a BDC program and you need to decide whether to write a method call transaction or a session. How u will decide?

2 Answers   IBM,

---

How to call a subroutine in sapscript?

0 Answers  

---

what is the way to precide search helps in POV?

3 Answers   Accenture,

---

What is the use of update Function Module ? Where it is used and purpose ?

1 Answers  

---

In the MM module for finding out the standard cost what is the view one has to look at?

0 Answers  

---

How many ways you can create table? : abap data dictionary

0 Answers  

---

Dear Experts pls answer the folowing qs that i have faced in the recent intvws: a) Can we execute the script individually? If yes How? Else what we need to do so? b) Are Layout sets Client independent? c) How do you assign a print program to a script? d) Can we call a subroutine in a script? If so, how? e) What are the steps to print SAP script form?

2 Answers   Cap Gemini,

---