SAP MSQSYSDEV table - MS SQL server dump devices (as from sysdevices) details in SAP


SAP MSQSYSDEV table summary

Object Name: MSQSYSDEV
Dictionary Type: Structure
Description: MS SQL server dump devices (as from sysdevices)


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

Details
MSQSYSDEV-DEVNAME table field - MS SQL server - Log device name

Description: MS SQL server - Log device name
Field Name: DEVNAME
Data Element: MSQLOGDVNA
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEVNAME

MSQSYSDEV-FLSIZE table field - MS SQL server device file size

Description: MS SQL server device file size
Field Name: FLSIZE
Data Element: MSQDEVFLSZ
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 FLSIZE

MSQSYSDEV-LOW table field - MS SQL server - first virtual page number on a database dev

Description: MS SQL server - first virtual page number on a database dev
Field Name: LOW
Data Element: MSQDVLOWPG
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 LOW

MSQSYSDEV-HIGH table field - MS SQL server - Last virtual page num on a database device

Description: MS SQL server - Last virtual page num on a database device
Field Name: HIGH
Data Element: MSQDVHIGPG
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 HIGH

MSQSYSDEV-STATUS table field - MS SQL server backup device type

Description: MS SQL server backup device type
Field Name: STATUS
Data Element: MSQDEVTYPE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSQSYSDEV-CNTRLTYPE table field - MS SQL server - device controller type

Description: MS SQL server - device controller type
Field Name: CNTRLTYPE
Data Element: MSQCNTRTYP
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CNTRLTYPE

MSQSYSDEV-PHYNAME table field - MS SQL server: name of the physical device

Description: MS SQL server: name of the physical device
Field Name: PHYNAME
Data Element: MSQPHYDVNA
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 PHYNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table