Is there simply way to map an idoc to an flatfile?

[Former Member]

Hello,

I want to convert an idoc to an flatfile.

I found a document: How to...Convert between Idoc XML structures and flat files in XI3.0. This document is talking about mapping the idoc to flatfile with a abap mapping. Is there an easier way?

Best Regards,

Erik van Lisdonk

[Former Member · Accepted solution]

Hello,

Erik again.

Thanks for your help so far!

I try to specify my scenario.

I got an idoc which I want to convert to an "customized" flatfile. This flatfile doesn't look like the idoc at all. For every idoc position (P01) I want to create one record in my flatfile. That means that in this flatfile there is no hierarchy of records.

The flatfile should, after mapping the idoc, look like this:

56000472020011001740000001560007000000000001683 x

56000472020012001740000010560008000000000001683 x

56000472020013001740000001560021000000000001683 x

56000472020014001740000006560026000000000001683 x

Is there a way to do this without using an abap mapping?

Is there an other way?

Best Regards,

Erik

[MichalKrawczyk · Accepted solution]

Hi Erik,

yes you don't have to use abap mapping

you can use standard (easy) content conversion

in the file adapter

have a look at this weblog which describes it:

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[Former Member · Accepted solution]

Hi Erik,

Yours is a filexiidoc scenario and adding to what others have said already,

<i>This flatfile doesn't look like the idoc at all. For every idoc position (P01) I want to create one record in my flatfile. That means that in this flatfile there is no hierarchy of records.

</i>

Yes, in this case you need to map this to an idoc structure, you need not use abap mapping , use a simple graphical mapping to map it,So you typically need a file sender adapter to pick this flat file do a content conversion, as

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

And after that you need to map as per your Functional specs or rules like this,

/people/ravikumar.allampallam/blog/2005/02/28/creating-sales-order-through-idoc

Hope this can start off your devlopement and if anywhere you need help on mapping,we can again discuss it.

All the best,

Anirban.

[Former Member · Accepted solution]

Hi Anirban!

I've checked the url site, https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1818. [original link is broken] [original link is broken] [original link is broken] This blogs contains the conversion from flatfile to xml.

My question is that, Is there also a usefule blogs that contain the conversion from XML to flatfile?

How will I convert XML to flatfile using the Integration Repository and Integration Directory?

Kindly advise!

Thank you!

[Former Member]

Hi Erik,

To map an IDOC to a Flat file you need not do ABAP mapping and all that. You can use a simple graphical mapping….but of what I have understood, I think you wanna create a file data type similar to that of the IDOC structure for mapping….Is it that what you wanna do Erik? If so please let us know…

Just to give you a good idea about mapping and the various mappings in SAP XI, Mapping is basically done to convert one form of xml into another form. This can be done using either of them mentioned below.

- Graphical mapping

- XSLT mapping

- JAVA mapping

- ABAP mapping

To know more about each of them please go thru the following links. And if you ask me your which is better, it depends basically on the scenario you implementing and the complexity involved. Anyways please go thru the following links:

Graphical mapping

/people/bhanu.thirumala/blog/2006/02/02/graphical-message-mapping-150-text-preview

http://www.sapgenie.com/netweaver/xi/mapping1.htm

/people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping

XSLT mapping

http://help.sap.com/saphelp_nw04/helpdata/en/73/f61eea1741453eb8f794e150067930/content.htm

JAVA mapping

http://help.sap.com/saphelp_nw04/helpdata/en/e2/e13fcd80fe47768df001a558ed10b6/content.htm

ABAP mapping

/people/r.eijpe/blog

To know more about the value mapping tools for the SAP Exchange Infrastructure (XI), please go thru the following link:

http://www.applicon.dk/fileadmin/filer/XI_Tools/ValueMappingTool.pdf

To get an idea as to what value mapping is, please go thru the following links:

http://help.sap.com/saphelp_nw04/helpdata/en/13/ba20dd7beb14438bc7b04b5b6ca300/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f2/dfae3d47afd652e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2a/9d2891cc976549a9ad9f81e9b8db25/content.htm

most of the links that I have provided also helps you get the step by step procedure of doing the same. And also involves the procedure to implement certain advanced features.

Hope this clears your doubt fully.

Regards,

Abhy

PS: AWARD POINTS FOR HELPUL ANSWERS.

[Former Member]

Hello,

You do not have to convert the IDOC to XML and then get it back to flatfile. Just deactivate the conversion for IDOC adapter.

Under sxmb_admin and category IDOC

Use parameter XML_Conversion.

Parameter XML_CONVERSION

Meaning

The parameter defines whether the IDoc is transported as a table and is not converted to IDoc-XML in the IDoc adapter. This is only recommended if IDocs are received and sent as IDocs in the Integration Server. If none of the services in the Integration Engine use IDoc-XML, you can avoid unnecessary conversion from and to XML, thereby improving system performance.

Possible Values

'0' Every IDoc is saved as a table; no IDoc-XML conversion

'1' Every IDoc is converted to IDoc-XML

'2' An IDoc is converted to IDoc-XML if requested by the service

regards,

Hai