SAP ABAP Table SDB_OVERVIEW (All Database Overview Information)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-SDB-CCM (Application Component) CCMS/Database Monitors for MaxDB
⤷ SDBA_SDB (Package) MaxDB/liveCache Monitoring and Administration
⤷ BC-DB-SDB-CCM (Application Component) CCMS/Database Monitors for MaxDB
⤷ SDBA_SDB (Package) MaxDB/liveCache Monitoring and Administration
Basic Data
Table Category | INTTAB | Structure |
Structure | SDB_OVERVIEW | Table Relationship Diagram |
Short Description | All Database Overview Information |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | REFRESH_DATE | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
2 | REFRESH_TIME | SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
3 | CON_NAME | DBCON_NAME | DBCON_NAME | CHAR | 30 | 0 | Logical name for a database connection | * | |
4 | DESCRIPTION | TEXT80 | TEXT80UEB | CHAR | 80 | 0 | Text (80 Characters) | ||
5 | DBNAME | SDB_DBNAME | SDB_DBNAME | CHAR | 18 | 0 | SAP DB: DBName | ||
6 | SQL_USER | SDB_DBUSER | SDB_DBUSER | CHAR | 64 | 0 | SAP DB: DBUser name | ||
7 | DBM_USER | SDB_DBUSER | SDB_DBUSER | CHAR | 64 | 0 | SAP DB: DBUser name | ||
8 | DBSERVER | SDB_DBNODE | SDB_DBNODE | CHAR | 64 | 0 | SAP DB: DBServer name | ||
9 | DBVERSION | SDB_LINE | SDB_LINE | CHAR | 255 | 0 | SAP DB: Response line from DBM command | ||
10 | DISP_VERSION | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
11 | OPERATING_SYSTEM | SDB_LINE | SDB_LINE | CHAR | 255 | 0 | SAP DB: Response line from DBM command | ||
12 | STATE_ICON | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
13 | NAME_STATE_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
14 | STATE | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
15 | TEXT_STANDBY | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
16 | RESTART_DATE | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
17 | RESTART_TIME | SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
18 | SQL_ACCESS | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
19 | DBM_ACCESS | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
20 | ACTIONS_EXECUTED | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
21 | LAST_INIT_ICON | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
22 | NAME_LAST_INIT_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
23 | LAST_ACT_ICON | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
24 | NAME_LAST_ACT_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
25 | LAST_INIT_DATE | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
26 | LAST_INIT_TIME | SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
27 | LAST_ACT_DATE | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
28 | LAST_ACT_TIME | SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
29 | STATE_AUTOLOG | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
30 | STATE_DBTRACE | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
31 | STATE_COM_MONITOR | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
32 | STATE_REC_MONITOR | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
33 | STATE_OMS_ANALYSIS | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
34 | STATE_DBAN | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
35 | STATE_CHECKPOINT_WANTED | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
36 | INSTROOT | SDB_DIR | TEXT255 | CHAR | 255 | 0 | SAP DB: Directory Name | ||
37 | INDEPPROGPATH | SDB_DIR | TEXT255 | CHAR | 255 | 0 | SAP DB: Directory Name | ||
38 | INDEPDATAPATH | SDB_DIR | TEXT255 | CHAR | 255 | 0 | SAP DB: Directory Name | ||
39 | RUNDIRECTORY | SDB_DIR | TEXT255 | CHAR | 255 | 0 | SAP DB: Directory Name | ||
40 | PRIVATEDATAPATH | SDB_DIR | TEXT255 | CHAR | 255 | 0 | SAP DB: Directory Name | ||
41 | HSS_VIRTUAL_NAME | SDB_DBNODE | SDB_DBNODE | CHAR | 64 | 0 | SAP DB: DBServer name | ||
42 | HSS_CONFIGURATION | SDB_HSS_TAB | TTYP | 0 | 0 | ||||
43 | HSS_SHARED_LOG | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
44 | ADDRESSING_MODE | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
45 | IS_ONLINE | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
46 | SQL_PROBLEM | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
47 | DBM_PROBLEM | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
48 | MULTI_TENANT | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
49 | DISP_DESCRIPTION | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
50 | DISP_DB_FULL | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
51 | DISP_LOG_FULL | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
52 | DISP_OVERWRITE_MODE | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
53 | DISP_BAD_INDEXES | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
54 | DISP_BAD_VOLUMES | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
55 | DISP_WNG_LOGGING | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
56 | DISP_LAST_INIT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
57 | DISP_LAST_ACT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
58 | DISP_HSS | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
59 | DISP_HSS_NO_VIRTUAL_WARNING | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
60 | DISP_ONEDB | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
61 | DISP_BRIDGE | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
62 | DISP_MULTI_TENANT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
63 | DISP_CHECKPOINT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
64 | DISP_OMS_ANALYSIS | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
65 | DISP_SNAPSHOT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
66 | DISP_OPERATING | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
67 | DISP_LVC_ACT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
68 | DISP_LVC_INIT | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
69 | DISP_LCAPPS_REG | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
70 | DISP_ONLINE_WARNING_1 | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
71 | DISP_ONLINE_WARNING_2 | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
72 | DISP_WARNING_FOOTNOTE | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
73 | DISP_ADDRESSING_MODE | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
74 | DISP_C_DETAILS | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
75 | DISP_C_OPERATING | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
76 | DISP_C_HSS | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
77 | ENABLE_LCAPPS_REG | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
78 | TITLE_DISPLAY | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
79 | TITLE_PROPERTIES | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
80 | TITLE_STATE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
81 | TITLE_OPERATING | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
82 | TITLE_SETTINGS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
83 | TITLE_HSS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
84 | LABEL_REFRESH | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
85 | LABEL_CON_NAME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
86 | LABEL_DESCRIPTION | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
87 | LABEL_DBNAME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
88 | LABEL_DBSERVER | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
89 | LABEL_DBVERSION | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
90 | LABEL_DISP_VERSION | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
91 | LABEL_SQL_USER | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
92 | LABEL_DBM_USER | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
93 | LABEL_OP_SYST | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
94 | LABEL_STATE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
95 | LABEL_ONLINE_SINCE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
96 | LABEL_OPERATING | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
97 | LABEL_LAST_INIT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
98 | LABEL_LAST_INIT_TIME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
99 | LABEL_LAST_ACT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
100 | LABEL_LAST_ACT_TIME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
101 | LABEL_INSTROOT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
102 | LABEL_INDEPPROGPATH | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
103 | LABEL_INDEPDATAPATH | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
104 | LABEL_RUNDIRECTORY | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
105 | LABEL_PRIVATEDATAPATH | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
106 | LABEL_AUTOLOG | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
107 | LABEL_DBTRACE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
108 | LABEL_COM_MONITOR | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
109 | LABEL_REC_MONITOR | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
110 | LABEL_OMS_ANALYSIS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
111 | LABEL_DBAN | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
112 | LABEL_CHECKPOINT_WANTED | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
113 | LABEL_SQL_ACCESS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
114 | LABEL_DBM_ACCESS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
115 | LABEL_SNAPSHOT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
116 | LABEL_ONLINE_WARNING_1 | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
117 | LABEL_ONLINE_WARNING_2 | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
118 | LABEL_HSS_VIRTUAL_NAME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
119 | LABEL_HSS_SHARED_LOG | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
120 | LABEL_MULTI_TENANT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
121 | LABEL_ADDRESSING_MODE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
122 | TEXT_SNAPSHOT | CHAR70 | CHAR70 | CHAR | 70 | 0 | Character field, length 70 | ||
123 | TEXT_ONEDB | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
124 | TEXT_BRIDGE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
125 | TEXT_MULTI_TENANT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
126 | TEXT_LOG_FULL | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
127 | TEXT_DATA_FULL | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
128 | TEXT_OVERWRITE_MODE | CHAR70 | CHAR70 | CHAR | 70 | 0 | Character field, length 70 | ||
129 | TEXT_HSS_NO_VIRTUAL_WARNING | CHAR90 | CHAR90 | CHAR | 90 | 0 | SAPconnect/phone: Character 90 | ||
130 | TEXT_BAD_INDEX | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
131 | TEXT_BAD_VOLUME | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
132 | TEXT_WNG_LOGGING | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
133 | TEXT_STATE_ICON | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
134 | TEXT_LAST_INIT_ICON | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
135 | TEXT_LAST_ACT_ICON | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
136 | TEXT_LOG | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
137 | TEXT_LVC_START | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
138 | TEXT_LVC_STOP | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
139 | TEXT_LVC_INIT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
140 | TEXT_LCAPPS_REG | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
141 | TEXT_LAST_INIT | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
142 | TEXT_LAST_ACT | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
143 | TEXT_WARNING_FOOTNOTE | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
144 | TEXT_BUTTON_DETAILS | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
145 | TEXT_BUTTON_OPERATING | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
146 | TEXT_BUTTON_HSS | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
147 | ICON_NAME_DETAILS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
148 | ICON_NAME_OPERATING | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
149 | ICON_NAME_HSS | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
150 | USEDSIZEPERCENTAGE_DATA | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
151 | USEDSIZEPERCENTAGE_LOG | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
152 | USEDSIZEPERCENTAGE_SESS | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
153 | DISP_GRAPH_DATA | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
154 | DISP_GRAPH_LOG | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
155 | DISP_GRAPH_SESS | WDY_BOOLEAN | WDY_BOOLEAN | CHAR | 1 | 0 | Replacement for Real Boolean Type: 'X' == True '' == False | ||
156 | LABEL_GRAPH | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
157 | LABEL_GRAPH_DATA | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
158 | LABEL_GRAPH_LOG | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
159 | LABEL_GRAPH_SESS | CHAR8 | CHAR8 | CHAR | 8 | 0 | Character field, 8 characters long | ||
160 | SQL_POSSIBLE | FLAG | FLAG | CHAR | 1 | 0 | General Flag |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 710 |