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.