topic Re: query SAP table with join in Talend Studio

query SAP table with join

_AnonymousUser — Fri, 10 Jul 2015 15:13:28 GMT

Hi,
I have to extract data from 2 SAP linked tables.
BAPI function (RFC_READ_TABLE) only read Tables one by one. What is the best way to request SAP with an inner join?
Regards
Francois

Re: query SAP table with join

Anonymous — Sat, 11 Jul 2015 11:33:37 GMT

At first with the new release of Talend ships a BAPI named RFC_Z_READ_TABLE which has no limits for the record length (the current you use has a limit of 512 byte).
Anyway, both BAPIs are not design to allow joins. You can build such join within SAP it self as view and retrieve these data via the BAPI or you can read both tables in separate database tables and joining them in your own database (that would my first choice).

Re: query SAP table with join

_AnonymousUser — Tue, 15 Sep 2015 12:25:18 GMT

Hi Jlolling,
Which version of Talend supports RFC_Z_READ_TABLE? I tried in Talend Open Studio 5.6 for Data Integration and it gives me below error.
Is it available in Talend 6.0 Open Studio?

connected
Exception in component tSAPInput_1
java.lang.RuntimeException: The RFC can't support the function: RFC_Z_READ_TABLE.
at demo.saptest_0_1.saptest.tSAPInput_1Process(saptest.java:618)
at demo.saptest_0_1.saptest.runJobInTOS(saptest.java:1037)
at demo.saptest_0_1.saptest.main(saptest.java:894)
disconnected

Re: query SAP table with join

_AnonymousUser — Fri, 18 Sep 2015 07:43:25 GMT

Hi,
I'm also facing similar issue. Could anyone respond to the same. I tried using Talend 6.0 BD Open Studio and still facing same issue.