topic Re: convert SAP_CONVERT_TO_CSV_FORMAT in Application Development and Automation Discussions

convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 06:36:40 GMT

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

Re: convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 06:41:54 GMT

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

Re: convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 06:43:06 GMT

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

Re: convert SAP_CONVERT_TO_CSV_FORMAT

qamar_javed — Thu, 19 Mar 2009 06:43:56 GMT

Hi Jaya,

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

Hope this works.

Regards,

Qamar.

Re: convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 06:43:59 GMT

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.

Re: convert SAP_CONVERT_TO_CSV_FORMAT

sarbajitm — Thu, 19 Mar 2009 06:49:11 GMT

Hi,

keep space not comma for I_FIELD_SEPERATOR = ' '

Regards.

Sarbajit.

Re: convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 09:16:29 GMT

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.

Re: convert SAP_CONVERT_TO_CSV_FORMAT

Former Member — Thu, 19 Mar 2009 09:18:50 GMT

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