Sender File Adapter content conversion problem

[Former Member]

Hi all,

is it possible to do content conversion like this:

Key;Field1;Field2;Field3

PO00H;0482000000;20061102;PL61

PO01I;00010;0A720;Material 1;100.000

PO02D;20061102;100.000;

PO00H;0482000001;20061102;PL63

PO01I;00010;0A730;Material 2;40.000

PO02D;20061102;40.000;

PO01I;00010;0A740;Material 3;140.000

PO02D;20061102;30.000;

PO02D;20061103;110.000;

convert to

<?xml version="1.0" encoding="utf-8" ?> 
<MT_PO>
    <DT_PO>
        <DocumentHeader>
            <PONumber>0482000000</PONumber>
            <PODate>20061102</PODate>
            <CompanyCode>PL61</CompanyCode>
        </DocumentHeader>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A720</MaterialCode>
                <MaterialDescription>Material 1</MaterialDescription>
                <Quantity>100.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>100.000</Quantity>
            </ItemDetail>
        </Item>
    </DT_PO>
    <DT_PO>
        <DocumentHeader>
            <PONumber>0482000001</PONumber>
            <PODate>20061102</PODate>
            <CompanyCode>PL63</CompanyCode>
        </DocumentHeader>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A730</MaterialCode>
                <MaterialDescription>Material 2</MaterialDescription>
                <Quantity>40.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>40.000</Quantity>
            </ItemDetail>
        </Item>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A740</MaterialCode>
                <MaterialDescription>Material 3</MaterialDescription>
                <Quantity>140.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>30.000</Quantity>
            </ItemDetail>
            <ItemDetail>
                <DeliveryDate>20061103</DeliveryDate>
                <Quantity>110.000</Quantity>
            </ItemDetail>
        </Item>
    </DT_PO>
</MT_PO>

[Former Member · Accepted solution]

Ivan,

I fear this is not possible.

You can have

<?xml version="1.0" encoding="utf-8" ?>

<MT_PO>

<DocumentHeader>

<PONumber>0482000000</PONumber>

<PODate>20061102</PODate>

<CompanyCode>PL61</CompanyCode>

</DocumentHeader>

<ItemHeader>

<ItemNumber>00010</ItemNumber>

<MaterialCode>0A720</MaterialCode>

<MaterialDescription>Material 1</MaterialDescription>

<Quantity>100.000</Quantity>

</ItemHeader>

<ItemDetail>

<DeliveryDate>20061102</DeliveryDate>

<Quantity>100.000</Quantity>

</ItemDetail>

</MT_PO>

Multiple <Item header> and multiple <Item details>

Do the content conversion like this and then in mapping, convert it to any structure you need.

Regards,

JaiShankar

[Former Member]

Hi,

As pointed by Jai, do the content conversion to a simple structure then do a second maaping to map to your required complex structure.

If you are comfortable with Java you can go for java mapping also.

Check these blogs:

/people/venkataramanan.parameswaran/blog/2006/12/12/java-mapping-to-handle-flat-files-in-sap-xi

/people/rahul.nawale2/blog/2006/07/18/java-mapping-an-alternate-way-of-reading-a-csv-file

Regards,

P.Venkat