Skip to Content
0
Former Member
Feb 18, 2009 at 09:14 AM

dynamic select statement

1096 Views

Hi all,

I am going to use the SELECT statement with INNER JOIN. When I use the table names(at 2 places), it is working properly. When I use the dynamic names, it is giving syntax errors.

Can you please explain me how to use the dynamic names for SELECT statement with INNER JOINs..

Ex:

SELECT afieldname1 bfieldname2

INTO CORRESPONDING FIELDS OF TABLE lt_table

FROM (lv_tabname) AS a INNER JOIN

(lv_ttabname) AS b ON ( afieldname1 = bfieldname1 AND

b~fieldname2 = sy-langu ).

(This is not working.......)

Thanks and Regards,

Balakrishna.N