If you want to get count number of your database table then you can use two different way for it…one is from oracle environment and the other one is SAP transaction SE16…

If you want to use sql command then use the following syntax ;

SQL>select count(*) from <TABLE_NAME>

Let’s check an example for table USR02 with schema SAPSR3

If you want to get this info from SAP system then you should follow the steps.

Go to –> SE16

For an example write down the table USR02 and ENTER

Click the button “Number of Entries”

Then you get the number easily