topic Re: Select a table into string table in Application Development and Automation Discussions

Select a table into string table

manukapur — Tue, 14 Jan 2020 09:54:36 GMT

Hello Experts,

How do I select from database into a string table?

e.g. Select * from <tablename> into table <lt_string>.

Re: Select a table into string table

former_member1716 — Tue, 14 Jan 2020 11:50:40 GMT

manu.kapur,

You need first declare a structure with all the fields holding string Data types, then pass on the data fetched from the above query into the table which is declared based on the string data type structure defined.

By explaining more on your requirement we can help you better.

Regards!

Re: Select a table into string table

FredericGirod — Tue, 14 Jan 2020 12:17:52 GMT

I think you cannot proceed in one statement

Re: Select a table into string table

manukapur — Tue, 14 Jan 2020 12:24:01 GMT

I need to read multiple tables more than 20 and then download all the data as one text file. Tried reading them one and one and transferring them to a table with single string field but that doesn't work either.

Any pointers?

Re: Select a table into string table

FredericGirod — Tue, 14 Jan 2020 12:27:06 GMT

it is not the same request

Re: Select a table into string table

manukapur — Tue, 14 Jan 2020 12:28:24 GMT

@Frederic Girod,

Even I have to do in steps, what do you suggest? I have already tried reading and passing the tables in a string table, that gives me a type mismatch error.

Re: Select a table into string table

FredericGirod — Tue, 14 Jan 2020 12:32:51 GMT

(without test).

try somethink like that

select * from t001 into  @data(lt_t001).
select * from t001w into @data(lt_t001w).
select * fron t001k into @data(lt_t001k).

cl_demo_output=>write_data( lt_t001 ).
cl_demo_output=>write_data( lt_t001w ).
cl_demo_output=>write_data( lt_t001k ). 
data(lv_my_string) = cl_demo_output=>get( ).

Re: Select a table into string table

Sandra_Rossi — Tue, 14 Jan 2020 12:59:10 GMT

I guess you mean a string of characters. What if the table is made of columns of different data types like bytes, packed numbers, floating numbers, what character format do you expect for these types?