SAP ABAP Table SMSY_DB_USAGE_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SMSY_DB_USAGE_V	Table Relationship Diagram
Short Description	Generated Table for View

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	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	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
14	REF_SYSTEM	☐	SMSY_NAME	SMSY_NAME	CHAR	8	0	Product System Name	SMSY_SYSTEM
15	REF_TYPE	☐	SMSY_SYSTYPE	SMSY_SYSTYPE	CHAR	10	0	Typing of Technical Systems	SMSY_SYSTEMTYPE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_DB_USAGE_V	REF_SYSTEM	SMSY_SYSTEM	SYSTEMNAME
2	SMSY_DB_USAGE_V	REF_TYPE	SMSY_SYSTEMTYPE	SYSTEMTYPE
3	SMSY_DB_USAGE_V	SYSTEMNAME	SMSY_SYSTEM	SYSTEMNAME

History

Last changed by/on	SAP	20100705
SAP Release Created in