SAP-Forum.ORG
   
This web site isn't affiliated with, sponsored by, or approved by SAP AG. Is only a SAP users community.

Go Back   SAP-Forum.ORG > SAP Forums > SAP ABAP

Similar Threads
Thread Thread Starter Forum Replies Last Post
Performance Monitoring sapen SAP CRM 0 11-26-2009 06:35 PM
how to tune the performance of following query? sapen SAP ABAP 0 09-30-2009 08:43 PM

Aprenda SAP!
Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2010, 12:45 PM
papa papa is offline
Junior Member
 
Join Date: Jan 2010
Location: Islandia
Posts: 18
Default Performance is very Slow in query

Hi experts!

How to increase performance for the following query BSIS?
Code:
select    a~saknr b~txt50 
            into corresponding fields of table it_table
            from skb1 as a
            inner join skat as b
            on a~saknr = b~saknr
            where a~saknr in v_variable
            and   a~bukrs eq company.

  
if sy-subrc eq 0.select bukrs hkont augdt
                  augbl zuonr gjahr 

         belnr buzei
         
         budat
         werks
         kostl
         aufnr
         shkzg
         dmbtr
         prctr
         into corresponding fields of table it_bseg
         from bsis
         for all entries in it_final
         where bukrs eq company
         and   prctr eq s_center
         and   gjahr eq s_gjahr			   							
         and   hkont eq it_table-glcode
         and   budat in s_budat                    "BETWEEN fromdt AND todt.
Any idea to better this query?
Reply With Quote
Sponsors
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 09:15 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Forum Design By inferno