on 11-01-2007 11:22 AM
Hi Experts,
I get an mapping error on one of my interfaces. Below is the payload from the message:
<?xml version="1.0" encoding="utf-8"?>
<ns:MT_MRO_INVOICE xmlns:ns="http://carlsberg.com/aurora/MRO/invoice">
<ns:MT_MRO_INVOICE xmlns:ns="http://carlsberg.com/aurora/MRO/invoice">
<Header>
<Tag>01</Tag>
<ArchiveId>LE02132</ArchiveId>
<Date>071031</Date>
<Time>154906</Time>
<NumRecs>00005</NumRecs>
<Partnr>MRO</Partnr>
<SapInv>-SAP Invoice Extract</SapInv>
</Header>
<Head>
<Tag>05</Tag>
<SUPNR>A982713</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>4734713</PONR>
<SERNR>311007</SERNR>
<INVDAT>071031</INVDAT>
<GAMOUNT>000000000209002+</GAMOUNT>
<VAT>000000000031128+</VAT>
<TERMCD></TERMCD>
<DUEDAT></DUEDAT>
<MADAT>071031</MADAT>
<VATCDE>STD</VATCDE>
<REFNR>RIVER311007A</REFNR>
<OUTLET></OUTLET>
<BATNR>00311007</BATNR>
</Head>
<Item>
<Tag>06</Tag>
<SUPNR>A982713</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0001</INVNR>
<POLNR>0001</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMMECHAH</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000010000+</QNTY>
<UPRICE>000000177874000+</UPRICE>
</Item>
</ns:MT_MRO_INVOICE>
<ns:MT_MRO_INVOICE xmlns:ns="http://carlsberg.com/aurora/MRO/invoice">
<Head>
<Tag>05</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>4734714</PONR>
<SERNR>311007</SERNR>
<INVDAT>071031</INVDAT>
<GAMOUNT>000000000976895+</GAMOUNT>
<VAT>000000000145495+</VAT>
<TERMCD></TERMCD>
<DUEDAT></DUEDAT>
<MADAT>071031</MADAT>
<VATCDE>STD</VATCDE>
<REFNR>RIVER311007B</REFNR>
<OUTLET></OUTLET>
<BATNR>00311007</BATNR>
</Head>
<Item>
<Tag>06</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0001</INVNR>
<POLNR>0001</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMINSTDN</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000100000+</QNTY>
<UPRICE>000000054390000+</UPRICE>
</Item>
<Item>
<Tag>06</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0002</INVNR>
<POLNR>0002</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMINSTAV</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000050000+</QNTY>
<UPRICE>000000057500000+</UPRICE>
</Item>
</ns:MT_MRO_INVOICE>
</ns:MT_MRO_INVOICE>
I have tried copying the payload to IR and test it but it fails with the fault:
12:18:48 Start of test
Call method execute of the application Java mapping com.sap.xi.tf._MM_MRO_INVOICE_
Cannot produce target element /ns1:FIDCCP01/IDOC. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
12:18:48 End of test
If I remove all but the outer namespace so that the payload looks like:
<?xml version="1.0" encoding="utf-8"?>
<ns:MT_MRO_INVOICE xmlns:ns="http://carlsberg.com/aurora/MRO/invoice">
<Header>
<Tag>01</Tag>
<ArchiveId>LE02132</ArchiveId>
<Date>071031</Date>
<Time>154906</Time>
<NumRecs>00005</NumRecs>
<Partnr>MRO</Partnr>
<SapInv>-SAP Invoice Extract</SapInv>
</Header>
<Head>
<Tag>05</Tag>
<SUPNR>A982713</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>4734713</PONR>
<SERNR>311007</SERNR>
<INVDAT>071031</INVDAT>
<GAMOUNT>000000000209002+</GAMOUNT>
<VAT>000000000031128+</VAT>
<TERMCD></TERMCD>
<DUEDAT></DUEDAT>
<MADAT>071031</MADAT>
<VATCDE>STD</VATCDE>
<REFNR>RIVER311007A</REFNR>
<OUTLET></OUTLET>
<BATNR>00311007</BATNR>
</Head>
<Item>
<Tag>06</Tag>
<SUPNR>A982713</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0001</INVNR>
<POLNR>0001</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMMECHAH</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000010000+</QNTY>
<UPRICE>000000177874000+</UPRICE>
</Item>
<Head>
<Tag>05</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>4734714</PONR>
<SERNR>311007</SERNR>
<INVDAT>071031</INVDAT>
<GAMOUNT>000000000976895+</GAMOUNT>
<VAT>000000000145495+</VAT>
<TERMCD></TERMCD>
<DUEDAT></DUEDAT>
<MADAT>071031</MADAT>
<VATCDE>STD</VATCDE>
<REFNR>RIVER311007B</REFNR>
<OUTLET></OUTLET>
<BATNR>00311007</BATNR>
</Head>
<Item>
<Tag>06</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0001</INVNR>
<POLNR>0001</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMINSTDN</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000100000+</QNTY>
<UPRICE>000000054390000+</UPRICE>
</Item>
<Item>
<Tag>06</Tag>
<SUPNR>E980233</SUPNR>
<LEDCO>PP</LEDCO>
<PONR>311007</PONR>
<INVNR>0002</INVNR>
<POLNR>0002</POLNR>
<COSTC>PP5362</COSTC>
<EXPCDE>27262</EXPCDE>
<MATKEY>MRO ITEMINSTAV</MATKEY>
<UOM></UOM>
<DESC></DESC>
<QNTY>000000000050000+</QNTY>
<UPRICE>000000057500000+</UPRICE>
</Item>
</ns:MT_MRO_INVOICE>
It works, but can any one tell me why it puts the namespaces into the message or how I can remove the namespaces so that my message will go trought?
Thanks in advanced
Hi Jesper,
Could you please let us know how you get the payload with the extra namespaces?
Is there another mapping that executes before you continue with this mapping?
If yes, please check the output of the previous mapping.
There might be a mapping error there, which generates such erroneous payload.
Regards,
Smitha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jesper,
The recordset name is usually, a tag that is a parent for the tags Header,Details,Head,Item.
Can you please try inserting a tag above the nodes you have mentioned.(This is an optional parameter and can be left blank too. This way no changes to the message type is required.)
Also, the document name is MT_MRO_INVOICE.
Regards,
Smitha.
Hi Jesper,
Well this couldn't be a best solution for your problem, but still you can try it.
Do one thing, <b>delete the namespace under XML Namespace from your message type.</b>
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.