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