N to 1 multimapping scenario

[Former Member]

Hi experts,

I have done N to 1 multimapping scenario following the below link..

http://www.saptechnical.com/Tutorials/XI/BPM/Fork1.htm

In this link it is done for occurrence 1 in message mapping.If my sender files have multiples records(occurrence 0..unbound).

What configurational changes I hv to make ??

Thanks in advance

[Former Member]

Dear Danish

By change of occurrance in source side, what is is that we are trying to achive

Do you want the target file also to have that field repeated as it is in source files?

Please clarify

Sourabh

[Former Member]

Hi

Suppose in both sender file I have mutiple records.Lets say,

File1: <ns1:mt_input1 xmlns:ns1="http://www.sandbox/xi/testgd">

<Name>abc</Name>

<Place>mumbai</Place>

<ID>1</ID>

</ns1:mt_input1>

<ns1:mt_input1 xmlns:ns1="http://www.sandbox/xi/testgd">

<Name>xyz</Name>

<Place>delhi</Place>

<ID>2</ID>

</ns1:mt_input1>

File2 : <ns1:mt_input2 xmlns:ns1="http://www.sandbox/xi/testgd">

<Company>qwe</Company>

<DOJ>121212</DOJ>

<ID>1</ID>

</ns1:mt_input2>

<ns1:mt_input2 xmlns:ns1="http://www.sandbox/xi/testgd">

<Company>rty</Company>

<DOJ>141414</DOJ>

<ID>2</ID>

</ns1:mt_input2>

Based on that i want to merge both the records of sender files in target file based on ID(which has two values 1 and 2)

target file: abc, mumbai, qwe, 121212, 1

xyz, delhi, rty,141414,2

It is working if I have only one record in files.

Please suggest how can i do it for multiple records.

[Former Member]

Hi,

Specify 0..unbounded occurance in message mapping for Message1 and Message2 under signature tab. Also in the BPM, enable the multiline property for both the containers File1 and File2( the two receive steps in fork). Hope this will work.

[Former Member]

Hi malini,

Multiline will work if same records are coming in different files but my requirement is, I have multiple records in same files.And those multiple records have to merge in one target file.

File1: <?xml version="1.0" encoding=" "?>

<ns1:mt_input1 xmlns:ns1="http://www.abc">

<Record>

<Name>abc</Name>

<Place>Mumbai</Place>

<ID>1</ID>

</Record>

<Record>

<Name>xyz</Name>

<Place>delhi</Place>

<ID>2</ID>

</Record>

</ns1:mt_input1>

File2 :

<?xml version="1.0" encoding=" "?>

<ns1:mt_input2 xmlns:ns1="http://www.abc">

<JobDetails>

<Company>qwe</Company>

<DOJ>121212</DOJ>

<ID>1</ID>

</JobDetails>

<JobDetails>

<Company>rty</Company>

<DOJ>141414</DOJ>

<ID>2</ID>

</JobDetails>

</ns1:mt_input2>

Any other approach??

Thanks

[Former Member]

Hi,

Pls Check the below thread

http://forums.sdn.sap.com/thread.jspa?messageID=7465949#7465949

The configuration which you have should work. Correlation which you have defined on ID will combine similar records. Also have you changed the occurance of the field record to (0..unbounded) in the target structure.

[Former Member]

Hi malini,

What I understood from your suggestion is :

folow the link : http://www.saptechnical.com/Tutorials/XI/BPM/Fork1.htm

But some configurational changes has to make:

sender and receiver message types should be 0..unbound occurence and all configuration should be same as per the above mentioned link.

Please revert if I am wrong.

Thanks

[Former Member]

Can you please give the target structure??

[Former Member]

Please dont make any changes in ur config. Please check if the below is the case.

If the input is as below

File1: <?xml version="1.0" encoding=" "?>

<ns1:mt_input1 xmlns:ns1="http://www.abc">

<Record>

<Name>abc</Name>

<Place>Mumbai</Place>

<ID>1</ID>

</Record>

<Record>

<Name>xyz</Name>

<Place>delhi</Place>

<ID>2</ID>

</Record>

</ns1:mt_input1>

File2 :

<?xml version="1.0" encoding=" "?>

<ns1:mt_input2 xmlns:ns1="http://www.abc">

<JobDetails>

<Company>qwe</Company>

<DOJ>121212</DOJ>

<ID>1</ID>

</JobDetails>

<JobDetails>

<Company>rty</Company>

<DOJ>141414</DOJ>

<ID>2</ID>

</JobDetails>

</ns1:mt_input2>

if the target structure is as below

Record(0..unbounded)

--ID

--Name

--Place

--Company

--Doj

Do the below mapping changes

Map Id--->Record and change the context of Id to Messages

[Former Member]

Target structure is:

mt_output(1) 1st level

Record(0..unbound) 2nd level

Name(1) 3rd level

Place(1) "

Company(1) "

DOJ(1) "

ID(1) "

[Former Member]

Hi

I have done as you suggested but, its giving me 'Permanent error in BPE inbound processing' (stopping in queue as sysfail)

Can you suggest my what can be the possible resolution to it.

thanks