SAP Table DBA_VIEW_DB_CONNECTION_DETAIL

DBA Cockpit: View Data of Database Connection

DBA_VIEW_DB_CONNECTION_DETAIL (DBA Cockpit: View Data of Database Connection) 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 DBA_VIEW_DB_CONNECTION_DETAIL to other SAP tables.

DBA_VIEW_DB_CONNECTION_DETAIL table fields

Field Data element Checktable Datatype Length Decimals
CON_DATA DBCON STRU 0 0
CON_NAME Logical name for a database connection DBCON_NAME CHAR 30 0
DBMS Database system DBCON_DBMS CHAR 3 0
ADA SAP MaxDB/liveCache
DB2 DB2 UDB for OS/390
DB4 DB2 UDB for AS/400
DB6 DB2 UDB for Unix and Windows
INF Informix
MSS Microsoft SQL Server
ORA Oracle
HDB SAP HANA database
SYB Sybase ASE
USER_NAME Database User DBCON_UID CHAR 30 0
PASSWORD Password for setting up the connection to the database DBCON_PWD CHAR 255 0
CON_ENV Database-specific information for a database connection DBCON_ENV CHAR 255 0
DB_RECO Availability type for an open database connect DBCON_RECO CHAR 1 0
NULL Not Selected
X Selected
MAX_CONNECTIONS Maximum Number of Connections DBCON_MAX_CONNECTIONS INT1 3 0
OPT_CONNECTIONS Optimum Number of Connections DBCON_OPT_CONNECTIONS INT1 3 0
PASSWORD Password for setting up the connection to the database DBCON_PWD CHAR 255 0
PASSWORD_CONFIRM Password for setting up the connection to the database DBCON_PWD CHAR 255 0
INITIAL STRG 0 0
DBSYS DBA Cockpit: Listbox Value DBA_LISTBOX_VALUE CHAR 40 0
DBCON_PARAMETERS DBA_DBCON_PARAM_LIST TTYP 0 0
RFCDEST Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
DB_SYSTEMS DBA_LISTBOX_LIST TTYP 0 0
STATUS STRG 0 0
RB_MAXDB CHAR 1 0
RB_LIVECACHE CHAR 1 0
ADA ADA_VIEW_DB_CONNECTION_DETAIL STRU 0 0
DBM_USER Database User DBCON_UID CHAR 30 0
DBM_PASSWORD Password for setting up the connection to the database DBCON_PWD CHAR 255 0
DBM_PASSWORD_CONFIRM Password for setting up the connection to the database DBCON_PWD CHAR 255 0
CB_CENTRAL_AUTHORIZATION Replacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEAN CHAR 1 0
X True
NULL False
INITIAL STRG 0 0