Answer Posted / 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.

2)In production what is the user exit?

1966

---

Can we display a list in a pop-up screen other than full-size stacked list?

1103

---

Define abap/4 layer?

1368

---

What is the function of a data element? : abap data dictionary

1072

---

What is the relationship existing between the various data elements in data dictionary? : abap data dictionary

1191

---

What do you do when the system crashes in the middle of a BDC batch session?

1176

---

Does the external program run in the same sap luw as the caller, or in a separate one?

1131

---

difference between Valuation type and valuation category?

2456

---

What is pnp-sw-found ? : abap hr

1433

---

In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?

2324

---

What is the difference between bdc_okcode and bdc_cursor? : abap bdc

1098

---

How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization

1085

---

What is gui status? How to create /edit gui status?

1075

---

What is exception class and test class. How to use it?

1385

---

While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization

1120

---