1. Home
  2. Resources
  3. SAP Tables
  4. DBA_VIEW_SYSTEM_DETAIL - DBA Cockpit: View Data of System Configuration

SAP Table DBA_VIEW_SYSTEM_DETAIL

DBA Cockpit: View Data of System Configuration

DBA_VIEW_SYSTEM_DETAIL (DBA Cockpit: View Data of System Configuration) 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_SYSTEM_DETAIL to other SAP tables.

DBA_VIEW_SYSTEM_DETAIL table fields

Field Data element Checktable Datatype Length Decimals
CURRENT_ENTRY DB6NAVSDIS STRU 0 0
STATUS_ICON Carrier field for icons ICON_TEXT CHAR 132 0
SYSID Name of SAP System SYSYSID CHAR 8 0
SAPREL Release of SAP System SYSAPRL CHAR 4 0
DBREL DB6: Database Release Level DB6DBREL CHAR 10 0
RFCDEST Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
DBHOST DBA Cockpit: Server Name DBA_SERVER CHAR 255 0
SCHEMANAME DB6: Schema Name DB6SCHEMA CHAR 20 0
ENTRYSTATE INT4 10 0
ENTRYTYPE INT4 10 0
DBCNAME Logical name for a database connection DBCON_NAME CHAR 30 0
DBSYS 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
DB_OPSYS Operating System of Application Server SYOPSYS CHAR 10 0
COCKREL Release of SAP System SYSAPRL CHAR 4 0
REALSID Name of SAP System SYSYSID CHAR 8 0
DBSID DBA Cockpit: Database Name DBA_DBNAME CHAR 128 0
RZ20_MON CHAR 1 0
HIST_MON CHAR 1 0
DESCRIPTION Text (80 Characters) TEXT80 CHAR 80 0
CHANGEDATE System Date SYDATUM DATS 8 0
CHANGETIME System Time SYUZEIT TIMS 6 0
CHANGED_BY User Name SYUNAME CHAR 12 0
SYSTEMTYPE SAP DB: Instance Type SDB_ITYPE CHAR 7 0
LVC liveCache
OLTP Online Transaction Processing Database
OLAP Business Warehouse Database
RFCDEST_2 Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
REMOTE_COLL CHAR 1 0
DBCON_VIA_RFC CHAR 1 0
PROMPT_USER_DATA CHAR 1 0
SLD_NAME CHAR 255 0
SLD_UPDATE DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14 0
DB13C_MON CHAR 1 0
KPI_MON CHAR 1 0
LICENSE_EXT CHAR 10 0
SCHEDULER_TYPE INT4 10 0
BACKEND_STATE INT4 10 0
BACKEND_CHK_TIME DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14 0
HIST_DBH CHAR 1 0
BACKEND_TPL_ID INT4 10 0
LSID CHAR 8 0
AUTO_UPDATE CHAR 1 0
DEFAULTSYS Carrier field for icons ICON_TEXT CHAR 132 0
DBSYS_IMAGE Text, 255 Characters TEXT255 CHAR 255 0
ORALICEXTDIAG CHAR 1 0
DB_USER Logical name for a database connection DBCON_NAME CHAR 30 0
STATUS STRG 0 0
DBSYS_TEXT STRG 0 0
CB_R3_SYSTEM CHAR 1 0
RB_ENTRYTYPE_LOCAL CHAR 1 0
CROSS_SCHEMA_NAME DBA Cockpit: Listbox Value DBA_LISTBOX_VALUE CHAR 40 0
CROSS_SCHEMATA DBA_LISTBOX_LIST TTYP 0 0
RB_ENTRYTYPE_REMOTE CHAR 1 0
CB_WITH_RFCDEST CHAR 1 0
CB_WITH_DBCON CHAR 1 0
RB_APPLTYPE_OLTP CHAR 1 0
RB_APPLTYPE_OLAP CHAR 1 0
RB_APPLTYPE_LIVECACHE CHAR 1 0
REMOTE_CONNECTIONS DBA_DBCON_NAME_LIST TTYP 0 0
SELECT_LIST_TITLE CHAR 60 0
RFC_ICON Carrier field for icons ICON_TEXT CHAR 132 0
DBCON_ICON Carrier field for icons ICON_TEXT CHAR 132 0
SLD_DATE System Date SYDATUM DATS 8 0
SLD_TIME System Time SYUZEIT TIMS 6 0
RB_ENTRYTYPE STRG 0 0
CB_CRITICAL_ALERTS Replacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEAN CHAR 1 0
X True
NULL False