SAP MSSFILES table - MS SQL Server: Database File List details in SAP


SAP MSSFILES table summary

Object Name: MSSFILES
Dictionary Type: Structure
Description: MS SQL Server: Database File List


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

Details
MSSFILES-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

MSSFILES-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

MSSFILES-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

MSSFILES-FILEID table field - FILE ID of DB file for SQL Server

Description: FILE ID of DB file for SQL Server
Field Name: FILEID
Data Element: MSSFILEID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILEID

MSSFILES-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

MSSFILES-ALLOCMB table field - Allocated space in a DB file in MB

Description: Allocated space in a DB file in MB
Field Name: ALLOCMB
Data Element: MSSALLOCFILEMB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALLOCMB

MSSFILES-FREEPCT table field - Free percentage of space in a SQL Server file

Description: Free percentage of space in a SQL Server file
Field Name: FREEPCT
Data Element: MSSFREEPCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREEPCT

MSSFILES-GROWTH table field - File growth step configured in SQL Server.

Description: File growth step configured in SQL Server.
Field Name: GROWTH
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 GROWTH

MSSFILES-GROWTHMB table field - True file growth in MB

Description: True file growth in MB
Field Name: GROWTHMB
Data Element: MSQFLTGROW
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GROWTHMB

MSSFILES-FLMAXSIZE table field - File size limit in MB configured in SQL Server.

Description: File size limit in MB configured in SQL Server.
Field Name: FLMAXSIZE
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 FLMAXSIZE

MSSFILES-PRIMARYFILE table field - Primary file containing startup information and also data

Description: Primary file containing startup information and also data
Field Name: PRIMARYFILE
Data Element: MSQFLPRIM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIMARYFILE

MSSFILES-READONLY table field - The file group is read only

Description: The file group is read only
Field Name: READONLY
Data Element: MSQFLGRPRO
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR001
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READONLY

MSSFILES-LOGDEV table field - file is a log file

Description: file is a log file
Field Name: LOGDEV
Data Element: MSQFLLGDEV
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR001
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGDEV

MSSFILES-GRWTHPCT table field - SQL Server file has growth represented in percentage

Description: SQL Server file has growth represented in percentage
Field Name: GRWTHPCT
Data Element: MSQFLGRPCT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRWTHPCT

MSSFILES-DEVFREEMB table field - Free space left on file system (partition) in MB.

Description: Free space left on file system (partition) in MB.
Field Name: DEVFREEMB
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 DEVFREEMB

MSSFILES-ALERTSTATUS table field - ALERT Status , 'R','Y','G' - red,yellow,green

Description: ALERT Status , 'R','Y','G' - red,yellow,green
Field Name: ALERTSTATUS
Data Element: MSSALERTSTATUS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALERTSTATUS

MSSFILES-FILEMSG table field - MSS Alert Text as seen in RZ20

Description: MSS Alert Text as seen in RZ20
Field Name: FILEMSG
Data Element: MSSALERTTXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILEMSG


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table