Skip to Content
avatar image
Former Member

JDBC<---->PI7.1<---->ABAPROXY(ECC)

Dear Experts,

I have a scenario from DB system I am given a stored procedure that give me the contents for creating sales orders in SAP ECC

and the sales order number needs to be updated back to the same table where the stored procedure is picking up the data.

for this my approach I designed is JDBC Adapter using Stored procedure and creating Sales orders in ECC using ABAP Proxy

Now my question is the abap proxy code creates Sales orders in ECC system and also in return gets

the Sales order number and i need to pick the sales order number and send to DB.

For information my present XI system is PI 7.1, since Sender JDBC adapter was not supporting synchronous updates,

through reffering some of the blogs, I found out that I need to use the following Modoules

AF_Modules/RequestResponseBean

CallSapAdapter

AF_Modules/ResponseOnewayBean

passThrough true

receiverChannel (Proxy Communication channel for posting Sales orders in ECC system)

receiverService (Receiver ECC system Business system)

So, using the above configurations in the sender JDBC adpater at UPDATE Statement, with the reffering table name and its

relevent column to update sales order numbers in DB system.

Thank You,

KishoreJ.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 12, 2010 at 12:46 PM

    I think you better use two async interfaces.

    The JDBC call creates a sales order via inbound proxy, the inbound proxy calls internally an outbound proxy which provides the order number and a receiver JDBC adapter updates the db table.

    You cannot update the order number in sender channel is the number is not available here.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2010 at 10:08 AM

    Hi,

    Thank you I have resolved by calling the same as guided.

    Thank You,

    KishoreJ

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2010 at 08:22 AM

    Hi,

    Can you please explain me the same scenario a bit more ?

    howmany asynchornous , JDBC ? proxy is asyn or syn ?

    Please.

    Vasudeva

    Add comment
    10|10000 characters needed characters exceeded