topic Query SAP table with join (server side) in Talend Studio

Query SAP table with join (server side)

Anonymous — Fri, 14 Jun 2019 13:37:32 GMT

Hi,
I have to extract data from a SAP tables, joined with another one to filter the result (on the Sap side)

I'm using the component tSapTableInput, but is limited to one Sap table (no free form query)

What is the best way to get SAP table with join?

Thanks

Regards

Re: Query SAP table with join (server side)

Anonymous — Wed, 19 Jun 2019 10:36:55 GMT

Hello,

You could try to join these data retrieved from 2 or more tSAPInput components via tMap component, just that lookup will get called on every record/row processes. Let us know if it works.

Best regards

Sabrina