SAP ABAP Table MSSPROCS (MS SQL Server: Stored Procedures)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_TOOLS (Package) Utilities for MS SQL Server

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MSSPROCS	Table Relationship Diagram
Short Description	MS SQL Server: Stored Procedures

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PROCNAME	☑	MSSPROCED	MSSPROCED	CHAR	32	0	MS SQL Server: Stored procedure name
2	DBRELEASE	☑	MSSDBRELE	MSSDBRELE	CHAR	3	0	MS SQL Server : Database Release X.YY.ZZZ	MSSSPVERS
3	REVISION	☑	MSSSPREVI	MSSSPREVI	CHAR	1	0	MS SQL Server: Stored procedure revision	MSSSPVERS
4	PROCAREA	☐	MSSPRCAREA	MSSPRCAREA	CHAR	4	0	MS SQL Server: Stored procedure application area
5	FUNCLEV	☐	MSSFULEVEL	MSSFULEVEL	CHAR	1	0	MSSQL MSSPROCS : Functional level
6	MODUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
7	MODDATE	☐			DATS	8	0
8	MODTIME	☐			TIMS	6	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSSPROCS	DBRELEASE	MSSSPVERS	DBRELEASE		1	CN
2	MSSPROCS	REVISION	MSSSPVERS	REVISION		C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in