Skip to Content
0
Former Member
Jul 13, 2007 at 11:22 AM

Regarding Query

17 Views

hi all,

this is my code .....i have four internal table and want all fields of that four table into final internal table.....

SELECT * FROM LFA1

INTO CORRESPONDING FIELDS OF TABLE IT_FINAL

WHERE KTOKK IN S_VGROUP.

SELECT * FROM LFM1

INTO CORRESPONDING FIELDS OF TABLE IT_LFM1

FOR ALL ENTRIES IN IT_FINAL

WHERE LIFNR = IT_FINAL-LIFNR.

SELECT * FROM LFBW

INTO CORRESPONDING FIELDS OF TABLE IT_LFBW

FOR ALL ENTRIES IN IT_FINAL

WHERE BUKRS IN S_VGROUP

AND LIFNR = IT_FINAL-LIFNR.

SELECT * FROM J_1IMOVEND

INTO CORRESPONDING FIELDS OF TABLE IT_J_1IMOVEND

FOR ALL ENTRIES IN IT_FINAL

WHERE LIFNR = IT_FINAL-LIFNR.

how to collect data from remaining three table into IT_FINAL table based on vendor no as i hv written in querry.....

Regards,

Imran