Skip to Content
0
Former Member
Aug 30, 2007 at 07:35 AM

Read mseg

151 Views

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