You are running a report. It is taking long time for
execution. What steps will you do to reduce the execution time.
Answers were Sorted based on User's Feedback
Answer / venkateswari
in this u should n'tuse select *
do n't use nested selects
do n't use nested loops
do not use select and end select
do n't use use select query in a loop
|Is This Answer Correct ?||2 Yes||0 No|
Answer / ajayrajareddy
i think we are not using any absolute statements,
must check the extended program check and rectify some of
the errors... and we never wright nested loops also....
|Is This Answer Correct ?||0 Yes||0 No|
How we can give authorization on the fields of table control in a dialog-programming?
1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?
What is the difference between table and template?
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
I am trying to automate a manual processing of iDOCs in BD87. I used the following code to pass idoc-id to global variable 'DCN' and then skip the first screen of BD87 to go to processing directly. After running this code SET PARAMETER ID 'DCN' FIELD itabhdr-idoc_id. CALL TRANSACTION 'BD87' AND SKIP FIRST SCREEN. it takes me to the first screen because it cannot recognize my idoc-id. How I can pass idoc-id to global? I have used the above code to goto VA02 with VBELN and it worked perfectly.
in what application server the business logic is developed/deployed?
I want to disable a field in selection screen so that it does not appear while displaying.How can i do that?wat wud be the code?
What are the sequences of event block?
how do you pass table to function module?
while running bdc call transaction method for user defined table, all the records are saved except the last record. whats the problem? can anybody clarify me?
differences b/w primary indexes and secondary indexes
why we are using pgm RSTXTRAN?