topic Dynamic Internal Table in Application Development and Automation Discussions

topic Dynamic Internal Table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-internal-table/m-p/2553979#M581895 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P></P><P> The below program was taken from the <b>SDN</b> forum, but as a beginner in abap it is difficult for me to understand the assignment of Field Symbols in this program even though the steps are clearly explained here.</P><P></P><P> So can anyone explain me ,where the internal table is dynamically created also how field symbols are actually helpful in creating the dynamic internal table in this program?.</P><P></P><P>*Data definitions</P><UL><UL><UL><LI level="3" type="ul"><P>Tables</P></LI></UL></UL></UL><P>DATA: LT_DATA type ref to DATA.</P><P>DATA: LT_FIELDCATALOG type LVC_T_FCAT.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Structure</P></LI></UL></UL></UL><P>DATA: LS_FIELDCATALOG type LVC_S_FCAT.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Data References</P></LI></UL></UL></UL><P>DATA: NEW_LINE type ref to data,</P><P>FS_DATA type ref to data.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Field Symbols</P></LI></UL></UL></UL><P>FIELD-SYMBOLS: <FS_DATA> type ref to DATA,</P><P><FS_1> type any table,</P><P><FS_2>,</P><P><FS_3>.</P><P></P><P>*Populating the internal table with fieldnames required for our dynamic</P><P>*internal table</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'MANDT'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CARRID'. "Fieldname</P><P>LS_FIELDCATALOG-INTTYPE = 'C'. "Internal Type C-> Character</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CONNID'.</P><P>LS_FIELDCATALOG-INTTYPE = 'N'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'FLDATE'.</P><P>LS_FIELDCATALOG-INTTYPE = 'D'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'PRICE'.</P><P>LS_FIELDCATALOG-INTTYPE = 'P'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CURRENCY'.</P><P>LS_FIELDCATALOG-INTTYPE = 'C'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>*Calling the method CREATE_DYNAMIC_TABLE</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>*Assigning Field-Symbol to our dynamic internal table</P><P>assign LT_DATA to <FS_DATA>.</P><P></P><P></P><P>*Internal Table is ready, now to put data in that table</P><UL><UL><UL><LI level="3" type="ul"><P>So <FS_1> now points to our dynamic internal table.</P></LI></UL></UL></UL><P></P><P>assign FS_DATA->* to <FS_1>.</P><P></P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Next step is to create a work area for our dynamic internal table.</P></LI></UL></UL></UL><P></P><P>create data NEW_LINE like line of <FS_1>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>A field-symbol to access that work area</P></LI></UL></UL></UL><P>assign NEW_LINE->* to <FS_2>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>And to put the data in the internal table</P></LI></UL></UL></UL><P>select</P><P>MANDT</P><P>CARRID</P><P>CONNID</P><P>FLDATE</P><P>PRICE</P><P>CURRENCY</P><P>from SFLIGHT</P><P>into corresponding fields of table <FS_1>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Access contents of internal table</P></LI></UL></UL></UL><P>loop at <FS_1> assigning <FS_2>.</P><P>do 5 times.</P><P>assign component sy-index of structure <FS_2> to <FS_3>.</P><P>write: <FS_3>.</P><P>enddo.</P><P>skip 1.</P><P>endloop.</P><P></P><P>TOP-OF-PAGE.</P><P>WRITE:/5 'FUJITSU CONSULTING COMPANY' INVERSE COLOR 6,</P><P>50 SY-DATUM INVERSE COLOR 6,</P><P>70 SY-PAGNO INVERSE COLOR 6.</P><P>ULINE.</P><P></P><P></P><P>ganesh</P></BODY></HTML> Thu, 12 Jul 2007 16:23:02 GMT Former Member 2007-07-12T16:23:02Z Dynamic Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-internal-table/m-p/2553979#M581895 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P></P><P> The below program was taken from the <b>SDN</b> forum, but as a beginner in abap it is difficult for me to understand the assignment of Field Symbols in this program even though the steps are clearly explained here.</P><P></P><P> So can anyone explain me ,where the internal table is dynamically created also how field symbols are actually helpful in creating the dynamic internal table in this program?.</P><P></P><P>*Data definitions</P><UL><UL><UL><LI level="3" type="ul"><P>Tables</P></LI></UL></UL></UL><P>DATA: LT_DATA type ref to DATA.</P><P>DATA: LT_FIELDCATALOG type LVC_T_FCAT.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Structure</P></LI></UL></UL></UL><P>DATA: LS_FIELDCATALOG type LVC_S_FCAT.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Data References</P></LI></UL></UL></UL><P>DATA: NEW_LINE type ref to data,</P><P>FS_DATA type ref to data.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Field Symbols</P></LI></UL></UL></UL><P>FIELD-SYMBOLS: <FS_DATA> type ref to DATA,</P><P><FS_1> type any table,</P><P><FS_2>,</P><P><FS_3>.</P><P></P><P>*Populating the internal table with fieldnames required for our dynamic</P><P>*internal table</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'MANDT'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CARRID'. "Fieldname</P><P>LS_FIELDCATALOG-INTTYPE = 'C'. "Internal Type C-> Character</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CONNID'.</P><P>LS_FIELDCATALOG-INTTYPE = 'N'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'FLDATE'.</P><P>LS_FIELDCATALOG-INTTYPE = 'D'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'PRICE'.</P><P>LS_FIELDCATALOG-INTTYPE = 'P'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>LS_FIELDCATALOG-FIELDNAME = 'CURRENCY'.</P><P>LS_FIELDCATALOG-INTTYPE = 'C'.</P><P>append LS_FIELDCATALOG to LT_FIELDCATALOG.</P><P></P><P>*Calling the method CREATE_DYNAMIC_TABLE</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>*Assigning Field-Symbol to our dynamic internal table</P><P>assign LT_DATA to <FS_DATA>.</P><P></P><P></P><P>*Internal Table is ready, now to put data in that table</P><UL><UL><UL><LI level="3" type="ul"><P>So <FS_1> now points to our dynamic internal table.</P></LI></UL></UL></UL><P></P><P>assign FS_DATA->* to <FS_1>.</P><P></P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Next step is to create a work area for our dynamic internal table.</P></LI></UL></UL></UL><P></P><P>create data NEW_LINE like line of <FS_1>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>A field-symbol to access that work area</P></LI></UL></UL></UL><P>assign NEW_LINE->* to <FS_2>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>And to put the data in the internal table</P></LI></UL></UL></UL><P>select</P><P>MANDT</P><P>CARRID</P><P>CONNID</P><P>FLDATE</P><P>PRICE</P><P>CURRENCY</P><P>from SFLIGHT</P><P>into corresponding fields of table <FS_1>.</P><P></P><UL><UL><UL><LI level="3" type="ul"><P>Access contents of internal table</P></LI></UL></UL></UL><P>loop at <FS_1> assigning <FS_2>.</P><P>do 5 times.</P><P>assign component sy-index of structure <FS_2> to <FS_3>.</P><P>write: <FS_3>.</P><P>enddo.</P><P>skip 1.</P><P>endloop.</P><P></P><P>TOP-OF-PAGE.</P><P>WRITE:/5 'FUJITSU CONSULTING COMPANY' INVERSE COLOR 6,</P><P>50 SY-DATUM INVERSE COLOR 6,</P><P>70 SY-PAGNO INVERSE COLOR 6.</P><P>ULINE.</P><P></P><P></P><P>ganesh</P></BODY></HTML> Thu, 12 Jul 2007 16:23:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-internal-table/m-p/2553979#M581895 Former Member 2007-07-12T16:23:02Z Re: Dynamic Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-internal-table/m-p/2553980#M581896 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>see the doc of field symbols </P><P>Syntax </P><P>FIELD-SYMBOLS <fs> { typing | STRUCTURE struc DEFAULT dobj }. </P><P></P><P>Extras: </P><P>1. ... typing </P><P></P><P>2. ... STRUCTURE struc DEFAULT dobj </P><P></P><P>Effect </P><P>The FIELD-SYMBOLS statement declares a field symbol <fs>. The naming conventions apply to the name fs. The angle brackets of the field symbols indicate the difference to data objects and are obligatory. You can declare field symbols in any procedure and in the global declaration section of an ABAP program, but not in the declaration section of a class or an interface. You can use a field symbol in any operand position in which it is visible and which match the typing defined using typing. </P><P></P><P>After its declaration, a field symbol is initial - that is, it does not reference a memory area. You have to assign a memory area to it (normally using the ASSIGN statement) before you can use it as an operand. Otherwise an exception will be triggered. </P><P></P><P>Addition 1 </P><P>... typing </P><P></P><P></P><P>Effect </P><P>You can use the addition typing to type the field symbol. The syntax of typing is described under Syntax of Typing. The typing specifies which memory areas can be assigned to the field symbol (see Checking the Typing) and in which operand positions it can be used. </P><P></P><P>Note </P><P>You can omit the addition typing outside of methods. In this case, the field symbol has the complete generic type any and is implicitly assigned the predefined constant space during the declaration.</P><P></P><P></P><P></P><P>Addition 2 </P><P>... STRUCTURE struc DEFAULT dobj </P><P></P><P>Effect </P><P>If you specify the addition STRUCTURE instead of typing for a field symbol, and struc is a local program structure (a data object, not a data type) or a flat structure from the ABAP Dictionary, this structure is cast for the field symbol <fs>. You have to specify a data object dobj that is initially assigned to the field symbol. </P><P></P><P>The field symbol copies the technical attributes of structure struc as if it were completely typed. When you assign a data object using the addition DEFAULT, or later using ASSIGN, its complete data type is not checked in non- Unicode programs. Instead, the system merely checks whether it has at least the length of the structure and its alignment. </P><P></P><P>In Unicode programs, we differentiate between structured and elementary data objects. For a structured data object dobj, its Unicode fragment view has to match the one of struc. In the case of an elementary data object, the object must be character-type and flat, and struc must be purely character-type. The same applies to assignments of data objects to field symbols typed using STRUCTURE when using the ASSIGN statement. </P><P></P><P>Note </P><P>Field symbols declared using the addition STRUCTURE are a mixture of typed field symbols and a utility for casting structured data types. You should use the additions TYPE or LIKE for the FIELD-SYMBOLS statement to type field symbols, while the addition CASTING of the ASSIGN statement is used for casting. </P><P></P><P>Example </P><P>The first example shows the obsolete usage of the addition STRUCTURE. </P><P></P><P>DATA wa1 TYPE c LENGTH 512. </P><P>FIELD-SYMBOLS <scarr1> STRUCTURE scarr DEFAULT wa1. </P><P><scarr1>-carrid = '...'. </P><P></P><P>The second example shows the replacement of STRUCTURE with the additions TYPE and CASTING. </P><P></P><P>DATA wa2 TYPE c LENGTH 512. </P><P>FIELD-SYMBOLS <scarr2> TYPE scarr. </P><P>ASSIGN wa2 TO <scarr2> CASTING. </P><P><scarr2>-carrid = '...'. </P><P></P><P>Dynamic Internal tables</P><P></P><P>Dynamic internal table is internal table that we create on the fly with flexible column numbers. </P><P>For sample code, please look at this code tutorial. Hopefully it can help you <SPAN __jive_emoticon_name="wink"></SPAN></P><P></P><P></P><P>Check this link:</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><b>Reward points for useful Answers</b></P><P>Regards</P><P>Anji</P></BODY></HTML> Thu, 12 Jul 2007 16:33:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-internal-table/m-p/2553980#M581896 Former Member 2007-07-12T16:33:55Z