SAP Table DBCON

Description of Database Connections

DBCON (Description of Database Connections) 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 DBCON to other SAP tables.

DBCON table fields

Field Data element Checktable Datatype Length Decimals
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