Dynamic Report

Former Member — Fri, 08 Nov 2013 08:00:36 GMT

Hi,

I'm trying to create a report where I enter a table name as a text field then the program must look if this table exist and export the table data to csv. The csv part is easy, it's linking a text value to a table object that proves difficult. Any ideas?

Thanks,

Jan

Re: Dynamic Report

egenoves — Fri, 08 Nov 2013 08:19:52 GMT

Hi Jan,

You can use dynamic SQL statements to read the table

SELECT (table) into table <fs_table>.

Declare <fs_table> like a field symbol of type any table and map it to your CSV file .

Hope its useful,

Best Regards,

Re: Dynamic Report

Former Member — Fri, 08 Nov 2013 08:41:39 GMT

Hi,

Thanks I searched for abap dynamic sql select and got this. http://scn.sap.com/thread/1821253

This should work just fine.

Regards,

Jan

Re: Dynamic Report

Former Member — Fri, 08 Nov 2013 08:51:03 GMT

Hello,

Please find the logic below.

* We use some parameters to dynamically control the select, this is not very

* clever but this is just a test program !!

PARAMETER : p_tabnam TYPE tabname DEFAULT 'SFLIGHT'.

FIELD-SYMBOLS : <lt_outtab> TYPE ANY TABLE,

<ls_outtab> TYPE ANY,

<l_fld> TYPE ANY.

DATA:

lt_sel_list TYPE TABLE OF edpline,

l_having TYPE string,

l_wa_name TYPE string,

dref TYPE REF TO data,

itab_type TYPE REF TO cl_abap_tabledescr,

struct_type TYPE REF TO cl_abap_structdescr,

elem_type TYPE REF TO cl_abap_elemdescr,

comp_tab TYPE cl_abap_structdescr=>component_table,

comp_fld TYPE cl_abap_structdescr=>component.

TYPES: f_count TYPE i.

* Creation of the output table including a non standard field, f_count

* see ABAP FAQ #14 for more information on this topic

struct_type ?= cl_abap_typedescr=>describe_by_name( p_tabnam ).

elem_type ?= cl_abap_elemdescr=>describe_by_name( 'F_COUNT' ).

comp_tab = struct_type->get_components( ).

comp_fld-name = 'F_COUNT'.

comp_fld-type = elem_type.

APPEND comp_fld TO comp_tab.

struct_type = cl_abap_structdescr=>create( comp_tab ).

itab_type = cl_abap_tabledescr=>create( struct_type ).

l_wa_name = 'l_WA'.

CREATE DATA dref TYPE HANDLE itab_type.

ASSIGN dref->* TO <lt_outtab>.

CREATE DATA dref TYPE HANDLE struct_type.

ASSIGN dref->* TO <ls_outtab>.

* Creation of the selection fields and the "group by" clause

APPEND 'COUNT(*) AS F_COUNT' TO lt_sel_list.

* Creation of the "having" clause

l_having = 'count(*) >= 1'.

* THE dynamic select

SELECT *

FROM (p_tabnam)

INTO CORRESPONDING FIELDS OF TABLE <lt_outtab>.

* display of the results

LOOP AT <lt_outtab> ASSIGNING <ls_outtab>.

LOOP AT comp_tab INTO comp_fld.

ASSIGN COMPONENT comp_fld-name OF STRUCTURE <ls_outtab> TO <l_fld>.

WRITE: <l_fld>.

ENDLOOP.

SKIP.

ENDLOOP.

Re: Dynamic Report

Former Member — Fri, 08 Nov 2013 09:05:01 GMT

This message was moderated.

topic Re: Dynamic Report in Application Development and Automation Discussions

Dynamic Report

Re: Dynamic Report

Re: Dynamic Report

Re: Dynamic Report

Re: Dynamic Report