Skip to Content
0
Former Member
Oct 04, 2011 at 12:30 PM

Count No of records in internal table using 4 fields

15 Views

Hi All,

I have an internal table with about 50,000 records. I need to group these (sort) based on 4 fields and then provide the count for each combination of the 4 fields.

For eg, if I have 3 records in the table which have the same values for all the 4 fields - say A,B,C,D, then the count is to be taken as 3 for that combination.

So my output will be

A B C D - COUNT -4 and so on.

I am looking for a efficient technique (good performance) to meet the above requirements given without too many loops ie with Please advise if you have a good method.

Thanks as always!

Liz