Convert XML to FLAT

[Former Member]

Hi everybody,

we need to send INVOIC data (XML IDOC) in edifact format (=flatfile).

How can we map XML-Data to Flatfile? Do we have to write a adapter module?

Thanks regards

Mario

[Former Member · Accepted solution]

Hi;

You can use content conversion in the receiver file adapter to do this.

Mudit

[Former Member · Accepted solution]

hi,

i think no need of adapter module. you need to certain parameters in FCC.

check this link for more details:

http://help.sap.com/saphelp_nw70/helpdata/en/0d/00453c91f37151e10000000a11402f/frameset.htm

regards

ravi.

[Former Member · Accepted solution]

Hi all,

thanks for your replies.

Are there any other adapters except FILE that support a file content conversion?

Thanks Mario

[Former Member · Accepted solution]

Hi Mario,

<i>Are there any other adapters except FILE that support a file content conversion?</i>

<b>No</b> AFAIK .

Regards,

Sumit

[Former Member]

Dear Mario,

I think the mentioned possibilities aren't useful for the original task (EDIFACT XML --> EDIFACT plain text file). Knowing the complexity of the EDIFACT standard, this mapping would be too hard to realise with the FCC.

I think the best solution, is to choose a 3rd party tool (Seeburer BIC, ACTIS BOM, Stylus Studio, Conversion Agent, etc.), generate a conversion mapping in it and use the result as an adapter module.

(If I'm wrong please send me a working example for an EDIFACT XML --> EDIFACT plain with FCC. I'm looking for an easy solution as well

Best regards,

Andras

[bhavesh_kantilal]

I failed to see the EDIFACT coversion option and I agree with you.

I have not worked on EDI Conversions but I have to agree with your point that EDI conversions you either need to use SeeBruger or Conversion Agent .

Regards

Bhavesh

[Former Member]

Hi Mario,

SAP XI provides a module exactly for this pupose it is called "StrictXml2PlainBean"

Please see the link for deatils::

http://help.sap.com/saphelp_nw04/helpdata/en/44/748d595dab6fb5e10000000a155369/frameset.htm

you can use this with any adapter, Message Transformation Bean Can also be used we have to set the Transform.ContentDisposition=Plain/Text to convert the XML to Plain. but message Transormation bean does not work well if you want to send the converted text file as a Text attachment(it will still send an XML), Choice is yours

See the Message Transformation Bean Module's documentation at::

http://help.sap.com/saphelp_nw04/helpdata/en/57/0b2c4142aef623e10000000a155106/frameset.htm

Please reward points if found usefull.

regards

Piyush

[bhavesh_kantilal]

Or you can use MessageTransformBean.

This is described in this document , though it refers to JMS, can be used with any J2EE adapter,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f02d12a7-0201-0010-5780-8bf...

Regards

Bhavesh

[Former Member]

Hi,

You can achieve this by using File Content Conversion...another way is to use some modules XML2PLAIN in the module tab.

We can also use content conversion modules in the JMS adapters as well.

Thanks

Amitanshu

[Former Member]

Hi

>>Do we have to write a adapter module?

As suggested, FCC would be an easier and recommended choice

regards

krishna

[Former Member]

Hi Mario,

you dont need adapter module for this thing....

do a IDOC to file scenario........take input as INVOIC IDOC and output as edifact struc of invoic idoc........do the mapping if input and output strucs are different........in recever file adapter do content conversion.

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA