topic Re: Question on dynamic internal table in Application Development and Automation Discussions

Question on dynamic internal table

PankajVPatil — Mon, 11 Oct 2010 04:06:56 GMT

Hi,

I have to utilise the function module (FM) 'RSDRI_INFOPROV_READ'. The kind of structure for which the data to be fetched from infoprovider is generated dynamically.

In the FM lets assume,

Import parameters are;

g_th_sfc - Characteristics That Are to Be Returned

g_th_sfk - Key Figures That Are to Be Returned

g_t_range - Selection Conditions Connected with AND

and in export parameters;

g_t_data - Internal Table with Query Result

Now i can build/assign the rows to the import parameters dynamically through a look up on certain transparent table, but g_t_data needs to have a predefined structure declared.

I know, to do above, the concept of dynamic internal table exists, but I am not familiar with coding/syntax conventions.

Please help.

Regards,

Pankaj

Re: Question on dynamic internal table

Former Member — Mon, 11 Oct 2010 07:07:20 GMT

Hi Pankay.

I've found a code sample, maybe it will help you:

DATA:       w_structref         TYPE REF TO cl_abap_structdescr,
      it_comptab          TYPE abap_compdescr_tab,
      w_comptab           TYPE abap_compdescr.

...

ASSIGN (g_t_data) TO <fs_line>.
  w_structref ?= cl_abap_structdescr=>describe_by_data( <fs_line> ).
  it_comptab = w_structref->components.

Regards,

Klaus

Re: Question on dynamic internal table

MarcinPciak — Mon, 11 Oct 2010 07:17:07 GMT

Your exporting parameter simply should be either of type ANY TABLE (so you can assign any TABLE back to it) or should be any data reference ( type REF TO DATA ). Please refer for the second approach.

Regards

Marcin

Also you migh be interested with RTTS approach as an alternative to two above. /people/marcin.pciak/blog/2010/09/09/do-you-really-know-everything-about-typing--part-2

Edited by: Marcin Pciak on Oct 11, 2010 9:17 AM

Re: Question on dynamic internal table

PankajVPatil — Mon, 11 Oct 2010 13:10:45 GMT

Hello,

I have created a certain field catalog with dynamic internal table. Following is the code snippet:


  CALL METHOD cl_alv_table_create=>create_dynamic_table
    EXPORTING
      it_fieldcatalog = it_fieldcat
    IMPORTING
      ep_table        = new_table.

  ASSIGN new_table->* TO <l_table>.

Now I want to populate the <l_table> through function module RSDRI_INFOPROV_READ.

How do I do it?

Regards,

Pankaj

Re: Question on dynamic internal table

MarcinPciak — Mon, 11 Oct 2010 13:18:08 GMT

Where is the problem then? You can pass <l_table> to parameter E_T_DATA which expects any standard table (without particular structure).

Regards

Marcin

Re: Question on dynamic internal table

PankajVPatil — Mon, 11 Oct 2010 13:22:01 GMT

Yes I did the same thing. Please see below the code.


 CALL FUNCTION 'RSDRI_INFOPROV_READ'
      EXPORTING
        i_infoprov             = l_infoprov
        i_th_sfc               = g_th_sfc
        i_th_sfk               = g_th_sfk
        i_t_range              = g_t_range
        i_reference_date       = sy-datum
        i_packagesize          = 1000
      IMPORTING
        e_t_data               = <l_table>
        e_end_of_data          = g_end_of_data
      CHANGING
        c_first_call           = g_first_call
      EXCEPTIONS
        illegal_input          = 1
        illegal_input_sfc      = 2
        illegal_input_sfk      = 3
        illegal_input_range    = 4
        illegal_input_tablesel = 5
        no_authorization       = 6
        illegal_download       = 8
        illegal_tablename      = 9
        OTHERS                 = 11.

though i have the data in infoprovider i do not get data in <l_table>.

Re: Question on dynamic internal table

MarcinPciak — Mon, 11 Oct 2010 13:26:11 GMT

So this might be a data issue not an ABAP one. To ensure please go to se37 and test this FM giving same values for input parameters. You shall see then if the result is as expected or not.

Regards

Marcin

Re: Question on dynamic internal table

PankajVPatil — Mon, 11 Oct 2010 14:22:59 GMT

When I try doing it through SE37, i get the information pop up of "Error generating the test frame".

Also when I debug all the input parameters they are restricted to correct values, but the sy-subrc for the function module is set to 11.

Regards,

Pankaj

Re: Question on dynamic internal table

PankajVPatil — Tue, 12 Oct 2010 07:43:58 GMT

Hi Marcin,

I have some records in the infoprovider that follow data from g_t_range restrictions. But the data some how disappears from table <l_table>.

Any suggestion?

Regards,

Pankaj

Re: Question on dynamic internal table

PankajVPatil — Tue, 12 Oct 2010 15:50:22 GMT

I gave description instead of technical name in the ALIAS component of g_th_sfc internal table.

It is working correctly.

Thanks for the time.

Regards,

Pankaj