Hierarchy
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Data Element | MSSSPNAME |
Short Description | Stored procedure name |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | CHAR128 | |
Data Type | CHAR | Character String |
Length | 128 | |
Decimal Places | 0 | |
Output Length | 128 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | Name |
Medium | 20 | SP name |
Long | 34 | Stored procedure name |
Heading | 40 | Stored procedure name |
Documentation
Definition
Name of a stored procedure within the SQL Server database.
If the name begins with a 'Y' or an 'X' followed by several digits
and characters, it is most probably a permanent stored procedure that
was created by the database interface of the SAP system when an SQL
statement in ABAP had to be processed. For the execution of each
ABAP SQL statement, a stored procedure is first created (if not yet
done) and executed.
The generated stored procedure name has the following form:
'Y' + modtype + statement num.(hex) + timestamp(enc.) + mod. name
1 char + 1 char + 8 char + 8 char + <= 12 char
If the name begins with '#' followed by a number, it is most
likely a temporary stored procedure generated by the SAP database
interface and is located in the tempdb database. Temporary stored
procedures will be lost after a database shutdown. They are
generated for SQL statements originating from SAP that have no ABAP
statement ID (for example, those called from C functions). They are only usable
within the connection where they were created.
The structure of a generated temporary stored procedure name is:
'##' + cname + mss_glob.pid + counter + timestamp
2 char + <= 12 dig + 5 dig + 5 dig + 8 dig ?
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |