Problem with converting spool file into a text file.

Hello all,

We have a requirement to send out spool files generated out of invoices to a 3rd party printing house (who prefer to get the file in a CSV,TXT,XLS format, not PDF). The bespoke ABAP program writes invoice data from individual spools into a text file and adds a Header line for each invoice.

This passes through the SAP standard module RSPO_RETURN_SPOOLJOB, where the RAW format is converted. There are OSS notes on this FM as some formats like EXT and BCS give a dump - none of the notes can help with the issue.

However, I am not able to get the correct formatting of the invoice data when the spool is saved as a text file - the alignment of columns is lost, and it looks more 'compressed' than what you see via SP01.

We use SAP Script to format data, and tried to tweak it to work, but it does not help.

Any help to resolve this gratefully received.

Thanks,

Pramod

Edited by: pgokhale on Apr 13, 2011 11:39 AM