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.

Difference between internal table and a dictionary table?

1 Answers  

---

What is an interactive report? What is the obvious differences of such report compared with classical type reports?

1 Answers  

---

What is the function of the transport system and workbench organiser?

0 Answers  

---

What is a matchcode?

0 Answers  

---

How to copy table across clients?

0 Answers  

---

Can a domain, assigned to a data element be changed? : abap data dictionary

0 Answers  

---

What are the types of table fields in the sap abap?

0 Answers  

---

what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

0 Answers  

---

What are the prerequisites for creating foreign key relationship?

0 Answers  

---

what is the event while entering data in screen to get next field.

2 Answers  

---

What is For-period and In-period

0 Answers  

---

How do you find the information on the current screen?

0 Answers  

---