SAP ABAP Table SMSY_DBSYS (Database Instances)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-SYS (Application Component) Solution Manager System Landscape
     ⤷ AI_S_CUSTOMIZING_LANDSCAPE (Package) System Landscape Maintenance for Customizing Tools

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMSY_DBSYS	Table Relationship Diagram
Short Description	Database Instances

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DBNAME	☑	SMSY_DB_NAME	SYCHAR10	CHAR	10	0	Datenbase Name
2	KONZS	☑	KONZS	KONZS	CHAR	10	0	Group key
3	VERSION	☑	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
4	DBVENDOR	☐	SMSY_DB_VENDOR	SMSY_DB_VENDOR	CHAR	120	0	Database Manufacturer	SMSY_DB_SYS
5	DBRELEASE	☐	SMSY_DB_REL		CHAR	16	0	Database Release	SMSY_DB_SYS
6	DBPATCHLEVEL	☐	SMSY_DB_PATCH	SMSY_DB_PATCH	CHAR	32	0	Support Package Level
7	DBHOSTNAME	☐	SMSY_HOSTNAME	SMSY_HOSTNAME	CHAR	20	0	Server Name	*
8	PLANNED	☐	SMSY_FLG_PLANNED	SMSY_FLG_PLANNED	CHAR	1	0	Flag: Planned or Existing
9	ENTITY_KEY	☐	SMSY_ENTITY_GUID	CHAR32	CHAR	32	0	System Landscape Entity GUID
10	.INCLUDE	☐				0	0	System Landscape History Data
11	SYDATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
12	SYUZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
13	SYUNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
14	TRCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
15	GENERATOR	☐	SMSY_FLAG	SMSY_FLAG	CHAR	10	0	System Landscape Capture Flag
16	AKT_VERSION	☐	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
17	DESCR	☐	SMSY_ENTITY_DESCR	SMSY_ENTITY_DESCR	CHAR	80	0	Object Description
18	AC_FLAG	☐	SMSY_AC_FLG_HOST_AC_ENABLED	X	CHAR	1	0	Server managed by AC
19	DB_TYPE	☐	SLDDBSYS	SLDDBSYS	CHAR	10	0	Database
20	PPMS_ID	☐	SMSY_PPMS_COMPONENT	SMSYCOMPONENT	CHAR	20	0	ppms Component	*
21	.INCLUDE	☐				0	0	SLD Source Description
22	SLDHOST	☐	SLD_HOSTNAME	PHOST	CHAR	64	0	Host Name of System Landscape Directory
23	SLDPORT	☐	SLD_PORTNUMBER		NUMC	5	0	Port Number of System Landscape Directory
24	SLDNAMESPACE	☐	SMSY_SLD_NSPACE	SMSY_SLD_NSPACE	CHAR	40	0	SLD Namespace
25	SLD_NAME	☐	SLDNAME		CHAR	255	0	Name in SLD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_DBSYS	DBRELEASE	SMSY_DB_SYS	DBVERSION		1	CN
2	SMSY_DBSYS	DBVENDOR	SMSY_DB_SYS	DBTYPE		1	CN

History

Last changed by/on	SAP	20100705
SAP Release Created in	220