variable table in SQL select

[Former Member]

Hello,

In various SQL versions it is possible to define a variable that will hold the name of the table and then use that variable in the FROM clause instead the actual table name.

something like this:

var_table(4) type c.

var_table = 'tab1'

select * from &var_table&... etc

var_table = 'tab2'

select * from &var_table&... etc

It is possible something like this in ABAP SQL?

Thank you.

[Former Member]

yes, search using Dynamic Select, and you will find 1000s of threads

[Former Member]

...or just press F1 on SELECT FROM.

Rob

[Former Member]

Check this :

https://www.sdn.sap.com/irj/scn/advancedsearch?query=dynamicSelect&cat=sdn_all

Regards

Neha

[Former Member]

Hi,

yes, you can use the dynamic table for the SQL selection.

SELECT * FROM (tablename) INTO CORRESPONDING FIELDS OF TABLE <tab>.

Regards,

Chris Gu

[Former Member]

Hi,

Check the foll code:

PARAMETERS: P_TABLE LIKE DD03L-TABNAME.

DATA: XTABLE TYPE REF TO DATA.
FIELD-SYMBOLS: <FS_TABLE>  TYPE TABLE,
               <WA_TABLE> TYPE ANY.


CREATE DATA XTABLE type TABLE OF (p_table).
assign xtable->* to <fs_table>.

SELECT * FROM (P_TABLE) INTO TABLE <fs_table> ORDER BY PRIMARY KEY.

loop at <fs_table> ASSIGNING <wa_table>.
ENDLOOP.

Thanks & Regards,

Navneeth K.