topic Re: How to pass variable value as a table name in select statement??? in Application Development and Automation Discussions

How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:26:16 GMT

How to pass variable value as a table name in select statement???

Re: How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:28:47 GMT

You can use like this

SELECT * FROM (V_TABLE_NAME) INTO I_TABLE.

Regards

Kathirvel

Re: How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:29:09 GMT

PARAMENTER: P_TAB(30).

DATA: WA(1000).

SELECT * FROM (P_TAB) INTO WA.

ENDSELECT.

Now I'm not using 4.7, so I'm not sure if the stataments are right, but u can create a table:

DATA: MY_TABLE TYPE REF TO DATA.

FIELD-SYMBOLS: <MY_TABLE> TYPE TABLE.

FIELD-SYMBOLS: <MY_WA> TYPE ANY.

CREATE MY_TABLE TYPE TABLE OF (P_TAB).

ASSIGN MY_TABLE->* TO <MY_TABLE>.

SELECT * FROM (P_TAB) INTO TABLE <MY_TABLE>.

LOOP AT <MY_TABLE> ASSIGNING <MY_WA>.

ENDLOOP.

Max

Re: How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:30:17 GMT

variable is V1 which have table name...

select * from (V1) into itab...

Re: How to pass variable value as a table name in select statement???

Sandeep_Panghal — Fri, 24 Nov 2006 09:31:02 GMT

Hi,

Try this :

SELECT * FROM P_VAR INTO WORKAREA.

Rgds,

sands

Re: How to pass variable value as a table name in select statement???

anversha_s — Fri, 24 Nov 2006 09:31:42 GMT

hi,

select * from (v_table_name) into table.

rgds

anver

Re: How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:31:52 GMT

just like this.

DATA: zauth LIKE dd02l-tabname.


zauth = 'ZTABAUTH'.  "pass the table name 

     select single statu
      into sl_update
      from (zauth)
      where tabname = tabname
      and bname   = sy-uname.

regards,

VIjay

SAMPLE CODE ..

data: val like dd02l-tabname.

DATA : V_WERKS(4) TYPE C.

val = 'MARC'.

select single WERKS

into V_WERKS

from (VAL)

where MATNR = '000000000090004563' .

CHECK SY-SUBRC EQ 0.

WRITE:/ V_WERKS.

Message was edited by:

vijay k

Re: How to pass variable value as a table name in select statement???

Former Member — Fri, 24 Nov 2006 09:32:43 GMT

Hullo,

use the '(' and ')' to pass your variable:

Like:

SELECT * FROM (table_name).

Hope this helps.