regarding bypassing buffer

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.