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.

Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?

0 Answers   Accenture, IBM,

---

Can we create a gui status in a program from the object browser?

0 Answers  

---

What are two different ways to add fields to sap tables?

0 Answers  

---

what is the difference between FOR ALL ENTRIES and SELECT * FROM ?

2 Answers  

---

pls tel me......how we link two fields by using foregin keys between two tables in sap abap?

1 Answers  

---

what is Tool view and Project view?

1 Answers   Steria,

---

what is the main difference between lsmw and bdc ? in which situation we will go for lsmw instead of bdc?

1 Answers   L&T,

---

Can we define our own match code id's for sap matchcodes? : abap data dictionary

0 Answers  

---

What are the program names for logical database PNP and PNPCE

1 Answers  

---

What is dialog module?

0 Answers  

---

What is runtime analysis?

0 Answers  

---

How to create any functions?

0 Answers  

---