Hi all
i have program reading mseg,when the system reas mseg it's getting very slow,please help me ,pleas find the code follows
SELECT AWERKS ASAKTO AKOSTL AMENGE ADMBTR AMATNR ABWART BMAKTX
CTXT50 DBUDAT DMBLNR EZEINR INTO
CORRESPONDING FIELDS OF TABLE IT_ITAB
FROM MSEG AS A INNER JOIN MAKT AS B ON AMATNR = BMATNR
INNER JOIN GL_ACCT_CC_TEXT AS C ON ASAKTO = CSAKNR
INNER JOIN MKPF AS D ON AMBLNR = DMBLNR
INNER JOIN MARA AS E ON AMATNR = EMATNR
WHERE D~BUDAT IN PR_DATE AND
A~WERKS = PR_WERKS AND
A~SAKTO IN PR_SAKTO and
( aBWART ='201' or aBWART ='202' ).
thanks
kanishka