Flat file into XML

[Former Member]

Hi,

I have a requriment like source will be sending IDoc DELVRY03 in form of flatfile(fixed length).So i have to convert to XML so that PI can do transformation.I cant do file content conversion.Target is also IDoc DELVRY03.

Kinldy suggest me how to convery flat file into XML.

Regards,

Anitha M

Edited by: Anitha m on Aug 3, 2010 10:07 AM

[Former Member · Accepted solution]

Hi,

We can convert IDOC into XML format at R3 system end itself. Select port type as XML (by default LS port) will be taken. If you take File port then we can get IDOC flat file.

Above setting not possible then we can do it in below ways.

1. If idoc structure is constant then we can go for FCC for Module program but it is bit complicated

2. Through BIC mapping we can convert IDOC flat file to IDOC xml easily.

[Former Member · Accepted solution]

Hi,

I want to convert IDoc flat file to XML format.Kindly provide me links for BIC mapping.

Regards,

Anitha M

[Former Member]

Hi Anitha,

The requirement that you have is to convert an IDoc which is in text format to XML.

This cannot be done using the normal FCC since FCC will not support the structural hierercy of an Idoc.

Hence the better option is to use a ENTERPRISE JAVA BEAN, which in turns calls opens the JCO to the SAP R/3 and call the function module IDX_IDOC_TO_XML. I am not really sure about the function module, you have to search a bit for the name.

The function module takes your File and return an XML.

You can use the EJB in the receiver adapter to convert into XML.

Thank you,

Anupam

[Former Member]

Hi Anitha,

You should use File content conversion to convert flat file into XML file.

Please check the below link, which help you to know how to do it.

http://saptechnical .com/Tutorials/XI/Contentconversion/page2.htm

Please check the weblink given below for converting the file content:

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

Thanks,

[Former Member]

>> I have a requriment like source will be sending IDoc DELVRY03 in form of flatfile(fixed length).

Since it is fixed length file therefore you will require to do File Content Conversion (FCC) in your sender File adapter.

>> Kinldy suggest me how to convery flat file into XML.

You can see an [example in this blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1092] [original link is broken] [original link is broken] [original link is broken];. For more information use the search functionality on SDN.

[prateek]

Try to find out if the text file is Idoc text file which can be directly uploaded in SAP using file port. If yes, then conversion in PI won't be required. Even if you want to convert it, there are some readily available programs.

Regards,

Prateek