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 fields in a bdc_tab table? : abap bdc

0 Answers  

---

After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?

2 Answers   DELL,

---

Of the two call transaction and session method, which is faster?

0 Answers  

---

In Table Maintaince Generator for a table i need some fields to be filled default,like date from sy-datum.........when the displays initailly....HOw

2 Answers   HP,

---

Business scenarios related to your objects( In my case -Rulebook and Pricing work flow)

0 Answers   Infosys,

---

What is RFC function module?

2 Answers   CSC,

---

What is a matchcode?

0 Answers  

---

​​What is constructor expression in​​ nw​​ abap​​ 7.4?

0 Answers  

---

How to print Back to Back in Scripts?

3 Answers   Cap Gemini,

---

What is the company code? : sap abap hr

0 Answers  

---

What are different data types in ABAP?

1 Answers  

---

What is the difference between Classic badi and Kernal badi ?

0 Answers  

---