Skip to Content
0
Former Member
Jan 11, 2012 at 11:17 PM

Problem with comma separated .CSV file.

1006 Views

Hi,

I am facing a problem in creating comma separated .CSV file. Its downloading in the semi column (0040000001;000010) separated. In fact, I need it in comma separated (0040000001,000010).

Here is my code. Can you please suggest what changes needs to be done.

TYPES: CHAR4096(4096) TYPE C.

TYPES: BEGIN OF ITAB,

VBELN LIKE VBAP-VBELN,

POSNR LIKE VBAP-POSNR,

END OF ITAB.

DATA: IT_ITAB TYPE TABLE OF ITAB.

DATA: DO_ITAB TYPE TABLE OF CHAR4096,

LV_GUI_SEP TYPE C value ','.

SELECT VBELN

POSNR

UP TO 10 ROWS

FROM VBAP

INTO TABLE IT_ITAB.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

I_FIELD_SEPERATOR = LV_GUI_SEP

TABLES

I_TAB_SAP_DATA = IT_ITAB[]

CHANGING

I_TAB_CONVERTED_DATA = DO_ITAB[]

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:\abc.csv'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = LV_GUI_SEP

TABLES

DATA_TAB = DO_ITAB

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE

Thanks in advance for your help!

Regards,

Sri.