MB5B index

Hi all,

Below select statement used in MB5B. It is very slow.

does anyone know indexes of below query.

SELECT (G_T_MSEG_FIELDS)

INTO CORRESPONDING FIELDS OF TABLE G_T_MSEG_LEAN

FROM MKPF AS MKPF JOIN MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE MSEG~MATNR IN MATNR

AND MSEG~WERKS IN G_RA_WERKS

AND MSEG~LGORT IN G_RA_LGORT

AND MSEG~CHARG IN C.HARG

AND MSEG~BWTAR IN BWTAR

AND MSEG~BWART IN BWART

AND MKPF~BUDAT GE DATUM-LOW

AND MSEG~SOBKZ IN G_RA_SOBKZ

%_HINTS

DB2 '&SUBSTITUTE VALUES&'

ORACLE '&SUBSTITUTE VALUES&'.

Thanks,

Vikas