search

SAP / PyRFC

Asynchronous, non-blocking SAP NW RFC SDK bindings for Python
http://sap.github.io/PyRFC
Apache License 2.0
515 stars 141 forks source link

Enhance Query Engine #367

Open tudorian opened 6 months ago

tudorian commented 6 months ago

Hello,

It is possible to use another SAP table as a reference when extraction data from the current tables

Eg: SELECT * from MARC INNER JOIN MARA ON MARC~MATNR = MARA~MATNR WHERE MARA~MTART = 'ABC'

Thanks,

Tudor

amarvin commented 1 day ago

I don't think you can do joins using pyrfc, unless you call an RFC that does the tables joins on the SAP-side. Rather than doing the join on the SAP-side, you could do query the data from the two tables separately and then inner join them on your client-side.

Note that where conditions are a bit tough to use with the basic pyrfc. I developed https://github.com/amarvin/pyrfc-read to make this easier!