topic To select data from database table detrmined dynamically. in Application Development and Automation Discussions

To select data from database table detrmined dynamically.

Former Member — Thu, 14 May 2009 11:57:15 GMT

Hi Experts ,

Need to get data from database tables that is determined dynamically .

I have the database table name stored in a string while execution.

How to can this be passed in the select query in order to get the contents of the table?

Regards.

Re: To select data from database table detrmined dynamically.

Former Member — Thu, 14 May 2009 11:59:55 GMT

HI,

REPORT demo_select_dynamic_database . 

DATA wa TYPE scarr. 
DATA name(10) TYPE c VALUE 'SCARR'.

SELECT * 
INTO wa 
FROM (name) CLIENT SPECIFIED 
WHERE mandt = '000'. 
WRITE: / wa-carrid, wa-carrname. 
ENDSELECT.

Thanks

Sudheer

Re: To select data from database table detrmined dynamically.

Former Member — Thu, 14 May 2009 12:15:32 GMT

Hi Sunitha,

check this out:


    SELECT  (l_t_selflds) FROM       (p_g_ztab_name)
                          INTO TABLE <g_t_table>
                          WHERE      (l_t_whereflds).

Here (p_g_ztab_name) is the name of the variable that contains the value of table. You can code accordingly.

Regards

Shital