Need wiki or blog for this scenarios ...please

Former Member · ‎04-03-2007

Anybody done this before?....

Using BPM i need to query database and get itemid of a table.

Pass those itemid to a sql join to get more details about the item.

Then output need to send to matmas05 using idoc adapter....

need help. Please help me.

Former Member · ‎04-03-2007

Hi,

Why BPM to get only for itemid.is it your requirement??

I mean with out BPM , we can do it in mapping with lookup DBlookup for databse related data, RFC lookup for SAP related data.

here you need DB lookup

DB lookup - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

or

even if you want to use BPM , you can use it , in send step send the request to SQL and get the response like JDBC responce

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

and the response get it and merge with transformation step (intern use interface mapping -- message mapping)

and do the rest of business process..

i hope it is clear..

Regards

Chilla

MichalKrawczyk · ‎04-03-2007

Hi,

all you need is XI FAQ : document section

there are jdbc blogs (that will allow you to do jdbc)

there are BPM blogs - for a BPM

there are IDOC blogs - to do the IDOC part

you just need to combine them and your scenario will be done:)

Regards,

michal

-

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

Re: SAP BW - Master Data Delta Load