SAP MSQ_FILES table - Data about operating system files which make up a db details in SAP

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

Description: Default file grp contains objects created w/o defined filegp
Field Name: FILEGRPDEF
Data Element: MSQFLGRPDF
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 FILEGRPDEF

Description: The file group is read only
Field Name: FGRPRDONLY
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 FGRPRDONLY

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

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

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

Description: The size in MB of the logical device the file resides upon
Field Name: DEVSIZE
Data Element: MSQDEVSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEVSIZE

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

Description: True Max file size in MB(-1 means file grows till disk full)
Field Name: FLMAXSZMB
Data Element: MSQFLTMXSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLMAXSZMB

Description: SQL Server file has growth represented in percentage
Field Name: FLGRWPCT
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 FLGRWPCT

Description: Growth size of the SQL Server database file
Field Name: FLGROWTH
Data Element: MSQFLGROW
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLGROWTH

Description: True file growth in MB
Field Name: FLGROWMB
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 FLGROWMB

Description: Total number of extents assigned to a file
Field Name: FLEXTENTS
Data Element: MSQFLEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLEXTENTS

Description: Total no. of used extents(8 contiguous pgs) assigned to file
Field Name: FLUSDEXTS
Data Element: MSQFLUEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLUSDEXTS

Description: Primary file containing startup information and also data
Field Name: FILEPRMRY
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 FILEPRMRY

Description: file is on default device
Field Name: FLDEFDEV
Data Element: MSQFLDFDEV
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 FLDEFDEV

Description: file is a disk file
Field Name: FLDISKFILE
Data Element: MSQFLDSKFL
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 FLDISKFILE

Description: file is a log file
Field Name: FLLOGDEV
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 FLLOGDEV

Description: file has been written to since the last backup was done
Field Name: FLWRITEBU
Data Element: MSQFLWRTBU
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 FLWRITEBU

Description: file was created with a CREATE DB command
Field Name: FLCREATEDB
Data Element: MSQFLCREDB
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 FLCREATEDB

Description: file created during Database creation
Field Name: FLDBCREATE
Data Element: MSQFLDBCRE
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 FLDBCREATE