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