topic convert to .CSV format in Application Development and Automation Discussions

convert to .CSV format

Former Member — Thu, 01 Oct 2009 08:50:29 GMT

Hi,

I am working on a report in BW.

Can any one tell me, is there any function module in BW to convert the file to .CSV(comma separated file).

I can use SAP_CONVERT_TO_TEXT_FORMAT, but this is not available in BW.

Re: convert to .CSV format

venkat_o — Thu, 01 Oct 2009 23:47:51 GMT

Hi, Try this way to prepare comma separated file.


DATA :BEGIN OF it_marc OCCURS 0,
                werks TYPE marc-werks,
                lgort TYPE marc-lgort,
                matnr TYPE marc-matnr,
           END OF it_marc.
DATA :BEGIN OF it_data OCCURS 0,
             data TYPE string,
           END OF it_data.
DATA:g_separator TYPE C VALUE ','.
START-OF-SELECTION.
SELECT * FROM marc INTO CORRESPONDING FIELDS OF TABLE it_marc up to 100 rows.
LOOP AT it_marc.
  CONCATENATE it_marc-werks it_marc-lgort  it_marc-matnr INTO it_data-data SEPARATED BY g_separator.
  APPEND it_data.
  CLEAR  it_data.
ENDLOOP.
"Now it_data table contains data which is separated by comma. You do not need always function module.

I hope that it helps you. Thanks Venkat.O

Re: convert to .CSV format

Former Member — Fri, 02 Oct 2009 07:31:28 GMT

hi naga,

have you searched SCN for this? each day we get some post regarding this. Please find your answer from them.