Mapping Requirement!

[Former Member]

Hi Guys

Source Interface

row (0..outbound)
  1) Movetype
  2) Batch
  3) OrderId
  4) Ref_Batch1
  5) Ref_Batch2
  6) Ref_Batch3

Target Interface

rfc (0 .. outbound)

1)Movetype

2) Batch

3) OrderId

Here the requirement is Source Interface has one line item.

For Move Type 101 --> Send Movetype / Batch to Batch / OrderId

Now actual requirement comes

If Ref_batch1 or Ref_Batch2 or Ref_Batch3 exists

Target should be --> MoveType - 261 (Hardcode) / Batch -- Ref_Batch1 / Ref_Batch2 / Ref_Batch3) / OrderId.

If Ref_Batch1

Movetype - 261 , Batch -- Ref_Batch1 / OrderId -- OrderId

if Ref_Batch2

Movetype - 261 , Batch -- Ref_Batch2 / OrderId -- OrderId

if Ref_Batch3

Movetype - 261 , Batch -- Ref_Batch3 / OrderId -- OrderId

So for one line item from source of Move type 101 should generate one 101 as normal and based on ref_batch value it should create n number of line items in target with Movetype 261 and batch as Ref_Batch

Regards

Srini

[sunil_singh13]

Hi Srinivas,

I would say you Duplicate the row in the target, and then use two explisite logic.

Like ...101 logic on row(node1)

and ...261 login on row (Node2)

It will simplify your mapping

thanks

Sunil Singh

[Former Member]

Hi Sunil,

Little work with u r inputs worked

Thx

regards

Srini

[siddhesh_pathak4]

Hello,

Try out with this mapping,

While mapping Batch,

If movetype Equals 101 --- Pass batch to Batch

else

Ref_Batch1 - exists - MapWithDefault(wothout space)

Ref_Batch2 - exists - MapWithDefault(wothout space)

Ref_Batch3 - exists - MapWithDefault(wothout space)

|

Concat (Ref_Batch1,Ref_Batch2,Ref_Batch3) - Batch

As we dont have any condition on movement type and orderId mapp directly.

OrderId to OrderId

Movetype ---to ---Movetype

Edited by: Siddhesh Pathak on Mar 19, 2009 6:46 AM