SAP /SDF/MSSDBHISTORY table - SQL Server: Database and log size (copy of MSSDBHIST in 620) details in SAP


SAP /SDF/MSSDBHISTORY table summary

Object Name: /SDF/MSSDBHISTORY
Dictionary Type: Structure
Description: SQL Server: Database and log size (copy of MSSDBHIST in 620)


Field list for /SDF/MSSDBHISTORY table on an S/4 SAP system

Details
/SDF/MSSDBHISTORY-DATE table field - Date

Description: Date
Field Name: DATE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE

/SDF/MSSDBHISTORY-TIME table field - Time

Description: Time
Field Name: TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME

/SDF/MSSDBHISTORY-DBNAME table field - The name of the database in SQL Server instance.

Description: The name of the database in SQL Server instance.
Field Name: DBNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

/SDF/MSSDBHISTORY-DBSIZE table field - Database size in MB (data files).

Description: Database size in MB (data files).
Field Name: DBSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSIZE

/SDF/MSSDBHISTORY-DBUSEDSIZE table field - Space (MB) reserved for database objects in database files.

Description: Space (MB) reserved for database objects in database files.
Field Name: DBUSEDSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBUSEDSIZE

/SDF/MSSDBHISTORY-DBFREESIZE table field - Free space in the database in MB (difference size - used).

Description: Free space in the database in MB (difference size - used).
Field Name: DBFREESIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBFREESIZE

/SDF/MSSDBHISTORY-DBUNUSEDSZ table field - Reserved for database objects but not used (in KB).

Description: Reserved for database objects but not used (in KB).
Field Name: DBUNUSEDSZ
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBUNUSEDSZ

/SDF/MSSDBHISTORY-TOTTABNUM table field - Number of user tables in the database.

Description: Number of user tables in the database.
Field Name: TOTTABNUM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTTABNUM

/SDF/MSSDBHISTORY-TOTTABSIZE table field - Data size of all tables (excluding indexes) in KB.

Description: Data size of all tables (excluding indexes) in KB.
Field Name: TOTTABSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTTABSIZE

/SDF/MSSDBHISTORY-TOTINDNUM table field - Number of indexes in the database.

Description: Number of indexes in the database.
Field Name: TOTINDNUM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTINDNUM

/SDF/MSSDBHISTORY-TOTINDSIZE table field - Size of all indexes in the database in KB.

Description: Size of all indexes in the database in KB.
Field Name: TOTINDSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTINDSIZE

/SDF/MSSDBHISTORY-TOTSPNUM table field - Number of stored procedures in database.

Description: Number of stored procedures in database.
Field Name: TOTSPNUM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSPNUM

/SDF/MSSDBHISTORY-TOTSPSIZE table field - reserved field (Size of stored procedures in database - MB).

Description: reserved field (Size of stored procedures in database - MB).
Field Name: TOTSPSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSPSIZE

/SDF/MSSDBHISTORY-LOGSIZE table field - Size of the database transaction log in MB.

Description: Size of the database transaction log in MB.
Field Name: LOGSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGSIZE

/SDF/MSSDBHISTORY-LOGFREE table field - Free space in database transaction log in MB .

Description: Free space in database transaction log in MB .
Field Name: LOGFREE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGFREE

/SDF/MSSDBHISTORY-RESEVERED table field - Reserved size in KB

Description: Reserved size in KB
Field Name: RESEVERED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESEVERED

/SDF/MSSDBHISTORY-UNUSED table field - Unused size in KB

Description: Unused size in KB
Field Name: UNUSED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNUSED


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table