Load data from application server into internal dynamic table using the fields of a table.

[Former Member]

Hi,

I have a user maintained internal table, in which I have the OpenHub name, field and type(say T1).

Now I want to fetch data from application server based on the data in the internal table T1 and store it in a dynamic internal table T2.

So from the internal table T,1 I'll get all the fields for a particular user entered openhub.

I am not able to understand how to write code for fetching data from application server based on the data present in internal Table T1.

Can anyone please help me with this.

Thanks in advance.

[pokrakam]

I have no idea what openhub is, please can you clarify your question. Are you trying to dynamically specify which fields should be selected from a table, or trying to use dynamic conditions, or ...?

[Former Member]

Hi Mike,

Yes I am trying to dynamically specify the field from a table.

So for this I believe I have to create a dynamic structure.

[pokrakam · Accepted solution]

OK, for dynamic selection fields I can suggest two options:

1. Specify a table of field names as your select field list - a simple table of strings should work

select (field_table) from blah into table @data(my_result_table).

2. Create your result table dynamically beforehand and then do:

select * from blah into corresponding fields of table my_dynamic_table. 

[former_member182550 · Accepted solution]

Hi Mike,

I read the question as fetching data from an external database rather than an SAP table, so is this actually the correct answer ? If so, then perhaps the OP should learn to phrase his questions properly.

Rich

[pokrakam · Accepted solution]

Hi Richard,

Yes I found it confusing too, which is why I asked him to clarify. Perhaps you missed the question comments? Such a great feature of the new much easier and friendlier to use SCN, impossible to miss... (sarcasm alert).

[former_member182550 · Accepted solution]

<DUCKS as the sarcasm flies over my left shoulder>

[former_member182550]

Are you talking about Black Duck Open Hub (used to be Ohio ?)

Rich