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.