topic Re: variable table in SQL select in Application Development and Automation Discussions

variable table in SQL select

Former Member — Wed, 19 Nov 2008 17:31:32 GMT

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.

Re: variable table in SQL select

Former Member — Wed, 19 Nov 2008 17:54:25 GMT

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

Re: variable table in SQL select

Former Member — Wed, 19 Nov 2008 19:17:30 GMT

...or just press F1 on SELECT FROM.

Rob

Re: variable table in SQL select

Former Member — Wed, 19 Nov 2008 20:11:06 GMT

Check this :

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

Regards

Neha

Re: variable table in SQL select

Former Member — Thu, 20 Nov 2008 03:12:52 GMT

Hi,

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

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

Regards,

Chris Gu

Re: variable table in SQL select

Former Member — Thu, 20 Nov 2008 04:14:04 GMT

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.