Answer / medepalli.sunil@gmail.com

If the report is taking time to fetch data from the database
server we have to make sure that there is an optimized
"query". In order to have an optimized query we need to
write an optimized "where" conditions. That's database part.

Coming to the Programming part.

Say example. Our program has the usage of 95% and the
database usage of 5 % then we have to see the program's
performance. Try to reduce the number of LOOP's in a program
and also try to use the logical operators where ever
necessary to reduce the size of the program . that could
solve the problem.

Answer / jesuvin

Performance of reports could be increased by avaioind nested
select statements. Instead use Select ... FOR ALL ENTRIES.

Restrict the use of Select... Endselect, instead go for
select .. inot table itab and then loop at itab.

Avoid nested loop statement, Do not use select within loop.

Do not call function module within loop statement.

Answer / sreedhar

use performance tuning steps to get good performance of ur
program.

Answer / venkateswarlu.bandi

Hi this is venkatesh,
this is my answer.
if it is too big means that is submitted into the
background processing.
that is which is using the standard program RSBDCSUB.
that is done by go thorugh transaction code is sm35.

atually all large programs are done by the background
porcessing only.

After finding enhancements of a perticular transaction using SMOD, how can you opt one enhancement from all displayed enhacements?

3 Answers   HP,

---

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 is meant by hot spots? : abap data dictionary

0 Answers  

---

Explain what are the different functions used in sap script? What are the parameters used in each function?

0 Answers  

---

What is Transactional based Application & Role based Application?

0 Answers   PWC,

---

---

how to create a button in selection screen?

2 Answers  

---

how to placed drop down arrow in the input field of module pool table control/ steploop

3 Answers   TCS,

---

what is the differance b/w template and table in Smartforms?

5 Answers  

---

what is the field to be used in field catalog of an ALV report to hide the relevant column in the list?

1 Answers  

---

Polymorphism real time scenario

0 Answers   Infosys,

---

In selection screen I have three fields- Plant, Material No, and Material group.If i insert plant how do i get the material no and material group based on plant dynamically?

2 Answers   DataMetrix,

---

Why we do Version comparison?

2 Answers   IBM,

---