SAP ABAP Table SMSY_DB_USAGE (Database Use for Product 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	Table Relationship Diagram
Short Description	Database Use for Product 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	PRODUCT	☑	SMSYPRODUCT	SMSYPRODUCT	CHAR	20	0	PPMS Product	*
5	INSTANCE	☑	SMSYINSTANCE	SMSYINSTANCE	CHAR	20	0	Product Instance	*
6	DBNAME	☑	SMSY_DB_NAME	SYCHAR10	CHAR	10	0	Datenbase Name
7	DBSCHEMA	☑	SMSY_DB_SCHEMA	CHAR30	CHAR	30	0	Database Schema
8	.INCLUDE	☐				0	0	System Landscape History Data
9	SYDATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
10	SYUZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
11	SYUNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
12	TRCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
13	GENERATOR	☐	SMSY_FLAG	SMSY_FLAG	CHAR	10	0	System Landscape Capture Flag
14	AKT_VERSION	☐	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
15	REF_SYSTEM	☐	SMSY_NAME	SMSY_NAME	CHAR	8	0	Product System Name	*
16	REF_TYPE	☐	SMSY_SYSTYPE	SMSY_SYSTYPE	CHAR	10	0	Typing of Technical Systems	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_DB_USAGE	SYSTEMNAME	SMSY_SYSTEM	SYSTEMNAME

History

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