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.

How to display dynamic logo's in Smartforms? i mean to say different logo's on different pages?

2 Answers   Altimetrics, Cap Gemini,

---

What is IMG in SAP?

0 Answers  

---

What are the different message types available in the abap/4 ?

0 Answers  

---

what are conversion routines

3 Answers  

---

do 4 times. sy-tabix,sy-index. end do. what is the output ?

3 Answers   TCS,

---

What is the difference between select statement and provide statement

1 Answers  

---

when we use bdc and lsmw and bapis and ale idocs

4 Answers  

---

19) How to create client dependent tables and client independent tables?

1 Answers  

---

What are components of layout in scripts?

1 Answers  

---

Can we create Enhancements of our own, i.e. customer defined?

1 Answers   CSC,

---

Hi, How to call transaction( Any transaction ex:xk03)from ALV Report. Where should I write code?

1 Answers  

---

What are the organizational related infotypes? : abap hr

0 Answers  

---