topic Re: Edit mask for table name in Application Development and Automation Discussions

Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:12:34 GMT

Hi,

I have value '666'. There exists a table with name KOTG666 in the system.

Now, I should write a SELECT statement which should mean as follows:---

SELECT * FROM KOTG666 .

But, I can't write KOTG666 directly, bcos next time I may have value '999' and I have to retrieve data from KOTG999.

How can i do that? Is it possible with Edit-mask??

Thanks,

Shivaa......

Re: Edit mask for table name

kiran_k8 — Mon, 16 Feb 2009 09:18:48 GMT

Shiva,

May be we have to use Dynamic Select Query.Check the related threads in SDN

K.Kiran.

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:19:58 GMT

you can go like this

ITS A WORKING CODE

data: w_char type string value 'KOTG'.

parameters: p_char(10) .

concatenate w_char '-' p_char.

condense w_char no-gaps.

if <cond>

select fields

from (w_char)

into corresponding fields of table t_table.

else.

select fields

from (w_char)

into corresponding fields of table t_table.

endif.

regards

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:20:21 GMT

Try this way..

DATA tabname(10).

DATA: BEGIN OF wa,

id TYPE scustom-id,

name TYPE scustom-name,

END OF wa.

tabname = 'SCUSTOM'.

SELECT id name INTO CORRESPONDING FIELDS OF wa FROM (tabname).

WRITE: / wa-id, wa-name.

ENDSELECT

Re: Edit mask for table name

former_member222860 — Mon, 16 Feb 2009 09:20:59 GMT

Hi,

Like this,

DATA: V_STR TYPE STRING VALUE 'KOTG'.
DATA: V_STR1 TYPE STRING.

PARAMETER: VAL(10) TYPE C.    " ur input 999

CONCATENATE V_STR VAL INTO V_STR1.
CONDENSE V_STR.

SELECT * FROM (V_STR1).

Re: Edit mask for table name

viquar_iqbal — Mon, 16 Feb 2009 09:21:11 GMT

check this thread

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:22:29 GMT

Hi,

You can pass the table name through a variable.

select * from (table_name).

table_name is a variable containing the table name.

Regards,

Naga Sai Swapna

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:23:29 GMT

HI Shiva,

Just try following.

data: tab_name(10) type c.

concatenate 'KOTG' value into tab_name.

*value will be 666 or 999

select * from tab_name

you also have to put dynamic where condition for this sql query.

press f1 on select you will be getting all help for dynamic where sql query.

Regards,

Pratik Vora

Edited by: Pratik Vora on Feb 16, 2009 2:53 PM

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:26:49 GMT

Hi Shiva, chk this...

data: str1 type string value 'KOTG',

str2 type string value '666'.

concatenate str1 str2 into str1 no-gaps.

select * from (str1) into.......

as the value 666 changes u can assign the new value to str2 before concatenating....

Regards,

Mdi.Deeba

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 09:35:18 GMT

Hi Shiva ,

I think you have to make use of dynamic open sql statement,

Kindly go through this link below:

http://www.susanto.id.au/papers/DynOpenSQL.asp

Hope it helps

Regrds

Mansi

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 10:41:56 GMT

Hi all, very thanks for ur answers......

But, I got struck up again.....

SELECT * FROM (TABNAME) INTO ????

Where can I store the values of the table (TABNAME) into?

I dont know the structure of the table beforehand, so I cant create a internal table.

I tried creating internal table as follows:--

data: it_t1 type table of <tabname>,

wa_t1 like line of it_t1.

But, its not accepting.

How can I store the values of table (TABNAME)??

Re: Edit mask for table name

former_member222860 — Mon, 16 Feb 2009 11:00:42 GMT

Hey,

For this u've to create dynamic itab.

Search with the keyword Create Dynamic Internal Table

thanks\

Mahesh

Re: Edit mask for table name

Former Member — Mon, 16 Feb 2009 11:01:44 GMT

Hi shiva,

Kindly try following.

field-symbols : <tabname> type any table.

Assign tabname to <tabname>

select * from (tabname) into <tabname>....

Kindly check if it works or not.

You can find help for dynamic table creation in below link.

http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3860358411d1829f0000e829fbfe/frameset.htm

Regards,

Pratik Vora