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.

The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization

0 Answers  

---

What is user specific parameter?

2 Answers  

---

What type of transport requests?

3 Answers   Wipro,

---

What are the developments you have done with data dictionary?

3 Answers   IBM,

---

can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table

0 Answers   Wipro,

---

Explain the difference between tables and structures?

0 Answers  

---

What is user exists?

2 Answers   FutureSoft, Unilogic Software,

---

Folder types in smatforms?

2 Answers   L&T, TCS,

---

Which one of the following statements would occur in the PBO of a dialog program using table control? a) module user_command. b) set screen '0100'. c) loop at itab. d) loop at itab with control itab_tc.

2 Answers  

---

How do you run the scripts?

2 Answers   FutureSoft,

---

control break statements in ABAP?

10 Answers   TCS,

---

How many types of tables exists and what are they in data dictionary?

1 Answers  

---