how will u write a report for performance point of
view ?
Answers were Sorted based on User's Feedback
Answer / rahul singh
1. Don't use the followings :-
a. loop within loop.
b. select endselct.
c. Occur (statements)
d. Move corresponding.
e. use of cluster tables.
f. use select * (all feilds)
g. use of OR statement in select statement.
h. use of negative conditions.
2. Use the following :-
a. loop with reads if needed to be read multiple time.
b. Use of IN statement in select statement instead of OR.
c. use of maxium key feilds with select statement.
d. use of function modules instead of select statement
if it is available.
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / muralitharan
Additional to above points,
In select query Use For All Entries while pulling data from
database.
Frequently don't use inner join in your program
While Looping create work area and process the record
These are some points to improve performance of program
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / jc
1. Clear understanding of requirement.
2. Construct the how-to before actual coding starts.
3. Avoid using multiple read to the same database table.
4. Make sure to use indexed field while reading to database table.
Is This Answer Correct ? | 7 Yes | 2 No |
What are datasets in abap?
Explain buffering concept usage?
When you prefer lsmw?
what are use of ok_code in bdc
When value table becomes check table?
what are the diff types of dispatcher in sap ?
What are the difference between pool tables and transparent tables?
who will release request number?
what is check table..what is domain?
What will you code in start-of-selection & end-of-selecton & why?
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
Explain the session method? : abap bdc