SAP MSSDBSZINF table - MS SQL Server: Database Size Information details in SAP

SAP MSSDBSZINF table summary

Object Name: MSSDBSZINF
Dictionary Type: Structure
Description: MS SQL Server: Database Size Information

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

Details

MSSDBSZINF-DBNAME table field - MS SQL Server: Database name ▼

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSDDBNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSDBSZINF-DBTOTSIZE table field - MS SQL Server database total size ▼

Description: MS SQL Server database total size
Field Name: DBTOTSIZE
Data Element: MSSDBTOTSZ
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 DBTOTSIZE

MSSDBSZINF-DBRESSIZE table field - MS SQL Server database reserved size (in 2K pages) ▼

Description: MS SQL Server database reserved size (in 2K pages)
Field Name: DBRESSIZE
Data Element: MSSDBRESSZ
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 DBRESSIZE

MSSDBSZINF-DBFRESIZE table field - MS SQL Server database free size (in 2K pages) ▼

Description: MS SQL Server database free size (in 2K pages)
Field Name: DBFRESIZE
Data Element: MSSDBFRESZ
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 DBFRESIZE

MSSDBSZINF-DBUNUSIZE table field - MS SQL Server database unused size (2K pages) ▼

Description: MS SQL Server database unused size (2K pages)
Field Name: DBUNUSIZE
Data Element: MSSDBUNUSZ
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 DBUNUSIZE

MSSDBSZINF-TABLENUM table field - MS SQL Server number of tables within the database ▼

Description: MS SQL Server number of tables within the database
Field Name: TABLENUM
Data Element: MSSTABNUM
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 TABLENUM

MSSDBSZINF-TABLESIZE table field - MS SQL Server total size of all tables within DB (in 2k pgs) ▼

Description: MS SQL Server total size of all tables within DB (in 2k pgs)
Field Name: TABLESIZE
Data Element: MSSTABSIZE
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 TABLESIZE

MSSDBSZINF-INDEXNUM table field - MS SQL Server total number of indexes within this database ▼

Description: MS SQL Server total number of indexes within this database
Field Name: INDEXNUM
Data Element: MSSINDNUM
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 INDEXNUM

MSSDBSZINF-INDEXSIZE table field - MS SQL Server total index size within the database (#2K pgs) ▼

Description: MS SQL Server total index size within the database (#2K pgs)
Field Name: INDEXSIZE
Data Element: MSSTOTINSZ
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 INDEXSIZE

MSSDBSZINF-SPNUM table field - MS SQL Server total number of stored procedured within DB ▼

Description: MS SQL Server total number of stored procedured within DB
Field Name: SPNUM
Data Element: MSSSPNUM
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 SPNUM

MSSDBSZINF-SPSIZE table field - MS SQL Server total size of stored procedures (2K pages) ▼

Description: MS SQL Server total size of stored procedures (2K pages)
Field Name: SPSIZE
Data Element: MSSSPSIZE
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 SPSIZE

View list of all SAP tables(S4H/ECC)

Select data from SAP table