topic Re: Select-join from (TABNAME) problem in Application Development and Automation Discussions

Select-join from (TABNAME) problem

Former Member — Tue, 26 Sep 2006 15:16:52 GMT

I wonder, if anybody can answer, why this code cann't be compiled:

SELECT DISTINCT (ls_dynqr-fields)

INTO TABLE lt_doclist

FROM (ls_dynqr-tablename) AS a

INNER JOIN /abat/mcrm_mycus AS b

ON a_{kunnr = b}kunnrx AND

b~bname = sy-uname

UP TO lv_pmax ROWS

WHERE (ls_where-where_tab).

Tablename, list of fields and where-clauses are specified at runtime. Without JOIN it works fine, but with it it can not be compiled because of incorrect FROM condition, I meen unexpected 'JOIN' after 'FROM'.

Re: Select-join from (TABNAME) problem

RichHeilman — Tue, 26 Sep 2006 15:25:01 GMT

Not sure that you can do a dynamic inner join. You might try splitting it up and using FOR ALL ENTRIES in your second select statement.

Regards,

Rich Heilman

Re: Select-join from (TABNAME) problem

Former Member — Tue, 26 Sep 2006 15:26:34 GMT

Joins are not possible in dynamic SELECT statements as it cannot validate the same during you compilation.

Re: Select-join from (TABNAME) problem

Former Member — Wed, 29 Nov 2006 04:21:58 GMT

HI Aleksandr,

I am trying to use Table in from clause dynamically. But unable.

Can you please let me know what ls_dynqr-tablename is declared as?

Thanks

Shashi

Re: Select-join from (TABNAME) problem

seshatalpasai_madala — Wed, 29 Nov 2006 04:38:44 GMT

Hi,

The problem is in JOIN ON, you have given b~bname = sy-uname, this should have been given in the WHERE clause not in the JOIN ON remove it from JOIN ON and put it in Where clause.

Regards,

Sesh