convert SAP_CONVERT_TO_CSV_FORMAT

[Former Member]

type-pools:truxs.

TYPES : STRUCT_VABK TYPE VBAK.

DATA : ITAB1 TYPE TABLE OF VBAK.

DATA : ITAB2 TYPE TRUXS_T_TEXT_DATA.

hi all,

i want to convert my itab to comma separated itab and iam down loading to a flat file.

iam using the following code, iam getting the dump . could any body let me know the problem.

and how to resolve the same.

SELECT * FROM VBAK INTO TABLE ITAB1 WHERE ERDAT GT '01.01.1997'.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

I_FIELD_SEPERATOR = ';'

• I_LINE_HEADER =

• I_FILENAME =

• I_APPL_KEEP = ' '

TABLES

I_TAB_SAP_DATA = ITAB1

CHANGING

I_TAB_CONVERTED_DATA = ITAB2

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.

regards

prasana kumar

[Former Member]

type-pools:truxs.

TYPES : STRUCT_VABK TYPE VBAK.

DATA : ITAB1 TYPE TABLE OF VBAK.

DATA : ITAB2 TYPE TRUXS_T_TEXT_DATA.

hi all,

i want to convert my itab to comma separated itab and iam down loading to a flat file.

iam using the following code, iam getting the dump . could any body let me know the problem.

and how to resolve the same.

SELECT * FROM VBAK INTO TABLE ITAB1 WHERE ERDAT GT '01.01.1997'.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

I_FIELD_SEPERATOR = ';'

• I_LINE_HEADER =

• I_FILENAME =

• I_APPL_KEEP = ' '

TABLES

I_TAB_SAP_DATA = ITAB1

CHANGING

I_TAB_CONVERTED_DATA = ITAB2

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.

regards

prasana kumar

[Former Member]

Hi

what is the dump that you are getting?

sample :

data:

Filename TYPE dxfile-filename c lower case,

Delimiter TYPE char01 value ';',

Ouput_String TYPE truxs_t_text_data with header line.

*Use FM SAP_CONVERT_TO_CSV_FORMAT and pass a Delimiter and ITAB. This

returns an Ouput_String

• Convert Internal Table to ; delimited format

• There is a filename parameter on this FM but I don't think it's used

call function 'SAP_CONVERT_TO_CSV_FORMAT'

• exporting

• i_field_seperator = Delimiter "default ';'

• i_filename = Filename

tables

i_tab_sap_data = ITAB

changing

i_tab_converted_data = Ouput_String

exceptions

conversion_failed = 1

others = 2.

reg

Ramya

Edited by: Ramya S on Mar 19, 2009 7:45 AM

[Former Member]

call function 'SAP_CONVERT_TO_CSV_FORMAT'

exporting

i_field_seperator = c_field_separator

i_line_header = ' '

i_filename = p_file

i_appl_keep = ''

tables

i_tab_sap_data = itab.

give a file name like

Parameters pfile like rlgrap-filename default 'c/name.csv'.

thanks

[qamar_javed]

Hi Jaya,

In the exporting parameter uncomment the I_APPL_KEEP parameter and set the value SPACE.

Hope this works.

Regards,

Qamar.

[Former Member]

Hi Jaya,

Please be more specific.Just Specify the dump ur getting.

Also check the data in ur internal table once.May it can be the problem with the type of data the internal table contains.

Regards,

Lakshman.

[sarbajitm]

Hi,

keep space not comma for I_FIELD_SEPERATOR = ' '

Regards.

Sarbajit.

[Former Member]

Parameters pfile like rlgrap-filename default 'C:\.csv'.

call function 'SAP_CONVERT_TO_CSV_FORMAT'

exporting

i_field_seperator = c_field_separator

i_line_header = ' '

i_filename = pfile

i_appl_keep = ''

tables

i_tab_sap_data = itab.

[Former Member]

Did you checked the similar thread like yours..you'll get your answer