File content conversion

[Former Member]

HI ALL,

I have a file in the following format

Hfield1,Hfield2,....HfieldN ( This is header 1)

Hfield21,Hfield22,....HfieldN ( This is Header2

Dfield11,Dfield12,.....Dfield1N ( This is Detail item of header 1 )

Dfield11,Dfield12,.....Dfield1N ( Second detail item of header 1)

Dfield21,Dfield22,.....Dfield2N ( This is Detail item of header 2 )

Dfield21,Dfield22,.....Dfield2N ( Second detail item of header 2)

Sfiled111,Sfield112,......Sfiled11N ( Subdetail item of 1st detail item of header 1)

Sfiled111,Sfield112,......Sfiled11N ( 2nd Subdetai item of 1st detail item of hdr 1)

Sfiled121,Sfield122,......Sfiled12N ( Subdetail item of 2nd detail item of header 1)

Sfiled121,Sfield122,......Sfiled12N ( 2nd Subdetai item of 2nd detail item of hdr 2

Sfiled211,Sfield212,......Sfiled21N ( Subdetail item of 1st detail item of header 2)

Sfiled211,Sfield212,......Sfiled21N ( 2nd Subdetai item of 1st detail item of hdr 2

Sfiled221,Sfield222,......Sfiled22N ( Subdetail item of 2nd detail item of header 2)

Sfiled221,Sfield222,.....Sfiled22N ( 2nd Subdetai item of 2nd detail item of hdr 2

Basically what i tried to say is i have all my header items in the begining ..followed by all the detail items

for all the header items and followded by all the subdetails items for all the detail items .

This is my relation Header (1) -> (*) Detail (1)> (*) SubDetail

Can i convert that into the following format using FCC .

<Records>

<Header1>

<HField1>.. </HField1>

<HField2>.. </HField2>

<Detail11>

<Dfield11>..</Dfield11>

<Dfield12>..</Dfield12>

<SubDetail111>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail111>

<SubDetail112>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail112>

</Detail11>

<Detail12>

<Dfield21>..</Dfield21>

<Dfield22>..</Dfield22>

<SubDetail121>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail121>

<SubDetail122>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail122>

</Detail12>

</Header1>

<Header2>

<HField1>.. </HField1>

<HField2>.. </HField2>

<Detail21>

<Dfield21>..</Dfield21>

<Dfield12>..</Dfield12>

<SubDetail211>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail211>

<SubDetail212>

<Sfiled111> .. </Sfiled111>

<Sfiled112> .. </Sfiled112>

</SubDetail212>

</Detail21>

<Detail22>

<Dfield21>..</Dfield21>

<Dfield22>..</Dfield22>

<SubDetail221>

<Sfiled221> .. </Sfiled221>

<Sfiled222> .. </Sfiled222>

</SubDetail221>

<SubDetail222>

<Sfiled221> .. </Sfiled221>

<Sfiled222> .. </Sfiled222>

</SubDetail222>

</Detail22>

</Header2>

Please provide solution if any one had performed this kind of conversion.Is there any other thing apart from FCC that we can use to convert this to XMl file

Regards,

Raj

[Former Member]

Hi raj

i have also faced similar problem.Actually u can achieve by FCC if u have more than two hierachie level.

either u have to go for java mapping or achieve that using seeburger adapter

Regards

saurabh

[Former Member]

"Actually u can **** achieve by FCC if u have more than two hierachie level"

may be you missed not in *** place.

And saurabh,

I am interested in your comment

"either u have to go for java mapping or achieve that using seeburger adapter"

how can we get fle structure of hierarchy of more than 2 with Seeburger adapter?what adapter can we use in Seeburger?

thank you.

[santhosh_kumarv]

Hi Raj,

>>Can i convert that into the following format using FCC .

No, Using the FCC only u can convert it to an Single Hierarchies.

[Former Member]

Hi Santosh / Surabh,

So u mean to say i cant Use FCC to get the below structure

<b><Header1></b>

<Detail>

..

..

<SubDetail>

...

...

</SubDetail>

</Detail>

<b></Header1></b>

<b><Header2></b>

<Detail>

..

..

<SubDetail>

...

...

</SubDetail>

</Detail>

<b></Header2></b>

If we have to use Java mapping to convert to the required format , what will be the message format that i will be getting before java mapping .. from the file adapter.

Please help .

Regards,

Raj.

[Shabarish_Nair]

please note that you cannot create heirarchies via FCC. This is a limitation of the file adpater.

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