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