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 |