topic Re: Join SAP tables in Talend in Talend Studio

Join SAP tables in Talend

jingyizou — Tue, 08 Dec 2015 16:01:04 GMT

we have a report requirements which needs join a few sap tables and apply selection criteria on certain tables
I am using tsaptableinput component and tmap for the join. however getting below error message
No roll storage space of length 4841504 available for internal storage. table blocks
New to Talend, wondering how do you typically join sap data in Talend?

Re: Join SAP tables in Talend

Anonymous — Tue, 08 Dec 2015 16:10:28 GMT

As far as I know, you cannot join tables within this component. The component speaks to a RFC API and this API does not allow joining.
I suggest you fetch the data into a database table and join them there.

Re: Join SAP tables in Talend

jingyizou — Tue, 08 Dec 2015 17:43:03 GMT

Thanks! any other Talend component that can do join?

Re: Join SAP tables in Talend

jingyizou — Tue, 08 Dec 2015 19:54:45 GMT

btw, I am not doing join in tsaptableinput, using tmap for the joins. and that doesn't seem to work

Re: Join SAP tables in Talend

Anonymous — Wed, 09 Dec 2015 01:28:06 GMT

A tMap is exactly what you need for a join. If the join does not work, keep in mind the values for the join condition must be exactly the same. This means, take care about necessary trim and lower case the values etc. or in case of numbers take care the data types are equal.

Re: Join SAP tables in Talend

Anonymous — Wed, 09 Dec 2015 11:10:36 GMT

Hi, first you have to find out if the error SAP or Talend related (my wild guess would be that is rather SAP related because I never encountered it with Talend). For that, try only to extract the SAP data using the tSAPInput components involved without joining the data in tMap and if you get the error you'll know that is SAP related.
In generally your approach is the right way if the tSAPInput components used with 'RFC_READ_TABLE' (which I presume you are using) are fast enough to provide you with the requested data in the right time and thus is safe to do an external join with tMap (I've done this way a lot of reporting/syncing executed in batch mode 'off working hours' and it is working very well). However if you need more fast and/or (near) real-time integrations you can try looking on Taland Exchange a component - I'm missing it's name right now - more suitable for SAP side joining, but it is for money. Or if you want to get away for free ( ) you can use tSAPInput with the 'RSAQ_REMOTE_QUERY_CALL' RFC which would allow you to call SAP Queryies and you could do the SAP-side joining in a SAP query. Or you could call any custom made RFC enabled BAPI in which there are embedded joins, but for this, of course, you'd need expertise on BAPI's - SAP Queries are much more easy to make.
Hope it helped.