- Home
- Resources
- SAP Tables
- DBASLDSYS - DB6: System Registration Table
SAP Table DBASLDSYS
DB6: System Registration Table
DBASLDSYS (DB6: System Registration Table) 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 DBASLDSYS to other SAP tables.
Source: DBASLDSYS (DB6: System Registration Table)
DBASLDSYS table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| SYSID |
Name of SAP System |
SYSYSID |
|
CHAR |
|
8 |
0 |
|
| DBHOST |
DBA Cockpit: Server Name |
DBA_SERVER |
|
CHAR |
|
255 |
0 |
|
| SCHEMANAME |
DB6: Schema Name |
DB6SCHEMA |
|
CHAR |
|
20 |
0 |
|
| DBCNAME |
Logical name for a database connection |
DBCON_NAME |
DBCON
|
CHAR |
|
30 |
0 |
|
| DBSYS |
Database system |
DBCON_DBMS |
|
CHAR |
|
3 |
0 |
Possible values
| 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 |
|
| REALSID |
Name of SAP System |
SYSYSID |
|
CHAR |
|
8 |
0 |
|
| DBSID |
DBA Cockpit: Database Name |
DBA_DBNAME |
|
CHAR |
|
128 |
0 |
|
| DESCRIPTION |
|
|
|
CHAR |
|
80 |
0 |
|
| SYSTEMTYPE |
SAP DB: Instance Type |
SDB_ITYPE |
|
CHAR |
|
7 |
0 |
Possible values
| LVC |
liveCache |
| OLTP |
Online Transaction Processing Database |
| OLAP |
Business Warehouse Database |
|
| SLD_NAME |
|
|
|
CHAR |
|
255 |
0 |
|
| DB6_SERVICE_NAME |
|
|
|
CHAR |
|
14 |
0 |
|
DBASLDSYS foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| DBASLDSYS |
DBCNAME |
DBASLDSYS |
DBCNAME |
DBCON |
Description of Database Connections |
CON_NAME |
