topic Re: internal table convert to a table in Application Development and Automation Discussions

internal table convert to a table

Former Member — Fri, 19 Oct 2007 09:33:57 GMT

Hi all

i declare an internal table. how to make it a table so that i can write it in sql?

Data: Begin of table1 occurs 20.

column1(30) type c.

end of table1.

<b>select column1 from table1 into corresponding field of table value_tab.</b>

thanks

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 09:36:19 GMT

Hi Gary,

I am not able to understand your intension, can you please write more clear.

Satish

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 09:38:39 GMT

U check my sql statement... can i tak the internal table as the sql table.

my internal table call table1.

my sql statement

<b>Select * from table1.</b>

Can i do that ?

Re: internal table convert to a table

gopi_narendra — Fri, 19 Oct 2007 09:40:45 GMT

Hi Gary, No you can not do that unless and untill table is a Dictionary table.

In your case based on the validations you can manipulate the data or move to an another internal table.

But what you are asking is not possible unless table1 is a dictionary table.

Regards

Gopi

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 09:41:46 GMT

why do u want to write sql statement on internal table.

On internal table u can use

1. READ statement.

2.Loop at itab etc

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 09:45:50 GMT

Hi Gary,

Whenever you want to retrieve the data from the Table that is present in the data dictionary (database), we use SQL statements.

For the internal tables that we declare in our programs, we can use

loop at itab into wa_itab.

endloop.

read table itab into wa_itab with key fld1 = ' '.

Reward If Useful,

Regards,

Chitra

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 10:27:38 GMT

hi Gary,

u need to write a code like

loop at itab into wa.

......

endloop.

to retrieve data from internal table

you can use SQL statements for the transparent tables that are stored in data dictionary.

regards,

sohi

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 10:34:38 GMT

YOU CAN'T USE SELECT....

USE READ STATEMENT....

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/41341147041806e10000000a1553f6/frameset.htm

Re: internal table convert to a table

Former Member — Fri, 19 Oct 2007 10:34:47 GMT

hi,

internal table is the user defined table inside the program...if we use select query.in that the fields which we use should be maintained in data dictionary..

Reward with points if helpful.

Re: internal table convert to a table

nikhil_bose — Wed, 24 Oct 2007 06:19:11 GMT

hi,

you can not do this since it is not a Dictionary table.

if you want to do the same

export the internal table using XML.

Re: internal table convert to a table

Former Member — Wed, 24 Oct 2007 06:55:40 GMT

Hi,

U can use SELECT Query only to Standard tables. Pls use

READ Statement to retrieve datas from internal table.

Use READ Statement like below...

READ TABLE table1 INTO value_tab WITH KEY column1 = table1-column

or use LOOP AT table1...

Reward me if it is helpful.

Thanks & Regards,

Ramya.