Are you still using select Count to count the rows of the database table? Out.

In ABAP, if we want to use code to get the number of records in a database table, the general practice is to use select COUNT.

If you are using the Hana database, there is now a new way to achieve the same goal. The Hana database has a system view named M_tables that contains metadata for the database tables.

A detailed description of this system view is referenced in the SAP Help documentation.

I have written a tool that can be used to query M_tables to obtain a series of records of the number of database tables and occupy the storage space.

You can get the source code of my tool through this link.
To get more original Jerry's technical articles, please follow the public number "Wang Zixi" or scan the QR code below:

Are you still using select Count to count the rows of the database table? Out.