topic Re: building table dynamically in Application Development and Automation Discussions

topic Re: building table dynamically in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548679#M580059 <HTML><HEAD></HEAD><BODY><P>hi Felix , </P><P></P><P> Try the following blog:</P><P>/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap</P><P></P><P></P><P></P><P>Reward if helpful !</P><P>Regards,</P><P>Ranjita</P></BODY></HTML> Tue, 10 Jul 2007 09:09:16 GMT former_member196299 2007-07-10T09:09:16Z building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548676#M580056 <HTML><HEAD></HEAD><BODY><P>Hi folks!</P><P>Does anybody know whether it is possible to build an internal table from DDIC-structures dynamically?</P><P>I have a deep structured itab_upload(whose structure is defined in the DDIC), which contains 2 fields(Number Name) and a third field which contains itab_desc.</P><P>This itab_desc can contain either 2 fields(Number Name) and a third field which contains another itab_desc or 3 fields for numbers(without any other itab).If itab_desc contains another itab_desc, the second itab_desc contains only 3 fields for numbers and names...</P><P></P><P>help will be very appreciated and points will be rewarded!</P><P>Felix</P></BODY></HTML> Tue, 10 Jul 2007 09:01:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548676#M580056 Former Member 2007-07-10T09:01:29Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548677#M580057 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>check this link,</P><P></P><P></P><P><A href="https://forums.sdn.sap.com/click.jspa?searchID=3750707&messageID=3487864" target="test_blank">https://forums.sdn.sap.com/click.jspa?searchID=3750707&messageID=3487864</A></P><P></P><P></P><P></P><P>regards,</P><P>seshu.</P></BODY></HTML> Tue, 10 Jul 2007 09:06:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548677#M580057 Former Member 2007-07-10T09:06:09Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548678#M580058 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Look bellow sample program</P><P></P><P>report ytest.</P><P>data: lt_fieldcatalog type lvc_t_fcat.</P><P>data: ls_fieldcatalog type lvc_s_fcat.</P><P>field-symbols: <fs_data> type ref to data.</P><P>field-symbols: <fs_1>.</P><P>field-symbols: <fs_2> type any table.</P><P>field-symbols: <fs_3> type ypoll.</P><P> </P><P> </P><P>data: lt_data type ref to data.</P><P> </P><P>assign lt_data to <fs_data>.</P><P> </P><P>ls_fieldcatalog-fieldname = 'MANDT'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'POLLID'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'TEAM'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'INITIATOR'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'DESCRIPTION'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'APPROVED'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'INITIATED_DATE'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'END_DATE'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P>ls_fieldcatalog-fieldname = 'WINNER'.</P><P>ls_fieldcatalog-tabname = 'LT_TAB'.</P><P>append ls_fieldcatalog to lt_fieldcatalog.</P><P> </P><P> </P><P>call method cl_alv_table_create=>create_dynamic_table</P><P> exporting</P><P> it_fieldcatalog = lt_fieldcatalog</P><P> importing</P><P> ep_table = <fs_data></P><P> exceptions</P><P> generate_subpool_dir_full = 1</P><P> others = 2</P><P> .</P><P>if sy-subrc <> 0.</P><P>endif.</P><P> </P><P>assign <fs_data>->* to <fs_1>.</P><P>assign <fs_1> to <fs_2>.</P><P> </P><P>loop at <fs_2> assigning <fs_3>.</P><P> write: <fs_3>-pollid.</P><P>endloop.</P><P></P><P></P><P>Regards</P><P>Gaurav</P></BODY></HTML> Tue, 10 Jul 2007 09:09:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548678#M580058 Former Member 2007-07-10T09:09:01Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548679#M580059 <HTML><HEAD></HEAD><BODY><P>hi Felix , </P><P></P><P> Try the following blog:</P><P>/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap</P><P></P><P></P><P></P><P>Reward if helpful !</P><P>Regards,</P><P>Ranjita</P></BODY></HTML> Tue, 10 Jul 2007 09:09:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548679#M580059 former_member196299 2007-07-10T09:09:16Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548680#M580060 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> hi,</P><P>try this..</P><P></P><P>===================================== </P><P>REPORT zmaschl_create_data_dynamic . </P><P></P><P>TYPE-POOLS: slis. </P><P></P><P>DATA: it_fcat TYPE slis_t_fieldcat_alv, </P><P>is_fcat LIKE LINE OF it_fcat. </P><P>DATA: it_fieldcat TYPE lvc_t_fcat, </P><P>is_fieldcat LIKE LINE OF it_fieldcat. </P><P>DATA: new_table TYPE REF TO data. </P><P>DATA: new_line TYPE REF TO data. </P><P>FIELD-SYMBOLS: <l_table> TYPE ANY TABLE, </P><P><l_line> TYPE ANY, </P><P><l_field> TYPE ANY. </P><P></P><UL><LI level="1" type="ul"><P>Build fieldcat </P></LI></UL><P>CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' </P><P>EXPORTING </P><P>i_structure_name = 'SYST' </P><P>CHANGING </P><P>ct_fieldcat = it_fcat[]. </P><P>LOOP AT it_fcat INTO is_fcat WHERE NOT reptext_ddic IS initial. </P><P>MOVE-CORRESPONDING is_fcat TO is_fieldcat. </P><P>is_fieldcat-fieldname = is_fcat-fieldname. </P><P>is_fieldcat-ref_field = is_fcat-fieldname. </P><P>is_fieldcat-ref_table = is_fcat-ref_tabname. </P><P>APPEND is_fieldcat TO it_fieldcat. </P><P>ENDLOOP. </P><P></P><UL><LI level="1" type="ul"><P>Create a new Table </P></LI></UL><P>CALL METHOD cl_alv_table_create=>create_dynamic_table </P><P>EXPORTING </P><P>it_fieldcatalog = it_fieldcat </P><P>IMPORTING </P><P>ep_table = new_table. </P><P></P><UL><LI level="1" type="ul"><P>Create a new Line with the same structure of the table. </P></LI></UL><P>ASSIGN new_table->* TO <l_table>. </P><P>CREATE DATA new_line LIKE LINE OF <l_table>. </P><P>ASSIGN new_line->* TO <l_line>. </P><P></P><UL><LI level="1" type="ul"><P>Test it... </P></LI></UL><P>DO 30 TIMES. </P><P>ASSIGN COMPONENT 'SUBRC' OF STRUCTURE <l_line> TO <l_field>. </P><P><l_field> = sy-index. </P><P>INSERT <l_line> INTO TABLE <l_table>. </P><P>ENDDO. </P><P></P><P>LOOP AT <l_table> ASSIGNING <l_line>. </P><P>ASSIGN COMPONENT 'SUBRC' OF STRUCTURE <l_line> TO <l_field>. </P><P>WRITE <l_field>. </P><P>ENDLOOP. </P><P></P><P><b>Reward points</b></P><P></P><P>Regards</P></BODY></HTML> Tue, 10 Jul 2007 09:10:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548680#M580060 Former Member 2007-07-10T09:10:18Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548681#M580061 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the following link:</P><P><A href="http://www.sap-img.com/ab030.htm" target="test_blank">http://www.sap-img.com/ab030.htm</A></P><P></P><P>Regards,</P><P>Bhaskar</P></BODY></HTML> Tue, 10 Jul 2007 09:13:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548681#M580061 Former Member 2007-07-10T09:13:31Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548682#M580062 <HTML><HEAD></HEAD><BODY><P>Hi Felix,</P><P>try this short example:</P><P></P><P>PARAMETER: P_DBTAB LIKE DATABROWSE-TABLENAME DEFAULT 'MARA'.</P><P>*</P><P>DATA: GDO_DATA TYPE REF TO DATA.</P><P>FIELD-SYMBOLS: <GT_ITAB> TYPE TABLE.</P><P>*</P><P>CREATE DATA GDO_DATA TYPE TABLE OF (P_DBTAB).</P><P>ASSIGN GDO_DATA->* TO <GT_ITAB>.</P><P>*</P><P>SELECT * FROM (P_DBTAB) UP TO 100 ROWS INTO TABLE <GT_ITAB>.</P><P></P><P></P><P>Regards, Dieter</P></BODY></HTML> Tue, 10 Jul 2007 09:14:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548682#M580062 Former Member 2007-07-10T09:14:46Z Re: building table dynamically https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548683#M580063 <HTML><HEAD></HEAD><BODY><P>Found a way to work around this....</P></BODY></HTML> Wed, 11 Jul 2007 08:27:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/building-table-dynamically/m-p/2548683#M580063 Former Member 2007-07-11T08:27:09Z