how can i know the numbers of records in a DB table

[Former Member]

Hi,

I need something like describe for itab but for the db tables. Is there some easy way?

Thanks in advance

[Former Member]

Hi,

Use SELECT COUNT(*)..... Syntax.

Go through this link as well

Regards,

Satish

Message was edited by:

Satish Panakala

[Former Member]

<b>sy-tabix</b> will give you the number of records in the table.

Regards

Aneesh.

[amit_khare]

Loop in IntTab and you get the count in sy-tabix.

or

check the keyword DESCRIBE TABLE IntTab LINES lin.

Regards,

Amit

Reward all helpful replies.

[Former Member]

in SE16, or SE16N, there is a "Number of entries" button. Just press that.

Rob

[Former Member]

Hi Mario ,

We can use one system variable<b> SY-DBCNT</b> ,

this system variable used for determine the total no of records in the table.but it's should write into <b>after select ... and endselect</b>. because if u write this variable within select ... and endselect ,it will return current record number.

Regards,

Vijay