SAP MSSDBFILES table - MS SQL Server: Database space history files details in SAP


SAP MSSDBFILES table summary

Object Name: MSSDBFILES
Dictionary Type: Structure
Description: MS SQL Server: Database space history files


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

Details
MSSDBFILES-DATE table field - Date

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

See all SAP tables containing field DATE

MSSDBFILES-TIME table field - Time

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

See all SAP tables containing field TIME

MSSDBFILES-LOGFILENA table field - Logical file name

Description: Logical file name
Field Name: LOGFILENA
Data Element: MSSFILE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGFILENA

MSSDBFILES-PHYFILENA table field - Physical file name (full path) of the database file.

Description: Physical file name (full path) of the database file.
Field Name: PHYFILENA
Data Element: MSQPHYFLNA
Data Type: CHAR
length (Dec): 520(0)
Check table:
Conversion Routine:
Domain Name: CHAR520
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYFILENA

MSSDBFILES-FILEGRPNA table field - Filegroup name

Description: Filegroup name
Field Name: FILEGRPNA
Data Element: MSSFG
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILEGRPNA

MSSDBFILES-DEVFREE table field - Free space left on file system (partition) in MB.

Description: Free space left on file system (partition) in MB.
Field Name: DEVFREE
Data Element: MSQDEVFREE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEVFREE

MSSDBFILES-DBGROWTH table field - File growth step configured in SQL Server.

Description: File growth step configured in SQL Server.
Field Name: DBGROWTH
Data Element: MSSDBGROW
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBGROWTH

MSSDBFILES-FLSIZEMB table field - File size in MB.

Description: File size in MB.
Field Name: FLSIZEMB
Data Element: MSQFLTSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLSIZEMB

MSSDBFILES-USEDSIZEMB table field - Used space in database file (in extents = 64kB or in MB).

Description: Used space in database file (in extents = 64kB or in MB).
Field Name: USEDSIZEMB
Data Element: MSSFLUSED
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USEDSIZEMB

MSSDBFILES-MAX_SIZE table field - File size limit in MB configured in SQL Server.

Description: File size limit in MB configured in SQL Server.
Field Name: MAX_SIZE
Data Element: MSSMAXSIZE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_SIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table