Skip to Content
0
Former Member
Aug 30, 2011 at 06:39 AM

Require a Message Mapping for the Following Scenario

17 Views

Hi,

I require a Message mapping for this Logic.

In the Source I have 4 fields and in the Target side, the fields should appear like this.

Source Target

Order-No Header

Segment(Attribute-Node)

Item |->Delivery-Num

Item

Segment(Attribute-Node)

RcvQuantity |->Delivery-Num

|-> Material-Num

|-> Quantity

That means For the Same Order-no if the item matches then RcvQuantity should be added and for this whole 1 IDoc should be created.

Even if the Item matches but the Order-no doesnot match then separate IDoc should be created

Also If the Order-no matches but not item then separate IDoc should be created.

Please tell with what should Segment(Attribute-Node) needs to be mapped.

For example:-

we have

Sorurce :

Order-no Item RcvQuantity

A 1 10

A 2 20

A 1 10

B 2 10

B 1 10

C 1 20

C 1 10

D 3 20

Now Target:

IDoc

|->Header

|->Segment

|->Delivery-Num A

|->Item

|->Segment

|->Material-Num 1

|->Quantity 20

IDoc

|->Header

|->Segment

|->Delivery-Num A

|->Item

|->Segment

|->Material-Num 2

|->Quantity 20

IDoc

|->Header

|->Segment

|->Delivery-Num B

|->Item

|->Segment

|->Material-Num 1

|->Quantity 10

IDoc

|->Header

|->Segment

|->Delivery-Num B

|->Item

|->Segment

|->Material-Num 2

|->Quantity 10

IDoc

|->Header

|->Segment

|->Delivery-Num C

|->Item

|->Segment

|->Material-Num 1

|->Quantity 30

IDoc

|->Header

|->Segment

|->Delivery-Num D

|->Item

|->Segment

|->Material-Num 3

|->Quantity 20

Total of 6-IDoc needs to be created.

Kindly do the needy..

Thanq very much..