Receiver CC File - Complex Flat File Conversion

[Former Member]

Dear forum users,

I want your opinion about the feasibility of the content conversion described below using Receiver CC.

The structure of my file is the following

- A File header segment (FH)

- 1...N Business Object that is described by many segments

- A file footer segment (FF)

Exemple of business Object : Purchase Order :

1 Header Segment (POH)

N Item Segments (POI)

Exemple of file :

FH

POH (PO 1)

POI (PO 1)

POI (PO 1)

POH (PO 2)

POI (PO 2)

POI (PO 2)

FF

Is content conversion standard tool can deal with such a structure ?

Note that in the file created, the order of each segment has a big importance :

PO Items of PO 1 must be after PO Header of PO 1 but before PO Header of PO 2 !

I thnik the structure requested by converter described in documentation do not fit with my case :

<root>...

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

</nameA>

<nameB>

<value4>value</value4>

</nameB>

</root>

I should have :

<root>

<FH>

<PO>

<POH>...</POH>

<POI>...</POI>

<POI>...</POI>

</PO>

<PO>

<POH>...</POH>

<POI>...</POI>

<POI>...</POI>

</PO>

</FH>

</root>

Thanks very much for your help and opinions

Jean-Charles.

Edited by: Jean-Charles CARRET on Jan 3, 2011 6:12 PM

[stefan_grube]

You can use MessageTransformBean for FCC.

This allows you to have an extra hierarchy level.

You can use a structure like this:

root

- row

- FH

- row

- POH 1

- POI 1

- POI 1

- POI 1

- row

- POH 2

- POI 2

- POI 2

- POI 2

- row

- FF

It is not easy to get the mapping and module configuration, but it works.

[Former Member]

Thank you Stephan for your answer.

Firstly, could you confirm whether the "row" elements under the root tag are on the same level than other elements (POH, POI, FF and FH) or not ?

I just check the both following parts of the help documentation called :

- [Inserting MessageTransformBean in the Module Processor|http://help.sap.com/saphelp_nwpi711/helpdata/en/57/0b2c4142aef623e10000000a155106/frameset.htm]

- Using the dispatcher : Example

For me, it is not clear.

1. Do I need to create an external class (XSLT Library for example) to manipulate my XML data before passing it to the standard Flat File Conversion tool ? (Here the manipulation would be to remove the row XML elements)

2. Where is located the famous "Data" directory in which I must put my xsl file ?

Thanks for clarifications.

Jean-Charles

[stefan_grube]

row should be another hierarchie level:

root - row - POH

The MessageTrasnformBean has a FCC functionality, so you need not use XSLT.

http://wiki.sdn.sap.com/wiki/display/XI/CopyofHowTo...ContentconversionmodulewithJ2EEJMS+adapter

of course, you have to change your data type and adopt the mapping.

Edited by: Stefan Grube on Jan 4, 2011 9:54 AM

[Former Member]

Stephan,

I try to use your structure directly with Receiver File CC content conversion tool and it works.

Thanks for help !

J.C.