Skip to Content
avatar image
Former Member

How to Read Master-detail tables with XI?????

Hi ,

I have to develop an interface to send sales orders (header and details), how can i configure the JDBC sender adapter to do this???? and the receiver????

thank's a lot , any help would be great,

regards

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 28, 2007 at 06:33 PM

    Hey

    >>I have to develop an interface to send sales orders (header and details), how can i configure the JDBC sender adapter to do this???? and the receiver????

    if you want to read these details from R/3,you need to use IDOC adapter(or proxies or RFC).JDBC can't be used to integrate R/3

    use ORDERS05 IDOC for this

    Thanx

    Ahmad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2007 at 06:51 PM

    sorry, i wanted to say that i need integrate two legacy systems, i mean a database Oracle with a SQl Server, but in the legacies i have the data in two tables (heeader -detail) and i need to transfers to ther database (header-detail),

    the scenario is JDBC - JDBC

    thank's

    Add comment
    10|10000 characters needed characters exceeded

    • Sri S Justin Santhanam

      can we connect directly to sap db like we connect to other databases?then how data consistency will be maintained in SAP DB?I am thinking like get data from or to sap by idoc,rfc,proxies.

      babu

  • avatar image
    Former Member
    Jun 28, 2007 at 07:04 PM

    Morales,

    If you want you pull the data from R3 database using JDBC sender adapter you can do it. Its just like pulling the data from any database. But I think it is not possible to post the data using JDBC.

    Also I would recommend to use IDOCs to send data to XI instead of JDBC adapter.

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2007 at 11:19 PM

    i reviewed the weblogs attached but is not my case, somebody knows how can i do this config ???, i need to send information that exist in two tables (header -items)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2007 at 11:44 PM

    Something wrong. Sorry about this.

    Add comment
    10|10000 characters needed characters exceeded