SAP MSQOBJECTS table - MS SQL server system objects ( as from sysobjects ) details in SAP

SAP MSQOBJECTS table summary

Object Name: MSQOBJECTS
Dictionary Type: Structure
Description: MS SQL server system objects ( as from sysobjects )

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

Details

MSQOBJECTS-NAME table field - Object name as defined in system table sysobjects. ▼

Description: Object name as defined in system table sysobjects.
Field Name: NAME
Data Element: MSQOBJNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

MSQOBJECTS-ID table field - SQL Server object or index ID. ▼

Description: SQL Server object or index ID.
Field Name: ID
Data Element: MSQOBJID
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 ID

MSQOBJECTS-TYPE table field - MS SQL server object type ▼

Description: MS SQL server object type
Field Name: TYPE
Data Element: MSQOBJTYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

MSQOBJECTS-USERID table field - MS SQL Server - user identification ID ▼

Description: MS SQL Server - user identification ID
Field Name: USERID
Data Element: MSQUID
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 USERID

MSQOBJECTS-SCHEMAVER table field - The count of changes in schema of a given object ▼

Description: The count of changes in schema of a given object
Field Name: SCHEMAVER
Data Element: MSQSCHEVER
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 SCHEMAVER

MSQOBJECTS-PARENTOBJ table field - MS SQL Server - parent object ID ▼

Description: MS SQL Server - parent object ID
Field Name: PARENTOBJ
Data Element: MSQPAROBID
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 PARENTOBJ

MSQOBJECTS-CREDATE table field - MS SQL server object creation date ▼

Description: MS SQL server object creation date
Field Name: CREDATE
Data Element: MSQOBJCRDT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREDATE

MSQOBJECTS-SYSSTAT table field - MS SQL server - internal status information ▼

Description: MS SQL server - internal status information
Field Name: SYSSTAT
Data Element: MSQSYSSTAT
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 SYSSTAT

MSQOBJECTS-IDXDELCNT table field - The index delete count ▼

Description: The index delete count
Field Name: IDXDELCNT
Data Element: MSQIDXDECT
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 IDXDELCNT

MSQOBJECTS-DELTRIG table field - The stored procedure ID of a delete trigger ▼

Description: The stored procedure ID of a delete trigger
Field Name: DELTRIG
Data Element: MSQSPIDDET
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 DELTRIG

MSQOBJECTS-INSTRIG table field - The stored procedure ID of an insert trigger ▼

Description: The stored procedure ID of an insert trigger
Field Name: INSTRIG
Data Element: MSQSPIDINT
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 INSTRIG

MSQOBJECTS-UPDTRIG table field - The stored procedure ID of an update trigger ▼

Description: The stored procedure ID of an update trigger
Field Name: UPDTRIG
Data Element: MSQSPIDUPT
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 UPDTRIG

MSQOBJECTS-CATEGORY table field - MS SQL server database category ▼

Description: MS SQL server database category
Field Name: CATEGORY
Data Element: MSQCATEGRY
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 CATEGORY

View list of all SAP tables(S4H/ECC)

Select data from SAP table