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


SAP MSQ_FILES table summary

Object Name: MSQ_FILES
Dictionary Type: Structure
Description: Data about operating system files which make up a db


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

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

MSQ_FILES-FILEGRPDEF table field - Default file grp contains objects created w/o defined filegp

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

MSQ_FILES-FGRPRDONLY table field - The file group is read only

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

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

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

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

MSQ_FILES-DEVSIZE table field - The size in MB of the logical device the file resides upon

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

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

MSQ_FILES-FLMAXSZMB table field - True Max file size in MB(-1 means file grows till disk full)

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

MSQ_FILES-FLGRWPCT table field - SQL Server file has growth represented in percentage

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

MSQ_FILES-FLGROWTH table field - Growth size of the SQL Server database file

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

MSQ_FILES-FLGROWMB table field - True file growth in MB

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

MSQ_FILES-FLEXTENTS table field - Total number of extents assigned to a file

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

MSQ_FILES-FLUSDEXTS table field - Total no. of used extents(8 contiguous pgs) assigned to file

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

MSQ_FILES-FILEPRMRY table field - Primary file containing startup information and also data

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

MSQ_FILES-FLDEFDEV table field - file is on default device

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

MSQ_FILES-FLDISKFILE table field - file is a disk file

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

MSQ_FILES-FLLOGDEV table field - file is a log file

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

MSQ_FILES-FLWRITEBU table field - file has been written to since the last backup was done

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

MSQ_FILES-FLCREATEDB table field - file was created with a CREATE DB command

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

MSQ_FILES-FLDBCREATE table field - file created during Database creation

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table