SAP MSSCHEMAS table - MS SQL Server schema overview data details in SAP

SAP MSSCHEMAS table summary

Object Name: MSSCHEMAS
Dictionary Type: Structure
Description: MS SQL Server schema overview data

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

Details

MSSCHEMAS-SCHEMA_NAME table field - Schema name ▼

Description: Schema name
Field Name: SCHEMA_NAME
Data Element: MSSSCHEMA
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 SCHEMA_NAME

MSSCHEMAS-NUMBER_TABLES table field - Number of user tables ▼

Description: Number of user tables
Field Name: NUMBER_TABLES
Data Element: MSSNUMTABLES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBER_TABLES

MSSCHEMAS-NUMBER_PROCS table field - Number of stored procedures created in DBI ▼

Description: Number of stored procedures created in DBI
Field Name: NUMBER_PROCS
Data Element: MSSNUMPROCS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBER_PROCS

MSSCHEMAS-SCHEMA_SIZE table field - MSS schema size in MB ▼

Description: MSS schema size in MB
Field Name: SCHEMA_SIZE
Data Element: MSSTOTSCHEMASZMB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEMA_SIZE

View list of all SAP tables(S4H/ECC)

Select data from SAP table