Large record problems on transfer

[Former Member]

Hello.

I was hoping someone could help me in my quest to get a very large tab delimited record (25k) down to the user's PC. I have been trying the transfer command to get the file down to our Unix server however am running into a severe truncation issue. I tried the length parameter, but it does not seem to be working. Also tried to use the WS_Download FM within program, but it too has limitations.

The download record has characters fields of various lengths ending with a huge comments field that is 23k or so characters.

The file will ultimately end up on the users PC to be brought into EXCEL. We are on 4.6C

Any suggestions would be welcomed.

Thank you.

Chris.

[Former Member]

Hi Chris,

Have you tired sending the data down in batches yet? Look at using a statement similar to this:

SELECT F1, F2, FN FROM <SAP Table>

INTO TABLE <SAP Internal Table>

PACKAGE SIZE 10000

code to write the <SAP Internal Table> to a file share

ENDSELECT

Cheers! Bill

[Former Member]

Hello Bill.

Thanks for your suggestion. I have approached the subject of breaking this mammoth up into something more managable. Not getting a good reception from the end user. They just would like to run the program and have the file available to upload into EXCEL without really having to do much in between.....

It may come down to this however!

Thanks again.

[andreas_mann3]

Hi Chris,

move the "comments field" into a field

with variable length (type sting)

Grx Andreas