Dynamic query problem

vallamuthu_madheswaran2 — Thu, 15 Mar 2012 12:11:54 GMT

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

Re: Dynamic query problem

kesavadas_thekkillath — Thu, 15 Mar 2012 12:28:16 GMT

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