topic Re: Large record problems on transfer in Application Development and Automation Discussions

Large record problems on transfer

Former Member — Mon, 25 Oct 2004 14:33:16 GMT

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.

Re: Large record problems on transfer

Former Member — Mon, 25 Oct 2004 14:47:26 GMT

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

Re: Large record problems on transfer

Former Member — Mon, 25 Oct 2004 15:03:56 GMT

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.

Re: Large record problems on transfer

andreas_mann3 — Tue, 26 Oct 2004 10:01:55 GMT

Hi Chris,

move the "comments field" into a field

with variable length (type sting)

Grx Andreas