Skip to Content
author's profile photo Former Member
Former Member

inner joint ( memory )

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 AMBLNR = BMBLNR

  • AND AMJAHR = BMJAHR

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 11:59 AM

    Please post the structure defined for IT_SEL also.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.