Hi
We have a scenario wherein XI should read data for sales orders from a SQL server DB and then map this information onto an IDOC and post to R3. Now, there is some information needed to fill in some segments of the idoc - that has to be looked up from a lookup table in R3 itself.
One of the ways to do this is use BPM and do a synchronous lookup to R3 ( or a rfc lookup directly from the mapping in XI ) , build the IDOC and then use idoc adapter from XI to post to R3.
Another approach - we were thinking of is use an ABAP proxy - and within the proxy - do the lookup- build the idoc segments and then use MASTER_IDOC_DISTRIBUTE function module to create the idoc ? This way, we will avoid the rfc lookups to R3 from XI.
( Use of idoc inbound user exit to do the lookup is not feasible in our environment )
Any thoughts on whether the second approach can be used and pros and cons on the two approaches ?