Skip to Content
0
Former Member
Mar 20, 2009 at 06:48 AM

count the number of entries of particular type in internal table

334 Views

Hi,

I have an internal table which contains Account number, Company code and Matching items.

The Matching items can have 1, 2 or 0 values.

I just want to how many no of entries in internal table with matching item '2'.

I know that we can put the internal table in a loop and count the no of entries with matching item '2'.

Or Otherwise while retrieving the data from database table we can also count using aggregate functions like COUNT(*).

Apart from this is there any new way because am not suppose to use LOOP or SELECT with Performance Issue reason.

Please advice.