Count Number of Entries for SAP Table

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

Count Number of Entries for SAP Table

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

Count Number of Entries for SAP Table

Click the button “Number of Entries”

Count Number of Entries for SAP Table

Then you get the number easily

Count Number of Entries for SAP Table

 

 

 

 

 

Leave a Reply


nine + = 10

Blogroll