issue in FCC

[Former Member]

Hi

I have a scenario where XMl enters the XI and out put is in the form of flat file.

XML Structure

<Record>

<item1>

<F1>

<a>

<b>

</F1>

</item1>

</Record>

Is it possible to do FCC for this type of Hierarchical structure.

If so,please help me out

[Former Member]

Hi...

If your structure is having more than 3 level hierarchy, then using FCC is not possible. For that you can use Conversion Agent Tool for trasforming more than 3 level heierachy xml to falt file.

Regards,

Leela

[Former Member]

Check this out to know maximum permissible structure for receiver FCC

http://help.sap.com/saphelp_nw70/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

[Former Member]

check the link

https://wiki.sdn.sap.com/wiki/display/XI/BasicFileAdapterContentConversion

Rajesh

[Former Member]

Hi Rajesh..

Sorry

there is another segment inside F1 in the XML structure

XML Structure

<Record>

<item1>

<F1>

<a1>

some fields

</a1>

</F1>

</item1>

</Record>

Help needed

[Former Member]

Hi,

Considering the limitation of hirarchical strcuture for FCC conversion, its good idea to change the strcuture.

For e.g remove the <a1>...</a1> structure outside the <F1> and handle the relation between both structurs within Mapping via Udfs.

For e.g. Make the structure something as below,

<Record>

<item1>

<F1>

Field-1

field-2

field-3

</F1>

<a1> 0--Unbounded

Field-1

field-4

Field5

</a1>

</item1>

</Record>

then with the usage of UDfs you may link the data from <A1> & <F1> structure based on common field field-1 etc.

Thanks

Swarup