topic Re: Error converting internal table data to FLat file in Application Development and Automation Discussions

Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:07:37 GMT

SAP_CONVERT_TO_TEX_FORMAT

When i m using this function module to convert my internal table data in to text format

i m getting a dump :

Short text

The current statement is only defined for character-type data objects.

Please help me out

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:10:39 GMT

See that all your Internal table fields are of <b>CHAR</b> type

if not convert them to CHAR type and then use this fun module

it will work.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:10:49 GMT

hi,

we need to pass standard table as input check which table u r passing.

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:11:18 GMT

My Code looks some thing like this

TYPE-POOLS : truxs.

DATA : gt_text TYPE truxs_t_text_data.

SELECT * FROM vbak INTO TABLE lt_vbak.

CALL FUNCTION 'SAP_CONVERT_TO_TEX_FORMAT'

EXPORTING

i_field_seperator = '#'

TABLES

i_tab_sap_data = lt_vbak

CHANGING

i_tab_converted_data = gt_text.

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:13:14 GMT

if i m using many fields how will it be posible to change aal the fields to char type

like there can be more than 100 fiels in a table

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:14:46 GMT

I am using this for table VBAK

Re: Error converting internal table data to FLat file

dev_parbutteea — Mon, 11 Jun 2007 07:27:43 GMT

Hi,

try using dataset then,

OPEN DATASET outfile_fcsr FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

LOOP AT lt_vbak into wa_vbak.

TRANSFER wa_vbak TO outfile_fcsr.

ENDLOOP.

CLOSE DATASET outfile_fcsr.

where outfile_fcsr is file path.

Regards,

Sooness.

Re: Error converting internal table data to FLat file

Former Member — Mon, 11 Jun 2007 07:31:26 GMT

Hi sooness,

the thing is i do not want to save my file to the application server.

i need to pass this file to the LInux server through FTP.

will be using ftp_connect, ftp_command, ftp_r3_to_server commands after this