topic Re: CSV file format in Application Development and Automation Discussions

CSV file format

Former Member — Fri, 09 Feb 2007 06:52:07 GMT

Hi,

I have a issue like this.

download the some materials from SAP to file which has in application server.

so the output format file should be of CSV file format.

how can format the output file can any one tell me this.

Re: CSV file format

Former Member — Fri, 09 Feb 2007 06:53:26 GMT

use transactioN <b>CG3Y</b>

Re: CSV file format

Former Member — Fri, 09 Feb 2007 06:58:30 GMT

hi kishan,

in that CG3Y transaction only ASC & BIN formats are there.CSV is not there.

CSV format is I heared that comma seperator value.

can any body tell me about this.

Re: CSV file format

Former Member — Fri, 09 Feb 2007 07:05:11 GMT

How do I download data in my internal table in a CSV file?

1ST capture file from application server to internal table using open dataset and close data set.

Use the Function Module SAP_CONVERT_TO_CSV_FORMAT to convert the internal table into Comma separated format then download this internal table using the Function Module GUI_DOWNLOAD.

EX-

Coding -
TYPE-POOLS: truxs.
TYPES:
  BEGIN OF ty_Line,
    vbeln LIKE vbap-vbeln,
    posnr LIKE vbap-posnr,
  END OF ty_Line.
TYPES: ty_Lines TYPE STANDARD TABLE of ty_Line WITH DEFAULT KEY.
DATA: itab   TYPE ty_Lines.
DATA: itab1  TYPE truxs_t_text_data.

SELECT
  vbeln
  posnr
  UP TO 10 ROWS
  FROM vbap
  INTO TABLE itab.

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.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename = 'C:TEMPtest.txt'
  TABLES
    data_tab = itab1
  EXCEPTIONS
    OTHERS   = 1.

Re: CSV file format

Former Member — Fri, 09 Feb 2007 08:25:23 GMT

I want this file data in application server not in a presentation server.

Re: CSV file format

Former Member — Fri, 09 Feb 2007 08:37:29 GMT

Hi Kanath,

Can you use ws_download FM when ever you are trying download data into file.

In that FM filetype parameters you should specify 'CVS'.

I think it will work.

Subbu.

Re: CSV file format

Former Member — Fri, 09 Feb 2007 08:48:08 GMT

Hi ....

you will mention file name with CSV.

open dataset....

TRANSFER rec TO '/usr/test.csv'.

close dataset.

Is it work.....

Pls give me replay....

Subbu.S

Re: CSV file format

Former Member — Wed, 14 Feb 2007 07:56:38 GMT

Hi Kishan,

in the FM you specified itab1.

after this FM i need to transfer this itab1 data to application server file.but it is not moving.can you tell me about this.

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.