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.