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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog