Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Problem in Select query

Hi,

I have performance Problem in following Select Query :

SELECT VBELN POSNR LFIMG VRKME VGBEL VGPOS

FROM LIPS INTO CORRESPONDING FIELDS OF TABLE GT_LIPS

FOR ALL ENTRIES IN GT_EKPO1

WHERE VGBEL = GT_EKPO1-EBELN

AND VGPOS = GT_EKPO1-EBELP.

as per trace i have analysed that it is fetch the complete table scan from the LIPS table and table contants almost 3 lakh records.

Kindly Suggest what we can do to optimize this query.

Regards,

Harsh

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question