topic Re: How i select from (conditional table)? in Application Development and Automation Discussions

How i select from (conditional table)?

former_member996305 — Thu, 17 Jan 2013 09:54:30 GMT

Hi,

i want to select from different tables without to do two select. I want to choose which table i do the select with a condition before.

I try something like this but it didn't work.

DATA lv_table TYPE char10.

IF .........

lv_table = 'sel_table1'.

else.

lv_table = 'sel_table2'.

ENDIF.

SELECT * FROM (lv_table) INTO TABLE wa_table

WHERE .......... IN ..........

I dont know if the brackets are the right way to do it.

any help are accepted.

Thanks

Dio

Re: How i select from (conditional table)?

yogendra_bhaskar — Thu, 17 Jan 2013 10:02:34 GMT

Hi Dio ,

TRY this , it will work

DATA lv_table TYPE char10.

DATA : X_HEADER LIKE VIMDESC.

IF .........

lv_table = 'sel_table1'.

else.

lv_table = 'sel_table2'.

ENDIF.

x_header-texttab = lv_table.

SELECT * FROM (x_header-texttab) INTO TABLE wa_table

WHERE .......... IN ..........

Regards ,

Yogendra Bhaskar

Re: How i select from (conditional table)?

Former Member — Thu, 17 Jan 2013 10:14:14 GMT

Hi Dio,

The bracket is the right way to do this. Try with:

DATA   lv_table   TYPE string.

Cheers!

Re: How i select from (conditional table)?

former_member195270 — Thu, 17 Jan 2013 10:22:07 GMT

If you want to select from two table in single select then you have to do Inner Join.

Re: How i select from (conditional table)?

former_member996305 — Thu, 17 Jan 2013 10:38:57 GMT

Thanks to every one but nothing of this works on me.

I dont think that i can avoid two select.

Re: How i select from (conditional table)?

Sijin_Chandran — Thu, 17 Jan 2013 11:11:39 GMT

Hi Dio ,

What was the problem with your technique ?

This technique is dynamic selection.

You need to define according internal tables.

And write selection statements in conditions.

You need to write two select statements but only one ( depending on condition ) will be executed.