topic Re: Count rows in table with condition using build in BAPI in Application Development and Automation Discussions

Count rows in table with condition using build in BAPI

daphneo — Wed, 01 Sep 2021 09:18:48 GMT

Is it possible to count the number of rows in a filtered table using a build-in FM or BAPI call?

EM_GET_NUMBER_OF_ENTRIES seems to only count total rows in table, but I would like to count, for example, the records in USR02 where GLTGV > '2020-01-01'.

It is possible when working in SE16n by pressing F7, and I'm hoping to do the same but by calling a standard FM or BAPI (without downloading all rows in the table)

Re: Count rows in table with condition using build in BAPI

ashiqali_ratnani — Wed, 01 Sep 2021 13:36:17 GMT

The FM you listed above itself uses a Select Count statement.

Since you need to have a custom filter condition, you will mostly have to write your own Select Count query to get the required count.

Re: Count rows in table with condition using build in BAPI

Sandra_Rossi — Wed, 01 Sep 2021 13:55:28 GMT

Can't you use SQL?

SELECT COUNT(*) FROM USR02 WHERE GLTGV > '20200101' INTO @DATA(counter).

Re: Count rows in table with condition using build in BAPI

daphneo — Wed, 01 Sep 2021 14:13:11 GMT

I need to use a RFC Enabled BAPI or FM as the call will come from an external system. I.e. can't do ABAP. Thanks!