You are running a report. It is taking long time for
execution. What steps will you do to reduce the execution time.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to create any functions? How to go about it?

533


What kind of deliverables you have on a day to day basis?

952


while implementing badi what are the tables u find??

3610


How do you set up background jobs in sap?

557


What are the different abap/4 editors?

554






B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.

2447


What are the functional modules used in sequence in bdc? : abap hr

582


How is conversion of data types done between abap/4 & db layer?

625


How will you find manager of an employee

845


how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran

2032


Explain the difference between a pool table and a transparent table?

523


What is a data class? : abap data dictionary

617


How to transfer data into line items using batch input session method? : abap bdc

575


What are the parameters in bdc_insert? : abap bdc

792


Which function module would you use to check the user’s authorization to access files before opening a file?

595