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 components of SAP scripts?

2 Answers  

---

why we have to define function group?

2 Answers  

---

what is the difference between bdc and lsmw?

2 Answers  

---

What are null values? : abap data dictionary

0 Answers  

---

can any one tell me if i will put mode as error(E) in session or call transaction for at background and if any error data is there in flat file , then what will be happen ,

1 Answers  

---

What are vale table check table? What's the difference between the two? Explain with simple example taking table.

1 Answers   HP,

---

6. what are the differences between scripts & smart forms?

2 Answers  

---

How to create a link between modified form and modified print program?

0 Answers  

---

What are the buffering types?

0 Answers  

---

What is meant by hide area?

0 Answers  

---

Did u inherit any standard sap programs? what are they? and for what purpose you have done it?

1 Answers   Wipro,

---

how will u handle multiple line items in a table control?

4 Answers   Logica CMG,

---