Reporting API
In the current version, how much data is returned by the OData service can be restricted to avoid timeouts.
The following new parameters are available for this:
GJAHR (fiscal year)
BUKRS (company code)
BUDAT (booking date)
The following operators can be used:
()and(and)or(or)EQ(equal)LT(less than or equal to)GE(greater than or equal to)
The SAP-specific operator BT (between) must be implemented with GE and LE (see example). The date must be formulated in the format from the SAP database (YYYYMMDD, e.g., 20231231).
RFC variant for SAP ERP systems (not S/4HANA)
http[s]://<host>[:<port>]/sap/opu/odata/WMD/XF_BI_REP_RFC_SRV/mainSet?$expand=NAVSTAT,NAVSTATI&$filter=target eq '<rfc>' and bukrs eq '1000' and gjahr eq '2023' and (budat ge '20230101' and budat le '20231231')
S/4HANA variant without RFC
http[s]://<host>[:<port>]/sap/opu/odata/WMD/XF_BI_REP_SRV/mainSet?$expand=NAVSTAT,NAVSTATI&$filter=bukrs eq '1000' and gjahr eq '2023' and (budat ge '20230101' and budat le '20231231')