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

[Former Member]

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

[Former Member]

You can use like this

SELECT * FROM (V_TABLE_NAME) INTO I_TABLE.

Regards

Kathirvel

[Former Member]

You can use like this

SELECT * FROM (V_TABLE_NAME) INTO I_TABLE.

Regards

Kathirvel

[Former Member]

Hi

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

[Former Member]

variable is V1 which have table name...

select * from (V1) into itab...

[Sandeep_Panghal]

Hi,

Try this :

SELECT * FROM P_VAR INTO WORKAREA.

Rgds,

sands

[anversha_s]

hi,

select * from (v_table_name) into table.

rgds

anver

[Former Member]

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

[Former Member]

Hullo,

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

Like:

SELECT * FROM (table_name).

Hope this helps.