Dynamic table name in an inner join - select statement

[Former Member]

Hi,

Please can you let me know if is possible to use a Dynamic table name in an inner join?

Something like the statement below? (It works in a simple select statement but not in an inner join)

SELECT *

INTO CORRESPONDING FIELDS OF <t_itab>

FROM <Dynamic table name> INNER JOIN pa0050 ON

( <Dynamic table name>_{pernr = pa0050}pernr )

WHERE <Dynamic table name>~pernr = it_pernr-l_pernr

AND pa0050~bdegr = f_bdegr.

Any help would be apprecited very much.

Thanks & Regards.

[Former Member]

Hi,

Please can you let me know if is possible to use a Dynamic table name in an inner join?

Something like the statement below? (It works in a simple select statement but not in an inner join)

SELECT *

INTO CORRESPONDING FIELDS OF <t_itab>

FROM <Dynamic table name> INNER JOIN pa0050 ON

( <Dynamic table name>_{pernr = pa0050}pernr )

WHERE <Dynamic table name>~pernr = it_pernr-l_pernr

AND pa0050~bdegr = f_bdegr.

Any help would be apprecited very much.

Thanks & Regards.

[Former Member]

hi,

You can try like below, i dont know whether it work or not, just check...

SELECT *
INTO CORRESPONDING FIELDS OF (lv_itab)
FROM (db_tab) as a INNER JOIN pa0050 ON
( a~pernr = pa0050~pernr )
WHERE a~pernr = it_pernr-l_pernr
AND pa0050~bdegr = f_bdegr.

Ensure that the fields in condition are there in the dynamically given table.

Regards

Karthik D

[Former Member]

Hi,

Check this link.

[http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/frameset.htm]

[;

hope it'll help u.

Regards,

Sneha.

Edited by: sneha kumari on Jun 18, 2009 1:57 PM

[ThomasZloch]

This explains what you need to do:

http://help.sap.com/abapdocu/en/ABAPFROM_CLAUSE.htm#!ABAP_ALTERNATIVE_3@3@

Thomas

[Former Member]

Hi,

Thank you so much for your very helpful answers.

This solved the problem. Thank you.

CONCATENATE i_db_table_name ' as a INNER JOIN pa0050 ON'

' ( a_{pernr = pa0050}pernr )'

INTO dbtab_syntax.

SELECT (column_syntax)

FROM (dbtab_syntax)

INTO CORRESPONDING FIELDS OF <t_itab>

WHERE a~pernr = it_pernr-l_pernr

AND pa0050~bdegr = f_bdegr.

Thanks & Regards.