Flatfile-XI-Flatfile

Hi,

If you are getting a file in an xml form then you don't have to do content conversion. As SAP internally works with XML structure.

In case we have a file which is in a .txt or any other file where the structure of the file needs to be defined for SAP XI, we use FCC. This helps SAP XI to create XML format and then map it to your MT for mapping.

You can refer to these weblogs and links.

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

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

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Regards

Aashish Sinha

PS : reward points if helpful.

Hello,

go through this:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/flatFILETOFLATFILE&

Also go through these weblogs:

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC By Michal....simple fcc

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC :row as a 1 record(field)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC XI in role of FTP

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 - FCC by venkat...various field length

Thanks,

Maheshwari

Edited by: Maheshwari Morbale on Jan 21, 2008 10:23 AM

Edited by: Maheshwari Morbale on Jan 21, 2008 10:26 AM

hi

FCC in sender side:

Document name: your message type name

Document namespace: name space of message type

Recordset name:Parent node name

Recordset namespace: namespace

Recordset sctructure: child node name1,*(if your childnode occurence is unbounded)/1,child node name2,occurrence of childnode eg :1

recorde set sequence: ascending

Name Value

Childnode.fieldSeparator ,

Childnode.fieldNames name of the fieldsof thecoreesponding

childnode

insetead of fieldSeparator you can use field fixed length depending on your test file.

FCC in receiver side:

Recordset sctructure : parent node, childnode

Name Value

Childnode.fieldSeparator ,

Childnode.endSeparator 'nl'

Parentnode.fieldSeparator 'nl'

Links

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

rewards point if helpful

Regards

Kasturika

Hi Nagarjuna,

Please go thru these links,

File content conversion:

FCC

Ref:

Sender -

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

Key value:

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter -

TAB delimited

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

NAB the TAB (File Adapter)

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

Receiver FCC no need of Endseparator

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

Thanks,

Kalyan

Hi Nagarjuna ,

Check the FCC parameters explained using the following link

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

Regards,

Sushil.