Skip to Content
0

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

Jun 19, 2017 at 06:41 AM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Jun 19, 2017 at 09:17 AM
1

Hi Shravan!

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

Regards, Evgeniy.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you Evgeniy !

Can you provide a sample SQL syntax.

0

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.

0