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.