Dynamic query problem

[vallamuthu_madheswaran2]

Hi Friends,

I'm using the following dynamic query.

LOOP AT i_v_t190 INTO w_v_t190.

     l_tblname = w_v_t190-gstru.

     SELECT * FROM (l_tblname)

     APPENDING CORRESPONDING FIELDS OF TABLE i_tabname

*    FOR ALL ENTRIES IN i_v_t190

     WHERE vrsio = c_ver_000

       AND spmon IN s_spmon

*      AND konob = i_v_t190-konob

       AND matnr IN s_matnr

       AND vkorg IN s_sorg

       AND vtweg IN s_vtweg

       AND kunnr IN s_kunnr.

     IF sy-subrc = 0.

       SORT i_tabname BY matnr.

     ENDIF.

endloop.

Now my question: is it possible to use inner join the dynamic table (l_tblname)

Thanks & Regards,

Vallamuthu.M

Moderator message : Not enough re-search before posting, discussion locked.

Message was edited by: Vinod Kumar

[kesavadas_thekkillath]

It's possible. Please read SAP help. This has been discussed many times in the forums, so search for it.