Skip to Content
0
Former Member
Sep 21, 2007 at 06:07 AM

For All Entries with two tables

12573 Views

Hi All,

Can we use FOR ALL ENTRIES with two tables. for example

SELECT * FROM MKPF INTO TABLE T_MKPF

WHERE BUDAT IN S_BUDAT.

SELECT * FROM MARA INTO TABLE T_MARA

WHERE MTART IN S_MTART AND

MAKTL IN S_MAKTL.

SELECT * FROM MSEG INTO TABLE T_MSEG

FOR ALL ENTRIES IN "T_MKPF AND T_MARA"

WHERE MBLNR EQ T_MKPF-MBLNR AND

MATNR EQ T_MARA-MATNR.

can we do it like this or any other way to do this plz tell. I waitting for your responce.

Thanks

Jitendra