I need a help to design the scenario using BPM.
I am getting material number, plant and country data from the database ( MDM ) and depends on the country and the plant find the receiver ( out of 7 receiver ). Using the above three fields select the qty and price from the receiver ( Eg. R/3 4.7 ) and upload back to MDM table.
This needs to be done every row ( all the material number ) in the MDM, frequently ( weekly ). I am kind of thinking like trigger the even by BPM and fetch the data from MDM by line by line and by using XPath find out the receiver and get the data from R/3 using select with key fields of above and update into MDM and do commit.
Can anyone please explain the interface involved and the way needs to proceed.
Many thanks for your valuable input and points will be awarded.