INNER join with dynamic table name ?

[Former Member]

Hi,

I have a problem with this statement.

DATA: g_dso_bic_dofr TYPE tabname.

SELECT t1~/bic/ziparomr
       t2~/bic/zifremom
 INTO (wa_rater_paromr-/bic/ziparomr,
       wa_rater_paromr-/bic/zifremom)

*   FROM /bic/azd0bfr5100 AS t1     "equivalent to the dynamic statement below

" this is the  problem
    FROM (g_dso_bic_dofr )AS t1
    INNER JOIN /bic/pzifremom AS t2 
      ON t1~/bic/ziparomr = t2~/bic/ziparomr 
" --- to here 

    WHERE t1~/bic/zikom     =  v_kommune

The compile check doesnt work when i use the variable table name.

I get

"Wrong expression "INNER" in FROM clause. WHERE condition."

Can anyone help me.

Br Rasmus.

[JozsefSzikszai]

hi Rasmus,

I tried and it looks like that it does not work...

ec

[Former Member]

Check my weblog...It might help you -;)

<a href="/people/alvaro.tejadagalindo/blog/2006/12/13/dynamic-inner-join-function-module Inner Join Function Module</a>

Greetings,

Blag.

[alejandro_bindi]

" this is the  problem
*    FROM (g_dso_bic_dofr )AS t1   "<<--- check spaces in here
    FROM (g_dso_bic_dofr) AS t1    "<<--- and here
    INNER JOIN /bic/pzifremom AS t2 
      ON t1~/bic/ziparomr = t2~/bic/ziparomr 
" --- to here 

I think there's the problem, the space behind the parenthesis.

Regards

[Former Member]

This is for no reason an illegal statement.

Solved with an internal table and FOR ALL ENTRIES