SAP ABAP Table MSSCONNDATA (MSSQL multi-connect : Complete connection information)

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	INTTAB	Structure
Structure	MSSCONNDATA	Table Relationship Diagram
Short Description	MSSQL multi-connect : Complete connection information

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
2	CON_NAME	☐	DBCON_NAME	DBCON_NAME	CHAR	30	0	Logical name for a database connection	*
3	DBSCHEMA	☐	MSSOBJSRC	MSSSYSNAME	CHAR	128	0	MSSQL Multiconnect : Object source schema
4	HOSTNAME	☐	MSSINSTANC	MSSSYSNAME	CHAR	128	0	MSSQL Multiconnect : SQL Server name
5	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
6	DBUSER	☐	MSSDBUSER	MSSSYSNAME	CHAR	128	0	MSSQL Multiconnect : DB user
7	RFC_OK	☐			CHAR	1	0
8	UNUSED1	☐			CHAR	3	0
9	DBCON_OK	☐			CHAR	1	0
10	UNUSED2	☐			CHAR	3	0
11	DBO_OK	☐			CHAR	1	0
12	IS_BW	☐			CHAR	1	0
13	UNUSED3	☐			CHAR	2	0
14	UNUSED4	☐			CHAR	4	0
15	SCH_EXISTS	☐			CHAR	1	0
16	LOCALSYS	☐			CHAR	1	0
17	IS_ABAP	☐			CHAR	1	0
18	SAPRELEASE	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
19	EXTRELEASE	☐	SAPPATCHLV	CHAR10	CHAR	10	0	Patch Level of a Software Component
20	SQLRELEASE	☐	MSSRELEASE		CHAR	16	0	MSSQL : SQL Server Release string >> XX.YYY.ZZZZ <<
21	DB_VERS	☐	MSSTSQLVER		CHAR	16	0	MSSQL Multiconnect : Version of SAP TSQL layer
22	ERRCODE	☐	SYSUBRC	SYST_SHORT	INT4	10	0	Return Code
23	.INCLUDE	☐				0	0	Structure of message variables
24	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
25	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
26	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
27	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
28	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
29	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
30	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
31	USER_NAME	☐	DBCON_UID	TEXT30	CHAR	30	0	Database User
32	RAT_EXISTS	☐			CHAR	1	0
33	LOGIN_EXISTS	☐			CHAR	1	0
34	RFC_VERSION	☐			CHAR	10	0
35	PROCSVERS	☐	MSSTSQLVER		CHAR	16	0	MSSQL Multiconnect : Version of SAP TSQL layer
36	DBRELEASE	☐	MSSDBRELE	MSSDBRELE	CHAR	3	0	MS SQL Server : Database Release X.YY.ZZZ
37	ABAPSCHEMA	☐	MSSSCHEMA	MSSSYSNAME	CHAR	128	0	Schema name
38	JAVASCHEMA	☐	MSSSCHEMA	MSSSYSNAME	CHAR	128	0	Schema name
39	DB_BITS	☐			INT4	10	0
40	PRIVILEG	☐			CHAR	24	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	640