topic Re: CSV file in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150918#M749306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try FM SAP_CONVERT_TO_TEX_FORMAT </P><P></P><P><STRONG>Reward points if found helpful...</STRONG></P><P></P><P><STRONG>Cheers,</STRONG></P><P><STRONG>Chandra Sekhar.</STRONG></P></BODY></HTML> Wed, 19 Dec 2007 08:14:21 GMT Former Member 2007-12-19T08:14:21Z CSV file https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150916#M749304 <HTML><HEAD></HEAD><BODY><P>Does anybody knows how to convert the data in to csv format?</P></BODY></HTML> Wed, 19 Dec 2007 07:59:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150916#M749304 Former Member 2007-12-19T07:59:43Z Re: CSV file https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150917#M749305 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use "SAP_CONVERT_TO_CSV_FORMAT" Function Module.</P><P></P><P>Example:</P><P>TYPE-POOLS: truxs.</P><P>TYPES:</P><P>BEGIN OF ty_Line,</P><P>vbeln LIKE vbap-vbeln,</P><P>posnr LIKE vbap-posnr,</P><P>END OF ty_Line.</P><P>TYPES: ty_Lines TYPE STANDARD TABLE of ty_Line WITH DEFAULT KEY.</P><P>DATA: itab TYPE ty_Lines.</P><P>DATA: itab1 TYPE truxs_t_text_data.</P><P></P><P>SELECT</P><P>vbeln</P><P>posnr</P><P>UP TO 10 ROWS</P><P>FROM vbap</P><P>INTO TABLE itab.</P><P></P><P>CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'</P><P>EXPORTING</P><P>i_field_seperator = ';'</P><P>TABLES</P><P>i_tab_sap_data = itab</P><P>CHANGING</P><P>i_tab_converted_data = itab1</P><P>EXCEPTIONS</P><P>conversion_failed = 1</P><P>OTHERS = 2.</P><P>IF sy-subrc 0.</P><P>MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno</P><P>WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.</P><P>ENDIF.</P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD'</P><P>EXPORTING</P><P>filename = 'C:\TEMP\test.txt'</P><P>TABLES</P><P>data_tab = itab1</P><P>EXCEPTIONS</P><P>OTHERS = 1. </P><P></P><P></P><P>Regards,</P><P>Sachin Bhatnagar.</P></BODY></HTML> Wed, 19 Dec 2007 08:10:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150917#M749305 Former Member 2007-12-19T08:10:17Z Re: CSV file https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150918#M749306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try FM SAP_CONVERT_TO_TEX_FORMAT </P><P></P><P><STRONG>Reward points if found helpful...</STRONG></P><P></P><P><STRONG>Cheers,</STRONG></P><P><STRONG>Chandra Sekhar.</STRONG></P></BODY></HTML> Wed, 19 Dec 2007 08:14:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/csv-file/m-p/3150918#M749306 Former Member 2007-12-19T08:14:21Z