Skip to Content
avatar image
Former Member

Picking data from multiple tables from MSSQL server SAP PI/PO

Hi,

Im developing an interface in SAP PO 7.5 to pic customer data from MSSQL database and posit it in SAP

We are sending data using JDBC sender and posting it in SAP using receiver Proxy.

The challenge i'm facing is data should be picked up from multiple tables from MSSQL database

Kindly help with your inputs on what has to be done in this condition.

What values should be given to the filed Query SQL Statement in Integration Builder, communication channel, Processing Tab

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 19, 2017 at 09:17 AM

    Hi Shravan!

    SQL syntax allows you to select data from multiple tables using JOIN and UNION conditions.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi KPMG!

      You can find some tutorials over the internet.

      Select a.field1, a, field2, b.field3, b.field4 from a inner join b on a.field5 = b.field6

      Resultset would contain fields from both tables for rows matching condition "a.field5 = b.field6":

      a.field1,a.field2,b.field3, b.field4

      ...

      Regards, Evgeniy.