topic Re: Inserting data from workarea to custom table in Application Development and Automation Discussions

topic Re: Inserting data from workarea to custom table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998335#M406515 <HTML><HEAD></HEAD><BODY><P>hi</P><P> there r multiple ways 2 insert data into custom table into work area few being</P><P>APPEND, INSERT and evenn using select queries u can populate the custom table .</P><P></P><P>DATA:</P><P> BEGIN OF FS_AIRLINE,</P><P> CARRID(5) TYPE C, " Carrier id</P><P> FLICONNID(4) TYPE N, " Connection id</P><P> FLITDATE LIKE SY-DATUM, " Flight date</P><P> END OF FS_AIRLINE.</P><P></P><P></P><P><STRONG>"----</STRONG></P><HR originaltext="---------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Internal table to hold Flight details *</P></LI></UL><P><STRONG>"----</STRONG></P><HR originaltext="---------------------------------------------------------------" /><P></P><P>DATA:</P><P> T_AIRLINE LIKE</P><P> STANDARD TABLE</P><P> OF FS_AIRLINE</P><P> WITH NON-UNIQUE KEY FLICONNID.</P><P></P><P>PERFORM POPULATE_TABLE.</P><P>PERFORM DISPLAY_TABLE.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form POPULATE_TABLE *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> This subroutine populates the internal table with flight details. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> There are no interface parameters to be passed to this subroutine. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>FORM POPULATE_TABLE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'AA'.</P><P> FS_AIRLINE-FLICONNID = '0017'.</P><P> FS_AIRLINE-FLITDATE = '19991212'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'DL'.</P><P> FS_AIRLINE-FLICONNID = '1984'.</P><P> FS_AIRLINE-FLITDATE = '20000506'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'AA'.</P><P> FS_AIRLINE-FLICONNID = '0026'.</P><P> FS_AIRLINE-FLITDATE = '19990804'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'UA'.</P><P> FS_AIRLINE-FLICONNID = '0941'.</P><P> FS_AIRLINE-FLITDATE = '20001111'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'LH'.</P><P> FS_AIRLINE-FLICONNID = '1699'.</P><P> FS_AIRLINE-FLITDATE = '20000201'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'LH'.</P><P> FS_AIRLINE-FLICONNID = '0026'.</P><P> FS_AIRLINE-FLITDATE = '19770901'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P>ENDFORM. " POPULATE_TABLE</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form DISPLAY_TABLE *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> This subroutine displays the contents of internal table. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> There are no interface parameters to be passed to this subroutine. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>FORM DISPLAY_TABLE.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-FLITDATE EQ '19990804'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-CARRID EQ 'LH'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-FLITDATE GT '20000501'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P>try the above code and let me know if it meets ur requirement.</P><P></P><P>if u have field string with fields f1,f2,f3,f4,f5.</P><P></P><P>and if u want 2 insert only certain fields from work area 2 table then append those fields 2 table from work area other fields r filled with initial values depending on the data type.</P><P></P><P></P><P>regards,</P><P>kiran kumar k</P><P></P><P>Message was edited by: </P><P> kiran kumar kamati</P></BODY></HTML> Mon, 12 Mar 2007 12:43:46 GMT Former Member 2007-03-12T12:43:46Z Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998332#M406512 <HTML><HEAD></HEAD><BODY><P>how to insert certain fields from work area to custom table.</P></BODY></HTML> Mon, 12 Mar 2007 12:37:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998332#M406512 Former Member 2007-03-12T12:37:56Z Re: Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998333#M406513 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Do like this,.</P><P>Itab-f1 = wa-f1</P><P>itab-f2 = wa-f2</P><P>...........</P><P>...........</P><P>append itab.</P><P>clear itab.</P><P>insert into Ztab from Itab.</P><P>Regards,</P><P>Anji</P><P></P><P>Message was edited by: </P><P> Anji Reddy Vangala</P></BODY></HTML> Mon, 12 Mar 2007 12:40:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998333#M406513 Former Member 2007-03-12T12:40:36Z Re: Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998334#M406514 <HTML><HEAD></HEAD><BODY><P>hi,</P><P> you fill those fields of the work area and append that field string to table.</P><P> in any case if like to fill the remaining fields u again by using update statement ,u modify that row</P><P>if u want an example reply me i send an example.</P><P></P><P>Message was edited by: </P><P> sunil kumar</P><P></P><P>Message was edited by: </P><P> sunil kumar</P></BODY></HTML> Mon, 12 Mar 2007 12:42:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998334#M406514 Former Member 2007-03-12T12:42:14Z Re: Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998335#M406515 <HTML><HEAD></HEAD><BODY><P>hi</P><P> there r multiple ways 2 insert data into custom table into work area few being</P><P>APPEND, INSERT and evenn using select queries u can populate the custom table .</P><P></P><P>DATA:</P><P> BEGIN OF FS_AIRLINE,</P><P> CARRID(5) TYPE C, " Carrier id</P><P> FLICONNID(4) TYPE N, " Connection id</P><P> FLITDATE LIKE SY-DATUM, " Flight date</P><P> END OF FS_AIRLINE.</P><P></P><P></P><P><STRONG>"----</STRONG></P><HR originaltext="---------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Internal table to hold Flight details *</P></LI></UL><P><STRONG>"----</STRONG></P><HR originaltext="---------------------------------------------------------------" /><P></P><P>DATA:</P><P> T_AIRLINE LIKE</P><P> STANDARD TABLE</P><P> OF FS_AIRLINE</P><P> WITH NON-UNIQUE KEY FLICONNID.</P><P></P><P>PERFORM POPULATE_TABLE.</P><P>PERFORM DISPLAY_TABLE.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form POPULATE_TABLE *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> This subroutine populates the internal table with flight details. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> There are no interface parameters to be passed to this subroutine. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>FORM POPULATE_TABLE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'AA'.</P><P> FS_AIRLINE-FLICONNID = '0017'.</P><P> FS_AIRLINE-FLITDATE = '19991212'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'DL'.</P><P> FS_AIRLINE-FLICONNID = '1984'.</P><P> FS_AIRLINE-FLITDATE = '20000506'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'AA'.</P><P> FS_AIRLINE-FLICONNID = '0026'.</P><P> FS_AIRLINE-FLITDATE = '19990804'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'UA'.</P><P> FS_AIRLINE-FLICONNID = '0941'.</P><P> FS_AIRLINE-FLITDATE = '20001111'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'LH'.</P><P> FS_AIRLINE-FLICONNID = '1699'.</P><P> FS_AIRLINE-FLITDATE = '20000201'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P> CLEAR FS_AIRLINE.</P><P> FS_AIRLINE-CARRID = 'LH'.</P><P> FS_AIRLINE-FLICONNID = '0026'.</P><P> FS_AIRLINE-FLITDATE = '19770901'.</P><P> APPEND FS_AIRLINE TO T_AIRLINE.</P><P></P><P>ENDFORM. " POPULATE_TABLE</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form DISPLAY_TABLE *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> This subroutine displays the contents of internal table. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> There are no interface parameters to be passed to this subroutine. *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>FORM DISPLAY_TABLE.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-FLITDATE EQ '19990804'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-CARRID EQ 'LH'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P> SKIP.</P><P></P><P> LOOP AT T_AIRLINE INTO FS_AIRLINE.</P><P> IF FS_AIRLINE-FLITDATE GT '20000501'.</P><P> WRITE:</P><P> /10 FS_AIRLINE-CARRID,</P><P> 20 FS_AIRLINE-FLICONNID,</P><P> 50 FS_AIRLINE-FLITDATE.</P><P> ENDIF.</P><P> ENDLOOP. " LOOP AT T_AIRLINE...</P><P></P><P>try the above code and let me know if it meets ur requirement.</P><P></P><P>if u have field string with fields f1,f2,f3,f4,f5.</P><P></P><P>and if u want 2 insert only certain fields from work area 2 table then append those fields 2 table from work area other fields r filled with initial values depending on the data type.</P><P></P><P></P><P>regards,</P><P>kiran kumar k</P><P></P><P>Message was edited by: </P><P> kiran kumar kamati</P></BODY></HTML> Mon, 12 Mar 2007 12:43:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998335#M406515 Former Member 2007-03-12T12:43:46Z Re: Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998336#M406516 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>DATA: wa TYPE scustom. </P><P>wa-id = '12400177'. </P><P>wa-name = 'Robinson'. </P><P>wa-postcode = '69542'. </P><P>wa-city = 'Heidelberg'. </P><P>wa-custtype = 'P'. </P><P>wa-discount = '003'. </P><P>wa-telephone = '06201/44889'. </P><P></P><P>INSERT INTO scustom VALUES wa. </P><P></P><P>Regards,</P><P>Sruthi</P></BODY></HTML> Mon, 12 Mar 2007 12:55:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998336#M406516 Former Member 2007-03-12T12:55:52Z Re: Inserting data from workarea to custom table https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998337#M406517 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Let us suppose that work area is:"work_area" and the fields are a,b,c,d,e,f,g, and h</P><P></P><P>And internal table is itab1(with header line) and fields are a,b,c, and d only.</P><P></P><P>Now you do the following steps.</P><P></P><P>itab1-a = work_area-a</P><P>itab1-b = work_area-b</P><P>itab1-c = work_area-c</P><P>itab1-d = work_area-d</P><P></P><P>append itab1.</P><P></P><P></P><P>Your problem is done.</P><P></P><P>Regards,</P><P>Balakrishna.N</P></BODY></HTML> Mon, 12 Mar 2007 13:52:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/inserting-data-from-workarea-to-custom-table/m-p/1998337#M406517 Former Member 2007-03-12T13:52:01Z