topic Re: Export Data To Fixed Length File in Application Development and Automation Discussions

Export Data To Fixed Length File

Former Member — Mon, 08 Oct 2007 23:31:32 GMT

Hello,

I have a requirement to export a couple of files that need to be in a fixed length format.

I've tried opening the dataset and writing the records passing the column that the records should appear:

WRITE /, field1, 10 field2, etc...

I've also tried to do it through SAP_CONVERT_TO_CSV_FORMAT and the text version as well.

Is there a predefined function that will allow me to export as fixed length?

Thank you in advance

Re: Export Data To Fixed Length File

Former Member — Tue, 09 Oct 2007 00:37:40 GMT

Hi Jeff,

Can you expalin in more details as what is your exact requirement.

Regards,

Atish

Re: Export Data To Fixed Length File

Former Member — Tue, 09 Oct 2007 03:16:44 GMT

Function Modules

http://www.erpgenie.com/abap/functions.htm

http://www.sapdevelopment.co.uk/fmodules/fmssap.htm

http://www.erpgenie.com/abap/index.htm

http://www.geocities.com/victorav15/sapr3/abapfun.html

Rewards if useful..........

Minal

Re: Export Data To Fixed Length File

Former Member — Tue, 09 Oct 2007 03:19:08 GMT

Hi Jeff,

Following is the code to do the same:

DATA: file TYPE string VALUE `flights.dat`, 
      wa   TYPE spfli. 

FIELD-SYMBOLS TYPE x. 

OPEN DATASET file FOR OUTPUT IN BINARY MODE. 

SELECT * 
       FROM spfli 
       INTO wa. 
  ASSIGN wa TO CASTING. 
  TRANSFER TO file. 
* TRANSFER LENGTH 200 to file.

ENDSELECT. 

CLOSE DATASET file.

Best regards,

Prashant