SAP DB6ADMSYS DB6: System administration entry Table data and field list

DB6ADMSYS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB6: System administration entry" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB6ADMSYS TYPE DB6ADMSYS.

The DB6ADMSYS table consists of various fields, each holding specific information or linking keys about DB6: System administration entry data available in SAP. These include SYSID (Name of SAP System), SAPREL (Release of SAP System), DBREL (DB6: Database Release Level), RFCDEST (Logical Destination (Specified in Function Call))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DB6ADMSYS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DB6ADMSYS structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DB6ADMSYS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
SAPRELRelease of SAP System SYSAPRLCHAR4SYCHAR04
DBRELDB6: Database Release Level DB6DBRELCHAR10
RFCDESTLogical Destination (Specified in Function Call) RFCDESTCHAR32Assigned to domainRFCDESTRFCF4_RFCDESTYPEALL
DBHOSTDBA Cockpit: Server Name DBA_SERVERCHAR255DBA_SERVER
SCHEMANAMEDB6: Schema Name DB6SCHEMACHAR20
ENTRYSTATE State of entry: 1=INITIAL,2=COMPLETE,3=DISABLED0
ENTRYTYPE kind of system: 1=R/3 ,2=Non R/30
DBCNAMELogical name for a database connection DBCON_NAMECHAR30DBCONDBCON_NAME
DBSYSDatabase system DBCON_DBMSCHAR3DBCON_DBMS
DB_OPSYSOperating System of Application Server SYOPSYSCHAR10SYOPSYS
COCKRELRelease of SAP System SYSAPRLCHAR4SYCHAR04
REALSIDName of SAP System SYSYSIDCHAR8SYCHAR08
DBSIDDBA Cockpit: Database Name DBA_DBNAMECHAR128DBA_DBNAME
RZ20_MON Remote Alert Monitoring active ('X')/inactive (' ')0
HIST_MON Remote History Collection active('X')/inactive(' ')0
DESCRIPTIONText (80 Characters) TEXT80CHAR80TEXT80UEB
CHANGEDATESystem Date SYDATUMDATS8SYDATS
CHANGETIMESystem Time SYUZEITTIMS6SYTIME
CHANGED_BYUser Name SYUNAMECHAR12SYCHAR12
SYSTEMTYPESAP DB: Instance Type SDB_ITYPECHAR7SDB_ITYPE
RFCDEST_2Logical Destination (Specified in Function Call) RFCDESTCHAR32Assigned to domainRFCDESTRFCF4_RFCDESTYPEALL
REMOTE_COLL Collect data remote('X') or local (' ')0
DBCON_VIA_RFC DB Connection via RFC Destination0
PROMPT_USER_DATA Store password permanent0
SLD_NAME 0
SLD_UPDATEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
DB13C_MON DB13C Integration active('X')/inactive('')0
KPI_MON A1S KPI Monitoring active('X')/inactive('')0
LICENSE_EXT Platform specific license extension0
SCHEDULER_TYPE Scheduler Type0
BACKEND_STATE Back-End State0
BACKEND_CHK_TIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
HIST_DBH Remote History Collection based on STPs0
MODDATE 0
BACKEND_TPL_ID Template ID0
LSID Landscape ID (Solution Manager)0
MODTIME 0
MODUSERUser Name SYUNAMECHAR12SYCHAR12
AUTO_UPDATE Auto Update active('X')/inactive('')0
READ_ONLY 0
CHANGED 0
NEW 0
SYNCHRONIZED 0
MODDATE 0
MODTIME 0
MODUSERUser Name SYUNAMECHAR12SYCHAR12
READ_ONLY 0

Key field Non-key field



How do I retrieve data from SAP structure DB6ADMSYS using ABAP code?

As DB6ADMSYS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB6ADMSYS as there is no data to select.

How to access SAP table DB6ADMSYS

Within an ECC or HANA version of SAP you can also view further information about DB6ADMSYS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).