Answer / manojkumar kotti

Following standards should be followed to improve the performance.

1. Avoid using * in select query.
2. Avoid using move corresponding.
3. Avoid using nested selects.
4. Avoid using nested loops.
5. Avoid using select query within loops.
6. Try to use the primary key with select query based on the requirement.
7. Fields in the select query should be in the same order as existing index
8. Avoid using delete statement within loops.
9. Use binary search clause with read statements.
10. Avoid using appending corresponding fields clause.

Regards,
Manoj.

Answer / ajay kumar

Performance tuning means analyising the performance of the
program.

Performance of the program depends on the data transfer.

By reducing the amount of data to be transfered, we can
improve the performance of the program.

Answer / niranj

increasing effeciency of programs thru optimized coding
eg : select ... table itab...
instead of
loop at itab

select ,...into itab..
endloop

Answer / lavanya

Performance tunning.

There are various steps to increase the performance of ABAP
report.

* should not use * in the select query ,instead use the
appropriate field names.
* In the occurs clause avoid using 0 instead use the number.
* try to use move-corresponding .
* use the aggregate statement.

How to see the error message if we use call transaction method in BDC ??

1 Answers  

---

if u have two internal table such as itab1 and itab2.in itab1 has four fields such as f1,f2,f3,f4 and in itab2 has two fields such as f1,f2.then how can u copy data from first internal table to second internal table.

5 Answers   Wipro,

---

how can you call two forms in one sap sprict print program

1 Answers  

---

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

2 Answers  

---

Will 50,000 records be uploaded directly into APP's Server?  

0 Answers  

---

What is locking? : abap data dictionary

0 Answers  

---

how many type of index are there

3 Answers   EDS,

---

What is value table? : abap data dictionary

0 Answers  

---

what is ment by view?how many types are there ?what are they?and what is the difference between data base view and projection view?

2 Answers  

---

what is DATA ,TYPES,PaRAMETERS called in ABAP terms?

3 Answers  

---

Is the basic list deleted when the new list is created?

0 Answers  

---

hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks

0 Answers   HP,

---