Skip to Content
0
Former Member
Jul 04, 2009 at 09:33 AM

Performance For Select Query

33 Views

Hi,

User want from Date and Plant (Site) wise data only in below select.
Only ERDAT and WERKS satisfy in SELECTstmet. VBELN is blank.
For 1 month range its picking 15000 records.

How to improve its Performance ?

 SELECT vbeln
               erdat
                lfart
                lfdat
                bolnr
                traty
                traid
               bldat
               wadat_is
           FROM likp
           INTO TABLE itab_likp
           WHERE vbeln IN s_vbeln
             AND erdat IN s_dat01
             AND lfart IN s_lfart
             AND vstel IN s_lifnr
             AND werks IN s_werks.