query SAP table with join

One Star

query SAP table with join

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
Seventeen Stars

Re: query SAP table with join

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).
One Star

Re: query SAP table with join

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
One Star

Re: query SAP table with join

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.