u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?
Answers were Sorted based on User's Feedback
Answer / medepalli.sunil@gmail.com
If the report is taking time to fetch data from the database
server we have to make sure that there is an optimized
"query". In order to have an optimized query we need to
write an optimized "where" conditions. That's database part.
Coming to the Programming part.
Say example. Our program has the usage of 95% and the
database usage of 5 % then we have to see the program's
performance. Try to reduce the number of LOOP's in a program
and also try to use the logical operators where ever
necessary to reduce the size of the program . that could
solve the problem.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / jesuvin
Performance of reports could be increased by avaioind nested
select statements. Instead use Select ... FOR ALL ENTRIES.
Restrict the use of Select... Endselect, instead go for
select .. inot table itab and then loop at itab.
Avoid nested loop statement, Do not use select within loop.
Do not call function module within loop statement.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sreedhar
use performance tuning steps to get good performance of ur
program.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / venkateswarlu.bandi
Hi this is venkatesh,
this is my answer.
if it is too big means that is submitted into the
background processing.
that is which is using the standard program RSBDCSUB.
that is done by go thorugh transaction code is sm35.
atually all large programs are done by the background
porcessing only.
Is This Answer Correct ? | 0 Yes | 7 No |
After finding enhancements of a perticular transaction using SMOD, how can you opt one enhancement from all displayed enhacements?
Hi, can any one tell me the follwoing question's answer 1.How can we validate single selection screen field and multiple selection screen field in report and also in module pool programming.pls give answer in brief with example. 2.What is search help ? pls tell search help type breifly with example?
What is meant by hot spots? : abap data dictionary
Explain what are the different functions used in sap script? What are the parameters used in each function?
What is Transactional based Application & Role based Application?
how to create a button in selection screen?
how to placed drop down arrow in the input field of module pool table control/ steploop
what is the differance b/w template and table in Smartforms?
what is the field to be used in field catalog of an ALV report to hide the relevant column in the list?
Polymorphism real time scenario
In selection screen I have three fields- Plant, Material No, and Material group.If i insert plant how do i get the material no and material group based on plant dynamically?
Why we do Version comparison?