pyrfc get data from sap( need to your help please )

[smohamedhassan]

Hi Experts,

In the past, I used the library hdbcli to connect sap hana and get data from sap with the below query sql

sql_query = """SELECT TEVEN.LDATE , TEVEN.SATZA , TEVEN.LTIME FROM TEVEN WHERE TEVEN.PERNR = '%s' AND TEVEN.STOKZ <> 'X' AND TEVEN.LDATE >= %s AND TEVEN.LDATE <= %s limit 120 """

but now i use pyrfc to connect sap netwaver 750

I'm using the awesome Python library - PyRFC to connect to an SAP ECC IDES

I am successfully connect with the library and get data as the below

but How to retrieve data through function module (se37) as I used to collect it via the library hdbcli (hana database library )

rfc

sql_query = """SELECT TEVEN.LDATE , TEVEN.SATZA , TEVEN.LTIME FROM TEVEN WHERE TEVEN.PERNR = '%s' AND TEVEN.STOKZ <> 'X' AND TEVEN.LDATE >= %s AND TEVEN.LDATE <= %s limit 120 """