Skip to Content
0
Jun 03, 2020 at 12:04 PM

Select Query Performance issue

179 Views

Dear Experts,

Could you please tell me how to improvise the below code.

Fetching the data from LIKP and LIPS without non key fields, its taking 5 to 10 min to execute,as user requirement is not use the vbeln as input and improve performance.

SELECT t1~vbeln t1~vstel
t1~kodat t1~kunag t1~kunnr
t1~wadat t1~wadat_ist t2~posnr t2~pstyv
t2~werks t2~matnr t2~arktx t2~charg
t2~spart t2~lgort
INTO CORRESPONDING FIELDS OF TABLE i_delpos
FROM likp AS t1 INNER JOIN lips AS t2
ON t2~vbeln = t1~vbeln
WHERE t1~wadat IN s_date
AND t1~vstel IN s_vstel
AND t2~werks IN s_werks
AND t2~matnr IN s_matnr
AND t2~spart IN s_spart
AND t2~lgort in s_lgort.