Skip to Content
0
Former Member
Mar 13, 2007 at 09:34 AM

problem in accessing mseg table using MSEG~M Index.

217 Views

Hi Experts,

I am facing problem in accessing mseg table using MSEG~M Index. I used same sequence of fields and i tried with mandt field also. but it is not taking the Index and it is going for TImeout ABAP dump.

This are my codes used in different ways

1. SELECT mjahr

bwart

matnr

lifnr

dmbtr

kostl

aufnr

bukrs

FROM mseg CLIENT SPECIFIED INTO TABLE t_mseg2

WHERE mandt EQ sy-mandt AND

matnr NE SPACE AND

werks EQ p_werks AND

lgort NE '0000' AND

bwart IN (122,201,262) AND

sobkz NE '0'

%_HINTS ORACLE 'INDEX("MSEG" "MSEG~M")'.

2. SELECT mjahr

bwart

matnr

lifnr

dmbtr

kostl

aufnr

bukrs

FROM mseg INTO TABLE t_mseg2

WHERE matnr NE SPACE AND

werks EQ p_werks AND

lgort NE '0000' AND

bwart IN (122,201,262) AND

sobkz NE '0'

%_HINTS ORACLE 'INDEX("MSEG" "MSEG~M")'.

3. SELECT mjahr

bwart

matnr

lifnr

dmbtr

kostl

aufnr

bukrs

FROM mseg INTO TABLE t_mseg2

WHERE matnr NE SPACE AND

werks EQ p_werks AND

lgort NE '0000' AND

bwart IN (122,201,262) AND

sobkz NE '0'.

The above all code is not at all taking the index in Quality server .but in Development it is taking .In Quality server it is reading all datas without using the index and going Timeout ABAP dmup

Please, Suggest me some solutions.

Thanks in Advance.

Regards,

Nandha