Sap OData $count not return correct number of rows

[zhanyu2023]

Sap OData $count API should return number of all rows in sap table. I tried with $count api but get wrong number of count.

I have a big sap table with 23.803.107 rows of data. When I call api to $count, only 50339 returned instead of 23.803.107.

I look into the odqmon and find below img. my table seems dived into 473 unit, 472*50339+43099=23.803.107.

So is there any problem with $count api? how can I get total number of rows(23.803.107) instead of single unit(50339).

[junwu]

what is count api? never heard....

[zhanyu2023]

jun.wu5 , recently we follow SAP public doc to use OData as protocol to extract data from SAP server side. Here we want to get the total row number, but $count does not work as expect when it is big SAP table. Could you guide us how to solve the issue?

/sap/opu/odata/sap/ZSBOOK_ODP_SRV/FactsOfZSBOOKODP/$count

Thanks for your time and help.