SAP Table MSSDBHIST

MS SQL Server: Database space history

MSSDBHIST (MS SQL Server: Database space history) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MSSDBHIST to other SAP tables.

MSSDBHIST table fields

Field Data element Checktable Datatype Length Decimals
DATE Date DATUM DATS 8 0
TIME Time UZEIT TIMS 6 0
DBNAME Database name MSSDB CHAR 128 0
DB_SIZE Database size in MB MSS_DBSIZE DEC 15 0
DB_ALLOC Allocated space in database in MB MSS_DBALLOC DEC 15 0
LOG_SIZE Log size in MB MSS_LOGSIZE DEC 15 0
LOG_ALLOC Allocated space in log in MB MSS_LOGALLOC DEC 15 0
RESERVED Reserved size in KB MSSRESSIZE DEC 15 0
NUMTABS Number of user tables MSSNUMTABLES INT4 10 0
TABDATA Data size in KB MSSDATASIZE DEC 15 0
NUMINDS Number of indexes of user tables MSSNUMINDEXES INT4 10 0
INDDATA Index size in KB MSSINDEXSIZE DEC 15 0
UNUSED Unused size in KB MSSUNUSEDSIZE DEC 15 0
NUMPROCS Number of stored procedures created in DBI MSSNUMPROCS INT4 10 0