topic Re: regarding bypassing buffer in Application Development and Automation Discussions

regarding bypassing buffer

Former Member — Thu, 19 Jul 2007 14:58:58 GMT

hi,

when we are <b>using joins in the select statement</b> can we use addition <b>bypassing buffer</b> for that

example.

SELECT A_{EQUNR A}EQTYP A_{MATNR A}SERNR A_{OBJNR B}HEQUI

INTO TABLE IT_EQUI

FROM EQUI

AS A JOIN EQUZ AS B ON A_{EQUNR = B}EQUNR

WHERE A~EQUNR IN S_EQUNR.

i have used bypassing buffer it gives error.

Re: regarding bypassing buffer

Former Member — Thu, 19 Jul 2007 15:02:48 GMT

chk this

i did not get any eeror

REPORT ZWOP_TEST1 .


DATA : BEGIN OF ITAB OCCURS 0,
         MATNR LIKE MARA-MATNR,
         MAKTX LIKE MAKT-MAKTX,
       END OF ITAB.

SELECT MARA~MATNR
       MAKT~MAKTX
       FROM MARA AS MARA INNER JOIN
            MAKT AS MAKT ON
            MARA~MATNR = MAKT~MATNR
            INTO TABLE ITAB
            BYPASSING BUFFER.