topic Re: reg internal tables in Application Development and Automation Discussions

topic Re: reg internal tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677613#M885686 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P><STRONG>Internal Table</STRONG> </P><P></P><P> An internal table is a temporary table stored in RAM on the application server. It is created and filled by a program during execution and is discarded when the program ends. Like a database table, an internal table consists of one or more rows with an identical structure, but unlike a database table, it cannot hold data after the program ends. Use it as temporary storage for manipulating data or as a temporary private buffer.</P><P></P><P></P><P></P><P><STRONG>Definition of an Internal Table</STRONG></P><P>An internal table consists of a body and an optional header line . </P><P></P><P>The body holds the rows of the internal table. All rows within it have the same structure. The term "internal table" itself usually refers to the body of the internal table. </P><P></P><P>The header line is a field string with the same structure as a row of the body, but it can only hold a single row. It is a buffer used to hold each record before it is added or each record as it is retrieved from the internal table.</P><P></P><P>To define an internal table body, use occurs n on the definition of any field string except tables. occurs creates the body of the internal table. The memory for the body is not allocated until the first row is added to it. Without occurs, you only have a field string. </P><P></P><P>To define an internal table with a header line, you must include either begin of or with header line in the definition. A header line is automatically created if begin of appears in the definition. If you use like instead of begin of, the internal table will not have a header line unless you add with header line after the occurs clause. This is illustrated in lines 2 through 10 of Listing 11.1. </P><P></P><P>The only time you would create an internal table without a header line is in the case of a nested internal table. A nested internal table cannot have a header line. </P><P></P><P></P><P> Listing 11.1 Basic Ways of Defining Internal Tables with and Without a Header Line</P><P></P><P></P><P> 1 report ztx1101.</P><P> 2 data: begin of it1 occurs 10, "has a header line</P><P> 3 f1,</P><P> 4 f2,</P><P> 5 f3,</P><P> 6 end of it1.</P><P> 7</P><P> 8 data it2 like ztxlfa1 occurs 100. "doesn't have a header line</P><P> 9</P><P>10 data it3 like ztxlfa1 occurs 100 with header line. "it does now</P><P></P><P><STRONG>Reward if useful</STRONG></P><P></P><P>Regards ,</P><P></P><P> Shankar GJ</P><P></P><P>Edited by: Shankar GJ on Apr 11, 2008 7:16 AM</P></BODY></HTML> Fri, 11 Apr 2008 05:16:06 GMT Former Member 2008-04-11T05:16:06Z reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677608#M885681 <HTML><HEAD></HEAD><BODY><P>i want to know the concept of dynamic internal tables.</P><P>please explain me step by step in detail with good example.</P><P>help ful me alot.</P></BODY></HTML> Fri, 11 Apr 2008 05:03:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677608#M885681 Former Member 2008-04-11T05:03:02Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677609#M885682 <HTML><HEAD></HEAD><BODY><P>Dynamic internal table is an extension to internal table concept, used when the number of fields is not known at the design time or until the compile time.</P><P></P><P>Check this Web blog of Dynamic Internal Table</P><P>/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap</P><P><A href="http://www.saptechnical.com/Tutorials/ABAP/DynamicInternaltable/DynamicInternalTable.htm" target="test_blank">http://www.saptechnical.com/Tutorials/ABAP/DynamicInternaltable/DynamicInternalTable.htm</A></P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/dynamic" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/dynamic</A><EM>Internal</EM>Table&</P><P>Regards,</P><P>Santosh</P></BODY></HTML> Fri, 11 Apr 2008 05:06:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677609#M885682 Former Member 2008-04-11T05:06:30Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677610#M885683 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> </P><P> For explanation check the blog</P><P></P><P>Check the link</P><P>[http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm]</P><P></P><P>Also check the blog</P><P>[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2071] <B>[original link is broken]</B> <B>[original link is broken]</B> <B>[original link is broken]</B>;</P><P></P><P>and ex:</P><P></P><P>report z_dynamic.</P><P></P><P>type-pools : abap.</P><P></P><P>field-symbols: <dyn_table> type standard table,</P><P><dyn_wa>,</P><P><dyn_field>.</P><P></P><P>data: dy_table type ref to data,</P><P>dy_line type ref to data,</P><P>xfc type lvc_s_fcat,</P><P>ifc type lvc_t_fcat.</P><P></P><P>selection-screen begin of block b1 with frame.</P><P>parameters: p_table(30) type c default 'T001'.</P><P>selection-screen end of block b1.</P><P></P><P>start-of-selection.</P><P></P><P>perform get_structure.</P><P>perform create_dynamic_itab.</P><P>perform get_data.</P><P>perform write_out.</P><P></P><P></P><P>form create_dynamic_itab.</P><P></P><P></P><P></P><P>Create dynamic internal table and assign to FS </P><P>call method cl_alv_table_create=>create_dynamic_table</P><P>exporting</P><P>it_fieldcatalog = ifc</P><P>importing</P><P>ep_table = dy_table.</P><P></P><P>assign dy_table->* to <dyn_table>.</P><P></P><P></P><P>Create dynamic work area and assign to FS </P><P>create data dy_line like line of <dyn_table>.</P><P>assign dy_line->* to <dyn_wa>.</P><P></P><P>endform.</P><P></P><P></P><P>Pls. reward if useful....</P></BODY></HTML> Fri, 11 Apr 2008 05:10:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677610#M885683 Former Member 2008-04-11T05:10:20Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677611#M885684 <HTML><HEAD></HEAD><BODY><P>Dynamic internal tables are the internal tables created at run time not like the normal tables which are created before you start data extraction..</P><P></P><P>Dynamic internal tables can be created using CL_ALV_TABLE_CREATE class and method CREATE_DYNAMIC_TABLE.</P><P>Just fill the field catalog(IT_FIELDCATALOG) in the parameter of method (like you do in normal ALV reports) and it creates a pointer to dynamic data table.</P><P></P><P>Check this code.</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>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><STRONG>one more example</STRONG></P><P></P><P>. </P><P> </P><P> type-pools : abap. </P><P> field-symbols: <dyn_table> type standard table, </P><P> <dyn_wa>, </P><P> <dyn_field>. </P><P> data: dy_table type ref to data, </P><P> dy_line type ref to data, </P><P> xfc type lvc_s_fcat, </P><P> ifc type lvc_t_fcat. </P><P> selection-screen begin of block b1 with frame. </P><P>parameters: p_table(30) type c default 'T001'. </P><P>selection-screen end of block b1. </P><P> start-of-selection. </P><P> perform get_structure. </P><P> perform create_dynamic_itab. *********<STRONG>Creates a dyanamic internal table</STRONG>********* </P><P> perform get_data. </P><P> perform write_out. </P><P> form get_structure. </P><P> data : idetails type abap_compdescr_tab, </P><P> xdetails type abap_compdescr. </P><P> data : ref_table_des type ref to cl_abap_structdescr. </P><P> </P><UL><LI level="1" type="ul"><P>Get the structure of the table. </P></LI></UL><P> ref_table_des ?= </P><P> cl_abap_typedescr=>describe_by_name( p_table ). </P><P> idetails[] = ref_table_des->components[]. </P><P> loop at idetails into xdetails. </P><P> clear xfc. </P><P> xfc-fieldname = xdetails-name . </P><P> xfc-datatype = xdetails-type_kind. </P><P> xfc-inttype = xdetails-type_kind. </P><P> xfc-intlen = xdetails-length. </P><P> xfc-decimals = xdetails-decimals. </P><P> append xfc to ifc. </P><P> endloop. </P><P> endform. </P><P> form create_dynamic_itab. </P><P> </P><UL><LI level="1" type="ul"><P>Create dynamic internal table and assign to FS </P></LI></UL><P> call method cl_alv_table_create=>create_dynamic_table </P><P> exporting </P><P> it_fieldcatalog = ifc </P><P> importing </P><P> ep_table = dy_table. </P><P> assign dy_table->* to <dyn_table>. </P><P> </P><UL><LI level="1" type="ul"><P>Create dynamic work area and assign to FS </P></LI></UL><P> create data dy_line like line of <dyn_table>. </P><P> assign dy_line->* to <dyn_wa>. </P><P> endform. </P><P> </P><P> form get_data. </P><P> </P><UL><LI level="1" type="ul"><P>Select Data from table. </P></LI></UL><P> select * into table <dyn_table> </P><P> from (p_table). </P><P> endform. </P><P> Write out data from table. </P><P> loop at <dyn_table> into <dyn_wa>. </P><P> do. </P><P> assign component sy-index </P><P> of structure <dyn_wa> to <dyn_field>. </P><P> if sy-subrc <> 0. </P><P> exit. </P><P> endif. </P><P> if sy-index = 1. </P><P> write:/ <dyn_field>. </P><P> else. </P><P> write: <dyn_field>. </P><P> endif. </P><P> enddo. </P><P> endloop. </P><P></P><P></P><P></P><P>-</P><HR originaltext="-------------------------------------------------------------------------------" /><P></P><P>REPORT ZCLUST1 . </P><UL><LI level="1" type="ul"></LI><LI level="1" type="ul"><P>Example: how to create a dynamic internal table </P></LI><LI level="1" type="ul"><P> </P></LI><LI level="1" type="ul"><P>The dynamic internal table stucture </P></LI></UL><P>DATA: BEGIN OF STRUCT OCCURS 10, </P><P> FILDNAME(8) TYPE C, </P><P> ABPTYPE TYPE C, </P><P> LENGTH TYPE I, </P><P>END OF STRUCT. </P><P></P><UL><LI level="1" type="ul"><P>The dynamic program source table </P></LI></UL><P>DATA: BEGIN OF INCTABL OCCURS 10, </P><P> LINE(72), </P><P>END OF INCTABL. </P><P></P><P>DATA: LNG TYPE I, TYPESRTING(6). </P><P></P><UL><LI level="1" type="ul"><P>Sample dynamic internal table stucture </P></LI></UL><P>STRUCT-FILDNAME = 'field1'. STRUCT-ABPTYPE = 'c'. STRUCT-LENGTH = '6'. </P><P>APPEND STRUCT. CLEAR STRUCT. </P><P></P><P>STRUCT-FILDNAME = 'field2'. STRUCT-ABPTYPE = 'd'. </P><P>APPEND STRUCT. CLEAR STRUCT. </P><P></P><P>STRUCT-FILDNAME = 'field3'. STRUCT-ABPTYPE = 'i'. </P><P>APPEND STRUCT. CLEAR STRUCT. </P><P></P><UL><LI level="1" type="ul"><P>Create the dynamic internal table definition in the dyn. program </P></LI></UL><P>INCTABL-LINE = 'program zdynpro.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'data: begin of dyntab occurs 10,'. APPEND INCTABL. </P><P></P><P>LOOP AT STRUCT. </P><P> INCTABL-LINE = STRUCT-FILDNAME. </P><P> LNG = STRLEN( STRUCT-FILDNAME ). </P><P></P><P> IF NOT STRUCT-LENGTH IS INITIAL . </P><P> TYPESRTING(1) = '('. </P><P> TYPESRTING+1 = STRUCT-LENGTH. </P><P> TYPESRTING+5 = ')'. </P><P> CONDENSE TYPESRTING NO-GAPS. </P><P> INCTABL-LINE+LNG = TYPESRTING. </P><P> ENDIF. </P><P></P><P> INCTABL-LINE+15 = 'type '. </P><P> INCTABL-LINE+21 = STRUCT-ABPTYPE. </P><P> INCTABL-LINE+22 = ','. </P><P> APPEND INCTABL. </P><P>ENDLOOP. </P><P>INCTABL-LINE = 'end of dyntab. '. </P><P>APPEND INCTABL. </P><P></P><UL><LI level="1" type="ul"><P>Create the code processes the dynamic internal table </P></LI></UL><P>INCTABL-LINE = ' '. APPEND INCTABL. </P><P>INCTABL-LINE = 'dyntab-field1 = ''aaaaaa''.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'dyntab-field1 = ''19970814''.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'dyntab-field1 = 1.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'append dyntab.'. APPEND INCTABL. </P><P>INCTABL-LINE = ' '. APPEND INCTABL. </P><P>INCTABL-LINE = 'loop at dyntab.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'write: / dyntab.'. APPEND INCTABL. </P><P>INCTABL-LINE = 'endloop.'. APPEND INCTABL. </P><P></P><UL><LI level="1" type="ul"><P>Create and run the dynamic program </P></LI></UL><P>INSERT REPORT 'zdynpro'(001) FROM INCTABL. </P><P>SUBMIT ZDYNPRO. </P><P></P><P></P><P></P><P>-</P><HR originaltext="-------------------------------------------------------------------------------" /><P></P><P>or Just try out this simpler dynamic internal tables </P><P></P><P>DATA: itab TYPE STANDARD TABLE OF spfli, </P><P> wa LIKE LINE OF itab. </P><P></P><P>DATA: line(72) TYPE c, </P><P> list LIKE TABLE OF line(72). </P><P></P><P>START-OF-SELECTION. </P><P>*line = ' CITYFROM CITYTO '. </P><P> line = ' AIRPTO '. </P><P> APPEND line TO list. </P><P></P><P>SELECT DISTINCT (list) </P><P> INTO CORRESPONDING FIELDS OF TABLE itab </P><P> FROM spfli. </P><P></P><P>IF sy-subrc EQ 0. </P><P> LOOP AT itab INTO wa. </P><UL><LI level="1" type="ul"><P> WRITE: / wa-cityfrom, wa-cityto. </P></LI></UL><P> WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> wa-airpto. </P><P> ENDLOOP. </P><P>ENDIF. </P><P></P><P>also have a look at below weblog:</P><P>/people/subramanian.venkateswaran2/blog/2004/11/19/dynamic-internal-table</P><P></P><P>It gives you info abt how to create dynamic internal table.</P><P>see this program</P><P></P><P>Reward points if useful.</P></BODY></HTML> Fri, 11 Apr 2008 05:12:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677611#M885684 Former Member 2008-04-11T05:12:22Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677612#M885685 <HTML><HEAD></HEAD><BODY><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="4972543"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="4817594"></A></P><P></P><P>Reward points..</P></BODY></HTML> Fri, 11 Apr 2008 05:12:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677612#M885685 Former Member 2008-04-11T05:12:32Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677613#M885686 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P><STRONG>Internal Table</STRONG> </P><P></P><P> An internal table is a temporary table stored in RAM on the application server. It is created and filled by a program during execution and is discarded when the program ends. Like a database table, an internal table consists of one or more rows with an identical structure, but unlike a database table, it cannot hold data after the program ends. Use it as temporary storage for manipulating data or as a temporary private buffer.</P><P></P><P></P><P></P><P><STRONG>Definition of an Internal Table</STRONG></P><P>An internal table consists of a body and an optional header line . </P><P></P><P>The body holds the rows of the internal table. All rows within it have the same structure. The term "internal table" itself usually refers to the body of the internal table. </P><P></P><P>The header line is a field string with the same structure as a row of the body, but it can only hold a single row. It is a buffer used to hold each record before it is added or each record as it is retrieved from the internal table.</P><P></P><P>To define an internal table body, use occurs n on the definition of any field string except tables. occurs creates the body of the internal table. The memory for the body is not allocated until the first row is added to it. Without occurs, you only have a field string. </P><P></P><P>To define an internal table with a header line, you must include either begin of or with header line in the definition. A header line is automatically created if begin of appears in the definition. If you use like instead of begin of, the internal table will not have a header line unless you add with header line after the occurs clause. This is illustrated in lines 2 through 10 of Listing 11.1. </P><P></P><P>The only time you would create an internal table without a header line is in the case of a nested internal table. A nested internal table cannot have a header line. </P><P></P><P></P><P> Listing 11.1 Basic Ways of Defining Internal Tables with and Without a Header Line</P><P></P><P></P><P> 1 report ztx1101.</P><P> 2 data: begin of it1 occurs 10, "has a header line</P><P> 3 f1,</P><P> 4 f2,</P><P> 5 f3,</P><P> 6 end of it1.</P><P> 7</P><P> 8 data it2 like ztxlfa1 occurs 100. "doesn't have a header line</P><P> 9</P><P>10 data it3 like ztxlfa1 occurs 100 with header line. "it does now</P><P></P><P><STRONG>Reward if useful</STRONG></P><P></P><P>Regards ,</P><P></P><P> Shankar GJ</P><P></P><P>Edited by: Shankar GJ on Apr 11, 2008 7:16 AM</P></BODY></HTML> Fri, 11 Apr 2008 05:16:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677613#M885686 Former Member 2008-04-11T05:16:06Z Re: reg internal tables https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677614#M885687 <HTML><HEAD></HEAD><BODY><P>data: dy_table type ref to data,</P><P> dy_line type ref to data,</P><P> xfc type lvc_s_fcat,</P><P> ifc type lvc_t_fcat.</P><P></P><P>iam unable to understand the above declaration</P><P>dy_table type ref to data(here data seems....)</P><P>that means wt it is referring.pls tell me iam new to oop</P></BODY></HTML> Fri, 11 Apr 2008 06:47:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reg-internal-tables/m-p/3677614#M885687 Former Member 2008-04-11T06:47:07Z