SAP MSQDBDETAS table - MS SQL server database space statistics details in SAP

SAP MSQDBDETAS table summary

Object Name: MSQDBDETAS
Dictionary Type: Structure
Description: MS SQL server database space statistics

Field list for MSQDBDETAS table on an S/4 SAP system

Details

MSQDBDETAS-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: MSQDBNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSQDBDETAS-DBSIZE table field - Database size in MB (data files). ▼

Description: Database size in MB (data files).
Field Name: DBSIZE
Data Element: MSQDBSIZE
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

MSQDBDETAS-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: MSQDBRESSZ
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

MSQDBDETAS-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: MSQDBFRESZ
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBFREESIZE

MSQDBDETAS-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: MSQDBUNUSZ
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

MSQDBDETAS-TOTTABNUM table field - Number of user tables in the database. ▼

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

See all SAP tables containing field TOTTABNUM

MSQDBDETAS-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: MSQTOTTBSZ
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

MSQDBDETAS-TOTINDNUM table field - Number of indexes in the database. ▼

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

See all SAP tables containing field TOTINDNUM

MSQDBDETAS-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: MSQTOTINSZ
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

MSQDBDETAS-TOTSPNUM table field - Number of stored procedures in database. ▼

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

See all SAP tables containing field TOTSPNUM

MSQDBDETAS-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: MSQTOTSPSZ
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSPSIZE

View list of all SAP tables(S4H/ECC)

Select data from SAP table