Mapping m*n records

[Former Member]

Hi,

We have a scenario PROXY(ABAP)->XI->JDBC.

The source structure is Partners(occurance n),Line items(occurence n). The target structure is Details(Occurance n).

For "n" number of Partners and "m" number of Line items in source we need m*n(i.e, m multiplied by n) number of records.

How do we realize this in graphical mapping.

[former_member206604]

Hi,

You can try mapping this way

Line Items ---> Details

The content of the Line Item should be the root node, that is the message type. So the target details will occur number of Line Items in the source irrespective of its root node partners. The you can manage mapping the other fields using some of the existing functions like useOneAsMany etc...

I assumed your structure is

Message Type
-- Partner
   -- Line Items

Thanks,

Prakash

[Former Member]

Hi,

Target structure is

Message Type

-

---

Details

[Former Member]

Hi guys,

Any more tips???

[Former Member]

Hi,

As Prakash wrote UseOneAsMany is the best solution for you.

regards,

wojtek

[Former Member]

Hi,

My scenario is Proxy>XI>JDBC.

Please find below the skeleton source and target structures.

MT_SRC

--->Header(1...1)

--->Delv No

--->Partners(1...unbounded)

--->Address

--->Name

--->Lineitem(1...unbounded)

--->Product ID

--->Descp

MT_Target

-

---

>STATEMENT(1...unbounded)

-

---

>ACCESS(1...unbounded)

We need to insert multiple records.

Since partners and Lineitems can be multiple how do we realize this.

Can you provide more details