Skip to Content
0
Former Member
Mar 07, 2009 at 11:16 PM

IDoc to JDBC Scenario

39 Views

Hi,

I have a scenario where in I have to collect IDoc and process it and put a single record to the DB using JDBC Adapter.

Scenario,

The IDoc is of Sales Order Lines , Each Sales order lines is sent as an Idoc to XI system.In XI I have to collect the IDocs and process it.Processing Logic - For a given Matrial I have have check the SO's and sum all the Qty for that particular material.

Eg

Say ,I get two SO Idocs as given below,

Sales Order MaterialNumber Qty

10001 1000 100

10002 1000 200

So , I have to group them by MaterNumber and add the Qty and insert a single record to the DB

So in the DB , the following line would be inserted.

Material Number SalesOrderQty

1000 300

Could you let me know whether this is possible without BPM ,else use of BPM is mandtory.

An Insight as how to go about would be appriceated.

Thanks,

Venu