Split and Matching Criteria for Mapping

[Former Member]

Hi,

The following XML is the structure for the sender system:

<?xml version="1.0"?>

<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>

Here the Sender system : JMS and Receiver : IDOC

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>

Please suggest me here how can i do this above

Thanks & Regards,

Y.Raj.

Edited by: YeswanthRaj Kumar on Nov 11, 2008 12:55 PM

[Former Member]

Hi XI Experts,

I need more solutions on this as i need to finish it by priority basis.

Kindly help me out on this.

Thanks & Regards,

Y.Raj.

[dharamveer_gaur2]

Hi

find the below links for the message mapping.

Message Mapping Simplified - Part I

/people/sravya.talanki2/blog/2005/12/08/message-mapping-simplified-150-part-ii

Message Mapping Simplified Part II

[prateek]

Thats an unusual structure. Here everything is "attribute" and not the value of the field "Report". Are you sure about the xml structure. Here there is no data as such.

In any case, u will have to use multimapping using BPM as u have to split the data into multiple data. If provided sender structure is final, then I would suggest to use java mapping to split the files as it would be most suitable to read the attributes.

Regards,

Prateek

[Former Member]

Hi Prateek,

yes, the structure for sender is Final and could you please let me know the procedure for

1) multimapping using BPM or

2) Java mapping to split the files

It would be helpful to me if you can explain more detailed and any blogs would be helpful for reference.

Thanks & Regards,

Y.Raj.

[prateek]

a) multimapping using BPM

b) Java mapping to split the files

That would be a difficult code to get readily. Hey, was just thinking, u may try Message mapping directly using standard node functions. As attributes in message mappings are available separately for mapping, message mapping could also be used.

Regards,

Prateek

[Former Member]

Hi Prateek,

This is really sounds good...if really i can continue with message mapping.

As, i need to finish this by priority basis ...could you please give me on more suggestions using Message Mapping and also the structure of the data type...(for eg., fields should be defined by attributes/elements).

Thanks & Regards,

Y.Raj.

Edited by: YeswanthRaj Kumar on Nov 11, 2008 1:29 PM

[Former Member]

Hi,

Can i expect more suggestions from you & all..

Thanks & Regards,

Y.Raj.