inner joint ( memory )

Former Member — Sun, 25 Nov 2007 07:21:47 GMT

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.........

Re: inner joint ( memory )

Former Member — Fri, 30 Nov 2007 11:59:37 GMT

Please post the structure defined for IT_SEL also.

topic inner joint ( memory ) in Application Development and Automation Discussions

inner joint ( memory )

Re: inner joint ( memory )