topic Fixed Length File in Application Development and Automation Discussions

Fixed Length File

Former Member — Thu, 29 Jun 2006 19:28:56 GMT

I need to download a some info from SAP into 110 character file. I am using FM GUI_DOWNLOAD but can't find the way to download the data with fixed length of 110. I am able to have the desired format with transfer record to file length 110. But I need to download the file on presentation server, so i can't use open/close dataset commands.

I tried using File type VSS but its an invalid type . Also I used export parameter TRUNC_TRAILING_BLANKS_EOL = ''. But it also didn't work.

Re: Fixed Length File

RichHeilman — Thu, 29 Jun 2006 19:33:00 GMT

So you need the trailing spaces at the end of each line, right?

Regards,

Rich Heilman

Re: Fixed Length File

Former Member — Thu, 29 Jun 2006 19:34:16 GMT

If you are downloading to the desktop, unfortunately there is no way to get fixed length file. You can add an extra 1 character field(181st) at the end and fill it with an agreed upon record end character so that the receiving application ignores it.

Re: Fixed Length File

Former Member — Thu, 29 Jun 2006 19:38:10 GMT

Yes I needed the trailing spaces at the end of each line to make its length equal 110.

But I again tried to have the parameter TRUNC_TRAILING_BLANKS_EOL = ''. And this time it worked.

Actually I was entering the wrong record length for appending.

Thanks for spending your time and replying to my issue.