topic Convert Internal table into CSV Format and upload into Application server in Application Development and Automation Discussions

Convert Internal table into CSV Format and upload into Application server

Former Member — Tue, 11 Jun 2019 12:58:45 GMT

Hi Experts,

I have a requirement where i need to convert the data from internal table into csv format with tab delimiter and save it in application server. The issue is i cannot use comma as the decimal format used is comma.when i use comma as the delimiter and download the file in .csv format using tcode CG3Y,it is working fine but the quantity field is impacted due to decimal notation. I have tried using FM SAP_CONVERT_TO_CSV_FORMAT but it is not helping.

Can you please help me with a solution where the data is converted into csv format and when downloaded from application server through CG3Y in csv format each data should be displayed in each column.

Thanks in advance.

Re: Convert Internal table into CSV Format and upload into Application server

matt — Tue, 11 Jun 2019 13:20:15 GMT

Use tab delimited instead? Or semi-colon delimited?

Re: Convert Internal table into CSV Format and upload into Application server

Nawanandana — Tue, 11 Jun 2019 13:40:54 GMT

Hi,

you can use i_field_seperator = ';' or '|' any seperate what you need.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'
EXPORTING
i_field_seperator = ';'
TABLES
i_tab_sap_data = itab
CHANGING
i_tab_converted_data = itab1
EXCEPTIONS
conversion_failed = 1
OTHERS = 2.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

Re: Convert Internal table into CSV Format and upload into Application server

Former Member — Wed, 12 Jun 2019 06:57:13 GMT

Hi,

I have tried this but neither its working with ;' nor '|'.

Thanks and Regards.

Re: Convert Internal table into CSV Format and upload into Application server

Former Member — Wed, 12 Jun 2019 06:59:09 GMT

Hi,

Tab delimeter(cl_abap_char_utilities=>horizontal_tab) works fine for xls but not for csv or xlsx. Semi-colon is not helping either.

Thanks and Regards,

Re: Convert Internal table into CSV Format and upload into Application server

matt — Wed, 12 Jun 2019 07:02:14 GMT

In what way is it not working? Tab delimited is a valid XLSX format - reading and writing.

Re: Convert Internal table into CSV Format and upload into Application server

former_member226519 — Wed, 12 Jun 2019 07:03:07 GMT

did you try to enclose numbers with apostrophe?

Re: Convert Internal table into CSV Format and upload into Application server

Former Member — Wed, 12 Jun 2019 12:38:27 GMT

Hi,

With tab delimiter while opening the file i am getting "Excel cannot open the file because the file format or file extension is not valid".

Thanks and Regards