Receiver side store procedure

[Former Member]

I have a bapi - stored procedure scneario.

Can a bapi request to stored procedure to do some computations and then stored procedure could do computations and then stored procedure response be mapped to bapi response ?

Thanks

[Shabarish_Nair · Accepted solution]

sure it can.

for the stored procedure call refer - http://help.sap.com/saphelp_nw04/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[Former Member]

Hi,

You can use this weblog on how to call a stored procedure in synchronous mode. You can map the response to your bapi.

/people/thorsten.nordholmsbirk/blog/2009/04/23/xml-result-from-jdbc-adapter-stored-procedure

Regards,

---Satish

[Former Member]

This blog describes about a java mapping program for returning from stored procedure in a synchronous way. Do we need a java mapping ?

[Former Member]

Nope.

You dont need java mapping for JDBC Synch scenario.

Graphical mapping should suffice your requirement.

Thanks,

Hetal

[Former Member]

Once response from stored procedure goes vai bapi response to ECc ,ECC has to trigger an IDOC taking into account bapi response values and doing some computation. this will be managed at ECC end ? ( to trigger an idoc based on bapi response). is it achievable at ecc end?

[Former Member]

Hi,

As shah is mentioning you dont need java mapping. you can do with graphical mapping.

But make your response message structrue has response in the end. Like if you see the example his request has data in GetXMLData and his response comes in GetXMLDataresponse. Rest the mapping everything you can do with graphical mapping.

Yes once when you send the data in bapi it can create an idoc. ECC guys should be able to handle this requirement at their end.

Regards,

---Satish