Dynamic table usage

[Former Member]

Hi ,

I am using two seperate fields to get the name of the table, on which I have to write a select statement.

For Eg: Lv_field1 has value " A " and lv_field2 has " 000 " , I need to concatenate these two to get A000.

This table is an existing one, its just that the tables name are getting defined in the program.(during run time)

On this table , i need to use the "select" statement .

pls suggest the possible methods to do it.

Regards,

kalyan garimella

[rvinod1982]

Hi,

You can do it by using field symobls.

DATA : lv_field1 TYPE c LENGTH 255,
       lv_field2 TYPE c LENGTH 255,
       lv_table_name TYPE c LENGTH 255,
       lref_data_table TYPE REF TO data,
       lref_data_wa TYPE REF TO data.

FIELD-SYMBOLS : <fs_table_data> TYPE ANY TABLE,
                <fs_wa> TYPE ANY.

CONCATENATE lv_field1 lv_field2 INTO lv_table_name.

CREATE DATA lref_data_table TYPE STANDARD TABLE OF (lv_table_name).
ASSIGN lref_data_table->* TO <fs_table_data>.

CREATE DATA lref_data_wa TYPE (lv_table_name).
ASSIGN lref_data_wa->* TO <fs_wa>.

SELECT * FROM (lv_table_name) INTO TABLE <fs_table_data>.

[Former Member]

JUST TRY BELOW FORMAT

Var1 = 'v'. VAR2 = 'BAK'.

CONCATENATE VAR1 VAR2 INTO TABLENAME.

NOW TABLENAME = 'VBAK'.

WHERE_CLAUSE = 'VBELN = '200003000').

SELECT * FROM (TABLENAME) WHERE (WHERE_CLAUSE).