Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

INNER JOINT

HI Frds...

actually we should not write joint select qurrei for ( like & in )...but i did here

i got requriment if there is no input in selection also they want to see out put ...

at that when they exicute total data will come into internal table ... so in buffer

area capacity of this table is occurs 0.

so exectly i need to know if we keep occurs 100 . to this internal table IT_SEL.

the memory will increase or not ....

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question