Filtering the data by Date column using PyRFC with RFC_READ_TABLE

Question

I managed to connect to SAP ABAP via Python, using PyRFC and RFC_READ_TABLE.

I am trying to figure how to querying a table by a Date column using the parameter OPTIONS.

I know the query should be the same syntax as in C# RFC, but I didn't find anything about filter by interval (bigger then / smaller then).

For example in SQL I can use:

where date > 2022.3.3

Thank you.

Answer 1

You can put below statement into OPTIONS:

DATE GT '20220303'

• GE: Greater or equal
• LT: Less then
• LE: Less or equal