Skip to Content
0
Feb 15, 2011 at 07:44 AM

Performance issue on LIPS table

177 Views

Hi Experts,

I need to know the delivery for particular batches and materials,Hence i am using the below select query in my program

SELECT vbeln

posnr

matnr

werks

lgort

charg

lfimg

meins FROM lips

INTO TABLE int_lips

FOR ALL ENTRIES IN int_mchb

WHERE vbeln IN s_vbeln

AND pstyv IN s_pstyv

AND matnr EQ int_mchb-matnr

AND werks EQ int_mchb-werks

AND lgort EQ int_mchb-lgort

AND charg EQ int_mchb-charg.

My program is fine when delivery is given in the selection screen but it is taking lot of time when no delivery is entered in the selection screen.

Please guide me how can i increase my program performance. Is there is any need to create the secondary index?

Thanks in advance.

Regards,

Kavya