Answer / marek

I assume this question is not about SAP HANA, but the old fashion data bases.

You should avoid selection from cluster data base table. The better way to do this is to use base tables. For example if you want to select data from BSEG table you should use "lower level" tables like BSAK BSIK BSAD BSAK etc.

Also to achieve this you can use standard function module or some kind of BAPI designed for this purpose.

As always you should remember to use optimized WHERE part of the query and WHOLE key in exact the same order like it is in data base (of course this optimization practices can only be applied to one type of DB, Orcale and MS have different ways to optimize the SELECT statement). Additionally you should one import fields you need to, trying to avoid the '*' usage as much as possible. Using FOR ALL ENTRIES and INTO CORRESPONDING FIELDS is not efficient as well.

what are the diff page formats available in SMARTFORMS ?

1 Answers   Genpact,

---

What is report category and for what purpose do we use report category

2 Answers  

---

What are the disadvantages of using explicit enhancement?

0 Answers   Infosys,

---

what is view?different types of views?

3 Answers   NTT Data,

---

in session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?

3 Answers  

---

Which of the following assigns work to the application server? Options ::Dispatcher, work process, roll area

4 Answers   Accenture,

---

Tcode for enhancements?

4 Answers   Wipro,

---

How can we call, call transaction and session method in the same program?

3 Answers   Cap Gemini,

---

Explain sap abap 3-tier architecture?

0 Answers  

---

can we write at-line-selection and at-user-command at a time in same program. plz some body help me to know this answer.

2 Answers   HP,

---

If s1 and s2 are different structures how will u transfer

1 Answers  

---

How to insert a line into abap internal tables?

0 Answers  

---