Skip to Content
0
Former Member
Sep 11, 2010 at 09:16 AM

SELECT query performance issue

136 Views

Hello experts!!!

I am facing the performance issue in the below SELECT query. Its taking long time to execute this query.

Please suggest how can i improve the performance of this query.

SELECT MBLNR MATNR LIFNR MENGE WERKS BUKRS LGORT BWART INTO CORRESPONDING FIELDS OF TABLE IT_MSEG

FROM MSEG

WHERE MATNR IN S_MATNR

AND LIFNR IN S_LIFNR

AND WERKS IN S_WERKS

AND BUKRS IN S_BUKRS

  • AND XAUTO = ''

AND BWART IN ('541' , '542' , '543' , '544', '105' , '106').

Thanks in advance.

Regards

Ankur