About Receiver JDBC adapter

[Former Member]

Hi experts,

I am getting the purchase order(850), so here i have to update this data(header and item) in two data base tables through JDBC, so how the receiver structure is and how to config that?

Regards

Ramesh

[prateek · Accepted solution]

Use two <Statement> tags as shown here and there you may have separate tablenames.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Then you may use multi-mapping to split the data.

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

Regards,

Prateek

[Former Member]

You can create Stored procedure in database, and then in that stored procedure you can update both the tables.

Create all IR objects for Stored procedure and then you need to create just one JDBC Communication channel.

Thanks,

Hetal

[Former Member]

For structure refer this blog..

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

As per my understanding you have to create

1. Two different Data Types (header & item),

2. Two Message Types,

3. Two Message Interface and

4. Only one Message Mapping ([1:N mapping|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3115] [original link is broken] [original link is broken] [original link is broken]😉 and

5. Only one Interface Mapping.

Now in Integration Directory create Two Receiver JDBC Communication Channels (one will post the header data & other one will post the item data) and offcouse two receiver agreements and rest of other things e.g.. RD, ID, SA

Regards,

Sarvesh