Answers were Sorted based on User's Feedback
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
loop at itab.
if <cond> .
itab-del_ind = 'x'.
modify itab transporting del_ind.
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
(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.
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
|Is This Answer Correct ?||4 Yes||0 No|
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
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
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.
This comes out of the report, if you set any message like
information .."No data Exist", this would appear on the
6) Try to use for all entries syntax.
|Is This Answer Correct ?||2 Yes||0 No|
Why first check bapi , if not available go bdc ?
1.How can u set more than one selection screen for one report? 2.Where u can provide initial values other than in INITIALIZATION event?
What is direct input method ?
What is the purpose of buffering? How many types of buffering?
Q : I want to see material details in secondary list based on material No. from basic list. I will double click on any row, any field of basic list (not on field containing material no.) & the secondary list will display material details according to material No. on that row. Is it possible? If so how?
What functions does a data dictionary perform? : abap data dictionary
can u send the results from report to sap memory?
what is the difference between user exit and customer exit? what is ment by cusomer exit?and what is the difference between user exit and badi?
5) How to rereive text elements in SF and script?
What is ABAP query?
what is difference between occurs1 and occurs2?
What are the aggregate objects in data dictionary? : sap abap data dictionary