SAP ABAP Table SMSY_ADJ_SCR_DBSYS_AUT (Automatically Captured Database Data)

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	INTTAB	Structure
Structure	SMSY_ADJ_SCR_DBSYS_AUT	Table Relationship Diagram
Short Description	Automatically Captured Database Data

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

History

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