Answer / ramesh

(1) Try not to delete a record from internal table with in
a loop. Every time when you delete a record from internal
table the index of the table is regenerated and this can be
a major performance issue. So if you have to delet a record
from internal table, create an additional column in the I.T
say del_ind and you want to delete the record for a
particular condition. then the code should go something
like this

loop at itab.

...
...
if <cond> .
itab-del_ind = 'x'.
modify itab transporting del_ind.
....
.......
endloop.

delete itab where del_ind = 'x' .


(2) Always sort the internal table by <key> and try to use
the statement Read table itab with key = <kwy> binary
search.

(3) Instead of joins use the for all entries option

(4) If the number of entries in the internal table are less
and you want to modify the internal table in loop, then its
better to go for field symbols than the regular
loop at itab.
.....
modify itab
,,,
endloop.

The overhead of reading the internal table record into itab
header can be avoided. Field symbol directly modifies the
record in the current loop pass

I will post more whenever i get free time again
Hope these are helpful

Answer / thanks

Let's atlk about internal table
1) While fetching data from trasnparent table.
Fully used Index key.

2) befor deleting data from intrnal table, use Sort on
internal table..

3) while deleting particular field, do use the option
called comparing..you get this syntax in library.

4) Instead of multiple Loop statement, do use Loop + Read
table statement.

5) in your report, your main table is EKKO and based on
EKKO, you fetched the further data from EKPO and MARA..
here, if you failed to get the record from EKKO,
after select fields from EKKO..

if sy-subrc <> 0.
Exit.
ENDIF.

This comes out of the report, if you set any message like
information .."No data Exist", this would appear on the
screen.

6) Try to use for all entries syntax.

How can you call a page explicitly in smart forms?

1 Answers  

---

When is the top-of-page event triggered? : abap data dictionary

0 Answers  

---

can we write at-line-selection and at-user-command at a time in same program. plz some body help me to know this answer.

2 Answers   HP,

---

How to work on TCODE SE16?

3 Answers  

---

types of windows in smartforms?difference between them?

2 Answers   IBM,

---

Suppose, we are creating one table. at that time we are mention table space and size category. Generally size category is from 0 to 6 is available. suppose if we are declare size category as 0(zero). For 0 (zero) the size of rows is from 0(zero) to 19000. I have 25000 records to insert into table. but table size is declared as 0(zero). i.e 19000 records. what about remaining 6000 records. shall i insert in to table or not? if insert how can i do? if not insert what can i do? Please answer me? i faced this one in TCS interview.

2 Answers   TCS,

---

how many subscreens we can create in a main screen?

1 Answers  

---

if have 10 pages in script,how u can u start from 10th page?

1 Answers   Intelligroup,

---

will where conditions in a sql query help improve performance?

2 Answers  

---

How Group 10 sets of records per group of Internal Table in ABAP. Good Afternoon All, I have one internal table which have 400 records ,i need to group these records in set of 10 records . for example: ID value 2 100 1 95 3 90 4 85 6 80 7 75 8 70 10 65 9 60 ---------------------------------- Total : 720---------------------------------------1st group ------------------------------- 11 59 13 58 12 55 14 54 15 52 18 51 16 50 17 49 19 40 20 39 ------------------------------- Total : 507 -----------------------2nd Group ------------------------------ .......... .......... ........ please help me ....how i get this in abap. Thanks

2 Answers   Sasco,

---

Why are insert and append statement used in sap abap?

0 Answers  

---

Steps of creation of IDOC

5 Answers   IBM, TCS,

---