10-01-2009 9:50 AM
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.
10-02-2009 12:47 AM
Hi,
Try this way to prepare comma separated file.
I hope that it helps you.
Thanks
Venkat.O
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.
10-02-2009 8:31 AM
hi naga,
have you searched SCN for this? each day we get some post regarding this. Please find your answer from them.