FCC : Each line in file to end end with comma

[Former Member]

Hi All,

I am using FCC to write my IDOC data to a flat file.

All data is written perfectly except the end-of-line marker.

My requirement is that the end of line should have a comma ',' and the next data line should start in a new line 'nl'.

I tried using the statement Data.endSeparator = ',' . It does add a comma to the end of line but the next data line starts immediately after it and not in a new-line.

Is it possible to end the data line with a comma ',' and then make the next data line start ina new line.

Eg of my output file:

Current situation:

1 Header

2 Data , 3 Trailer

What I want:

1 Header

2 Data ,

3 Trailer

Appreciate your comments on thsi.

Regards

Shirin

Edited by: Shirin K on Jul 14, 2008 2:56 PM

[Former Member · Accepted solution]

Hey

try giving Data.endSeparator =',' and Data.beginSeparator='nl'

Thanx

Aamir

Edited by: Aamir Suhail on Jul 14, 2008 9:15 AM

[Former Member]

Hi, Thanks for the helpful tips. I tried creating a new column with a constant value ',', but since ita comma separated file, my data record ended with 2 commas.

So instead of passing a constant value ',' I have passed a constant value of space ' ' and then the output file looks fine.

The other solution of .begin Separator does not work. It simply appended 'nl' to the current data line.

Many thanks for all the tips. Problem solved as of now.

Regards

Shirin

[Former Member]

HI

File Content prameters for the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

File Content prameters for the Sender Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Refer

File Receiver with Content Conversion

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File content conversion sites

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Please see the below links for file content conversion..

- FCC

- FCC

File Content Conversion for Unequal Number of Columns

- FCC

Content Conversion (Pattern/Random content in input file)

- FCC

- FCC - MDM

XI in the role of a FTP

- FCC

File to R/3 via ABAP Proxy

- FCC

- EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm - cc

http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/da1e7c16-0c01-0010-278a-eaed5eae... - conversion agent

File Content prameters for the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

File Content prameters for the Sender Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Refer

File Receiver with Content Conversion

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File content conversion sites

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Please see the below links for file content conversion..

- FCC

- FCC

File Content Conversion for Unequal Number of Columns

- FCC

Content Conversion (Pattern/Random content in input file)

- FCC

cheers

[former_member181962]

have an additional dummy column in your data, to hold the COMMA .

Pass a constant "," in the maping .

and put the endseparator as 'nl'.

Regards,

ravi