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 | Possible values |
|---|---|---|---|---|---|---|
|
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 |