SAP Table MSSPROCS

MS SQL Server: Stored Procedures

MSSPROCS (MS SQL Server: Stored Procedures) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MSSPROCS to other SAP tables.

Source: MSSPROCS (MS SQL Server: Stored Procedures)

MSSPROCS table fields

Field

Data element

Checktable

Datatype

Length

Decimals

PROCNAME

MS SQL Server: Stored procedure name

MSSPROCED

CHAR

DBRELEASE

MS SQL Server : Database Release X.YY.ZZZ

MSSDBRELE

MSSSPVERS

CHAR

REVISION

MS SQL Server: Stored procedure revision

MSSSPREVI

MSSSPVERS

CHAR

PROCAREA

MS SQL Server: Stored procedure application area

MSSPRCAREA

CHAR

Possible values

BW	Business Information Warehouse
CCMS	Computer Center Management System
DDIC	ABAP Dictionary
UTIL	Ad hoc procedure
COLL	MSSQL Performance Collector
BTCH	SQL Statement Batch

FUNCLEV

MSSQL MSSPROCS : Functional level

MSSFULEVEL

CHAR

Possible values

1	Minimum set
2	Standard set
3	ABAP AS

MODUSER

User Name

SYUNAME

CHAR

MODDATE

DATS

MODTIME

TIMS

MSSPROCS foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
MSSPROCS	DBRELEASE	MSSPROCS	DBRELEASE	MSSSPVERS	MS SQL Server: Database Release and Stored Proc. Revision	DBRELEASE
MSSPROCS	DBRELEASE	MSSPROCS	REVISION	MSSSPVERS	MS SQL Server: Database Release and Stored Proc. Revision	REVISION
MSSPROCS	REVISION	MSSPROCS	DBRELEASE	MSSSPVERS	MS SQL Server: Database Release and Stored Proc. Revision	DBRELEASE
MSSPROCS	REVISION	MSSPROCS	REVISION	MSSSPVERS	MS SQL Server: Database Release and Stored Proc. Revision	REVISION