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