Approach for JDBC MultiMapping?

[Former Member]

Hi

Can any one tell me .

My scenrio like this ..n:1...sender having two database tables and target system is BAPI(R/3).Here I should do multimapping without any correlated fields in structure!

Outbound Inbound

-

---

-

---

<Message1> <Bapi>

table1 data

</Message1> </bapi>

<Message2>

table2

<Message2>

Would it be possible?

BPM is the possible solution for this?

Where do i catch exceptions in BPM?

Thanks in Advance...

Reards..Rambarki

[Former Member · Accepted solution]

hey Rambarki,

i'm not sure how u want ure target message to look like. As far as i followed ure query,

these are ure reqmts:

ure source msg's structure:

<message1>

<table1data>

.

.

.

<table1data>

</message1>

<message2>

<table2data>

.

.

.

<table2data>

</message2>

and ure target's structutre:

<Message>

<message1>

(with same structure as source)

</message1>

<message2>

(with same structure as source)

</message2>

</Message>

To achieve this you need not necessarily have related fields(no correlation required).

This can be done by changing the occurrence of your

n-type source's message(Messagetype) in the message mapping from 1-1 to 0-unbounded.

Coming to exceptions..you can catch the exceptions by giving their names in the properties of

the transformation and send steps.

If you still have doubts, explain your query in greater detail and if your problem

has been solved, dont forget to assign points.

regards

sushumna

[Former Member · Accepted solution]

Thanks for sharing ur valuble suggestions..

hoping it could help out resolving my problem..let me try first..

and i have one more question for you....now i have one requirement which will have correlation field in Message1 and Message2. Alternatelyt i have catch exceptions in this scenrio..

ex:

Source structure:

-

---

<Message1>

ReceivedDate

</Message>

<Message2>

ReceivedDate

</Message2>

TargetStructure

-

---

Bapi_Invoice_MT

<Date>

So I should correlate my source Received date field to Target Date field..i have gone through the sap help//but its little bit difficult to understand correlating these fields..so if you have nay idea abt this topic , please send logical steps abt this.

Thank You...Rambarki!

[Former Member]

Hi Rambarki,

For multimapping just change the occurance of the msg type in your mapping design.

Then in CCBPM you need not use correlation hence jus use a dummy correlation else if you don't want to use correlation at all use a synchronous reciever.

In BPM for error handling you can use a step called exeception handler present in IP.

[Former Member]

hi,

- the link below will clearly tell u how to catch exceptions in BPM....it is very clearly explained in this link..

http://e-docs.bea.com/wli/docs70/bpmtutor/ch6.htm

- your problem could be solved using a BPM.