topic Re: get table dynamic in Application Development and Automation Discussions

get table dynamic

Former Member — Mon, 22 Oct 2007 11:42:51 GMT

Hi all,

i have to wrote a generator for a Pattern here. But i got a small problem.

I have to got a table and the big problem is i don't know whick TYPE i got

the code looks like this


SELECT *
FROM (im_table)
INTO TABLE ????.

But how to define the ????. I allready tried


DATA test TYPE ANY TABLE.

and


DATA test TYPE TABLE.
FIELD-SYMBOLS <table> TYPE ANY.

ASSIGN test TO <table>
.....
INTO TABLE <table>.

But no luck this time. Maybe some of you get a hint for me.

greetings

P.S Sorry for my bad english.

Re: get table dynamic

rainer_hbenthal — Mon, 22 Oct 2007 11:44:25 GMT

Where do you put this dynamic select? Method? Function module?

Re: get table dynamic

Former Member — Mon, 22 Oct 2007 11:46:45 GMT

This is a method.

The (im_table) is a Parameter from the Type CHAR where the table is set.

greetings

Re: get table dynamic

uwe_schieferstein — Mon, 22 Oct 2007 11:53:03 GMT

Hello Moritz

Add the following lines of coding:

DATA:
  lo_data     TYPE REF TO data.

FIELD-SYMBOLS:
  <lt_itab>          TYPE table,
  <ls_record>      TYPE any.


  CREATE DATA lo_data TYPE (im_table).
  ASSIGN lo_data->* TO <lt_itab>.

SELECT *
FROM (im_table)
INTO TABLE <lt_itab>.

  LOOP AT <lt_itab> ASSIGNING <ls_record>.

  ENDLOOP.

Regards

Uwe

Re: get table dynamic

rainer_hbenthal — Mon, 22 Oct 2007 11:55:20 GMT

Try this:



DATA:
  ptr_it_table type any table.

field-symbols:
  <fstable> type any table.

create data ptr_it_table type table of (im_table).
assign ptr_it_table ->* to <fstable>.

select *
from (im_table)
into table <fstable>.

this should work.

Re: get table dynamic

Former Member — Mon, 22 Oct 2007 12:01:36 GMT

The Answere before work. Your last answer didnt work ... I Got a error message like this:


You cannot use generic types for fields. The table Types ANY and INDEX are generic.

But thanks a lot ...

greetings

Re: get table dynamic

uwe_schieferstein — Mon, 22 Oct 2007 12:04:15 GMT

Hello Moritz

Perhaps it is possible to add the following option to the DATA definition:

DATA:
  ptr_it_table type any table
                   WITH DEFAULT KEY.

Regards

Uwe

Re: get table dynamic

Former Member — Mon, 22 Oct 2007 12:06:30 GMT

Thanks a lot it works now

Now i can work on thank you thousand times

greetings

Re: get table dynamic

rainer_hbenthal — Mon, 22 Oct 2007 12:09:13 GMT

Sorry, it must be like this:

instead:

DATA:

ptr_it_table type any table.

it must be

DATA:

ptr_it_table type ref to data