Proxy to JDBC

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

Target structure is

Message Type

-

---

Details

[former_member206604]

Hi Prashant,

Did you try the method I told you in your last post. Do try it and it will work.

Thanks,

Prakash

[Former Member]

Hi,

with ur approach ther will be same number of records as the number of line items in source.

My requirement is if there are 2 partners and 4 line items we need 2*4 = 8 records

[former_member206604]

Hi,

You will have same number of records yes but if you change the context you will have m*n. Right click the source node you will see the Context menu there select the root node that is the message type.

It is like this

Message Type
--Partner
  --LineItem

if you look from Partner/LineItem then it will be only 4 as per ur example. In this case the context is partner.

If you look from MessageType like //LineItem then you will have 2*4. In this case the context is from the root.

Thanks,

Prakash