Skip to Content
0
Former Member
Mar 21, 2006 at 11:34 AM

Performance issue on MSEG table where condition is MATNR, WERKS and LGORT

412 Views

I have performance problem while reading MSEG Table:

1. Getting MATNR, WERKS and LGORT from MARD table

2. Using MATNR, WERKS and LGORT i am retriving the data from MSEG which is taking lot of time

here its a major performace problem.

SELECT MBLNR

MJAHR

ZEILE

MATNR

WERKS

LGORT

KUNNR

EBELN

EBELP

from mseg

into table t_mseg

for all entries in t_mard

where matnr eq t_mard-matnr

and werks eq t_mard-werks

and lgort eq t_mard-lgort.

Please let me know is there any other solution to retrive the data from MSEG using MATNR, WERKS and LGORT