inner joint ( memory )

[Former Member]

hi frds

i am writing the code for inner joint in se38 . That select qurrie is not completed also but from server its using more memory . why like that?

SELECT

A~MBLNR

A~BUDAT

A~XBLNR

B~BWART

B~MATNR

B~WERKS

B~LIFNR

B~MENGE

B~SGTXT

B~UMWRK

INTO CORRESPONDING FIELDS OF TABLE IT_SEL

FROM MKPF AS A INNER JOIN MSEG AS B

ON A_{MBLNR = B}MBLNR

• AND A_{MJAHR = B}MJAHR

WHERE A~MBLNR IN S_MBLNR

AND A~BUDAT IN S_BUDAT

AND B~WERKS IN S_WERKS.

i dint save or syntac-chek or exicute just i wrote code on SE38 thats it but at that time my system process ( crt + alt + del ) task manager ---preocesser

its occuring more memory for that nearly 90% usage of memory .... why why why like so ......( just writing the code why its coming like that)

this above statement was not showing like that if I do any changes in this ( if suppose its wrong select qurrie its taking more memory )

if its wrong or any thing why its occuping more memory ( while writing the code in SE38 at that time only any back-ground will go or eny thing else)

plse give detail responce

i am using 6.0 ver.........

[Former Member]

Please post the structure defined for IT_SEL also.