CODEWITHSUNDEEP
sql-serverabapsap-data-dictionary
user9695260
user9695260

Reputation: 367

DB tables technical info in SAP Data Dictionary

I was given a task to develop a report that would present the following details (as separate columns in ALV): 1) Name of the DB table (like MSEG, EKPO etc.) 2) Size of the DB table in megabytes 3) Number of records 4) Number of read requests performed on the table 5) Number of write requests performed on the table

There are DB* tables that contain such kind of info. Specifically I am referring to DB6PMHST and DB6HISTBS. When I try to view them via SE11 or SE16, system reports that these tables do not hold any records. I tried all three development, testing and production landscapes. Please may you provide a guidance on what I am doing wrong? Maybe there are some other system tables that would contain the necessary info? P.S. I tried to debug ST04 transaction in order to see the tables from which the report selects data, but wasn't able to find those lines of the source code.

I would deeply appreciate your kind assistance.

P.S.S. Checked the table MSSDBSTATT - it is empty as well (our enterprise uses MS SQL Database)

Upvotes: 0

Views: 1405

Answers (2)

Sandra Rossi
Sandra Rossi

Reputation: 13628

The number of reads and writes on a table is a subject specific to the type of database (MSSQL) -> please tag your question accordingly.

If you get an answer by an MSSQL expert, which says that the data is stored in some MSSQL tables, then you cannot query those tables using "Open SQL" but you may query them using "native SQL" (i.e. EXEC SQL or ADBC for instance).

Upvotes: 0

Binh
Binh

Reputation: 241

Go to SE38 and run this report RSTABLESIZE, enter table ID and see the magic.

RSTABLESIZE

Upvotes: 3

Related Questions