SAP ABAP Table SMSY_DB_USAGE_2 (Database Use of Technical Systems)

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_DB_USAGE_2	Table Relationship Diagram
Short Description	Database Use of Technical Systems

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	SYSTEMNAME	☑	SMSY_NAME	SMSY_NAME	CHAR	8	0	Product System Name	SMSY_SYSTEM
2	KONZS	☑	KONZS	KONZS	CHAR	10	0	Group key
3	VERSION	☑	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
4	SYSTEMTYPE	☑	SMSY_SYSTYPE	SMSY_SYSTYPE	CHAR	10	0	Typing of Technical Systems	SMSY_SYSTEMTYPE
5	DBNAME	☑	SMSY_DB_NAME	SYCHAR10	CHAR	10	0	Datenbase Name
6	DBSCHEMA	☑	SMSY_DB_SCHEMA	CHAR30	CHAR	30	0	Database Schema
7	.INCLUDE	☐				0	0	System Landscape History Data
8	SYDATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
9	SYUZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
10	SYUNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
11	TRCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
12	GENERATOR	☐	SMSY_FLAG	SMSY_FLAG	CHAR	10	0	System Landscape Capture Flag
13	AKT_VERSION	☐	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_DB_USAGE_2	SYSTEMNAME	SMSY_SYSTEM	SYSTEMNAME
2	SMSY_DB_USAGE_2	SYSTEMTYPE	SMSY_SYSTEMTYPE	SYSTEMTYPE

History

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