ABAP statement to find total no. of recs

[Former Member]

Hi,

There is a table with two fields f1 and f2.

f1 is the primary key of the table.

For a particular value of f2 I want to know the total no of records in the above table.

What is the most efficient way to do it.

Please guide me,

Thanks,

CD

[Former Member]

select count * into l_recs from dbtable where f2 = value.

regards,

Advait