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 Split one delivery into many ( Step by Step)?

2 Answers   Accenture,

---

What are the differences between primary and secondary indexes?

0 Answers  

---

A database table contains 3 fields(Student_no,Section,Total_marks).I want retrieve top 10 students from each section.Note:(Section contains data like A,B,C.Each section contains more than 10 students).

7 Answers   Enteg Technologies,

---

Can matchcode object contain ids with different update types? : abap data dictionary

0 Answers  

---

What are IDOCs?

1 Answers  

---

What's the use of AT PF event?

1 Answers   HP,

---

How to maintain lists?

0 Answers  

---

In the BADI,they are multiple Implementation.Could you please tell is there any procedure which are the implementation will execute and any order is the execute all the implementation for that Badi

1 Answers   TCS,

---

what is meant by enhancement category?

1 Answers  

---

How does the inventory get reduced after the delivery?

1 Answers  

---

What are selection texts?

1 Answers  

---

Explain a report that you recently did?

4 Answers   Atos Origin, Cap Gemini, Deloitte, FutureSoft,

---