Skip to Content
avatar image
Former Member

XML to flat file conversion using file content conversion in reciever CC

Hi,

Iam working on Idoc to File scenario.

Iam having a problem in the communication channel of reciever.

Iam using File content conversion in Reciever Adapter.

My xml format is asfollows:--

- <Header>

<FILLER1>KTP</FILLER1>

<YEAR_IDOC>YEAR 2006</YEAR_IDOC>

<FILLER2>FIRSTWEEKNUMBER</FILLER2>

<WEEK_IDOC>51</WEEK_IDOC>

<FILLER3>NUMBER WEEKS 26</FILLER3>

<PLANT_CODE>FACTORYM019</PLANT_CODE>

</Header>

- <Record>

<First_material>731000</First_material>

<First_quantity>0000.0</First_quantity>

<First_quantity>0001.9</First_quantity>

<First_quantity>0000.0</First_quantity>

<First_quantity>0000.0</First_quantity>

<First_quantity>0020.0</First_quantity>

<First_quantity>0000.0</First_quantity>

<First_quantity>0000.0</First_quantity>

<First_quantity>0000.0</First_quantity>

<First_quantity>0018.0</First_quantity>

<First_quantity>0000.0</First_quantity>

<Second_material />

<Seond_quantity>000000</Seond_quantity>

<Second_quantity>0011.0</Second_quantity>

<Seond_quantity>000000</Seond_quantity>

<Seond_quantity>000000</Seond_quantity>

<Seond_quantity>000000</Seond_quantity>

<Seond_quantity>000000</Seond_quantity>

<Second_quantity>0049.0</Second_quantity>

<Seond_quantity>000000</Seond_quantity>

<Seond_quantity>000000</Seond_quantity>

<Second_quantity>0067.0</Second_quantity>

<Third_material />

<Third_quantity>000000</Third_quantity>

<Third_quantity>000000</Third_quantity>

<Third_quantity>000000</Third_quantity>

<Third_quantity>0008.0</Third_quantity>

<Third_quantity>000000</Third_quantity>

<Third_quantity>000000</Third_quantity>

</Record>

The file format should be as follows:--

KTP YEAR 2006 FIRSTWEEKNUMBER 51 NUMBER WEEKS 26 FACTORYM019

731000 0000.0 0001.9 0000.0 0000.0 0020.0 0000.0 0000.0 0000.0 0018.0 0000.0

0000.0 0011.0 0000.0 0000.0 0000.0 0000.0 0049.0 0000.0 0000.0 0067.0

0000.0 0000.0 0000.0 0008.0 0000.0 0000.0

Could some one help me in resolving this issue.

Regards

Praveen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 18, 2006 at 11:14 AM

    Hi Praven,

    couldn't you simply modify your target DATA type so it will be easier to handle?

    For example something like:

    <Header>

    ..

    </Header>

    <Record>

    <Material>

    <Number>..</Number>

    <quantity>..</quantity>

    ..

    <quantity>..</quantity>

    </Material>

    In this way file content conversion will be easier (easy)!

    Regards,

    Sergio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2006 at 11:15 AM

    Hi,

    Refer this link on how to do content conversion on receiver side..

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

    Regards,

    Sudheer.

    Add comment
    10|10000 characters needed characters exceeded