How to create mapping for this

[Former Member]

Hi Experts,

Am providing you my spec. details as given below and please help me out how can i create mapping for this.

XML files are passed to the XI via MQ queue for mapping into SAP R/3 IDoc format

XML output containing 2 orders.

They are sorted by OriginalOrderKey, C93 (which in effect also acts as the Group identifier for SAP as this is the SAP order number), then by CompletedDate, C97.

Order 1 has 3 order lines per event (in total 6 sections). Order 2 has 4 order lines per event (in total 8 sections)

Following XML :

<parmReport>

<Report GROUPID="20" GROUPCOUNT="0" C80="3" C81="66" C92="New Order -8775" C93="Ny ordre-8718" C94="697005" C96="3" C97="2008-09-29T23:18:00" C98="66165" C99="CMC" C100="This is CHR 3 location comment" C102="PetersTemplate" C103="93853" C104="RouteKey-339-20080929" C105="PeterTest" C106="PICKUP">

</Report>

<Report GROUPID="20" GROUPCOUNT="0" C80="3" C81="66" C92="New Order -8775" C93="Ny ordre-8718" C94="697009" C96="3" C97="2008-09-29T23:18:00" C98="66164" C99="CMC" C100="This is CHR 3 location comment" C102="PetersTemplate" C103="93853" C104="RouteKey-339-20080929" C105="PeterTest" C106="PICKUP">

</Report>

<Report GROUPID="20" GROUPCOUNT="0" C80="4" C81="67" C82="2008-09-29T23:19:00" C92="New Order -8775" C93="Ny ordre-8719" C94="697005" C96="3" C97="2008-09-29T23:19:00" C98="66165" C99="SMC" C102="PetersTemplate" C103="93853" C104="RouteKey-339-20080929" C105="PeterTest" C106="DROPOFF">

</Report>

<Report GROUPID="20" GROUPCOUNT="0" C80="4" C81="67" C82="2008-09-29T23:19:00" C92="New Order -8775" C93="Ny ordre-8719" C94="697009" C96="3" C97="2008-09-29T23:19:00" C98="66164" C99="SMC" C102="PetersTemplate" C103="93853" C104="RouteKey-339-20080929" C105="PeterTest" C106="DROPOFF">

</Report>

</parmReport>

Split and Matching Criteria :

For each new value in xml tag <C93> a new IDoc must be created.

Within the XML messages two sections will be received per SAP line item xml tag <C98> will contains the link between the u201CPICKUPu201D and u201CDROPOFFu201D which must be match together in the mapping via <C106> for ea. Material number <C94>

Thanks & Regards,

Y.raj.

[Former Member]

Hi Raj

As said above you can create Report with attribute as given in structure.

My suggestion is to use Java mapping as it will be easier to do. Read the XML creating the DT and then sort them in mapping. You can sort the data based on the Groups. C93, C97 and then create target for multimapping. This will help you creating separate messages for each C93, C97.

Now use Graphical mapping to map these separate messages to target IDOC. Again use multimapping so that each C93, C97 can generate IDOC.

Thanks

Gaurav

[Former Member]

Hi,

Create a DT with Root as Report and rest as their Attributes.Once you create source copy target as well to help you out.

Thanks

Prabhakar