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

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