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 many domains will create for one data element?

2 Answers   IBM,

---

Is a logical database a requirement/must to write an abap/4 query?

0 Answers  

---

hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

0 Answers  

---

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

1 Answers   Vanguard,

---

Can we use transfer dataset to transfer data in internal table ?

0 Answers  

---

---

list the important field symbol?

1 Answers  

---

What is Group by in Select statement?

0 Answers  

---

Can we create a data element without domain?

6 Answers  

---

What are Tickets in Realtime ?

0 Answers   XAQ,

---

Where are you used type casting?

0 Answers   Infosys,

---

Can we use same Domain for more than Data element?

5 Answers   HCL,

---

What are the 3 types of tables in sap? : abap data dictionary

0 Answers  

---