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