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
Explain how to create any functions? How to go about it?
What kind of deliverables you have on a day to day basis?
while implementing badi what are the tables u find??
How do you set up background jobs in sap?
What are the different abap/4 editors?
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.
What are the functional modules used in sequence in bdc? : abap hr
How is conversion of data types done between abap/4 & db layer?
How will you find manager of an employee
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
Explain the difference between a pool table and a transparent table?
What is a data class? : abap data dictionary
How to transfer data into line items using batch input session method? : abap bdc
What are the parameters in bdc_insert? : abap bdc
Which function module would you use to check the user’s authorization to access files before opening a file?