SAP ABAP Table SMSY_GRP_DATABAS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SMSY_GRP_DATABAS	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
2	LSYSTEMNAME	☑	SMSY_LNAME	SMSY_LNAME	CHAR	80	0	Long Product System Name
3	GROUPNAME	☑	SMSY_GROUPNAME	SMSY_GROUPNAME	CHAR	32	0	System Group Name
4	GROUP_TYPE	☑	SMSY_GRPTYPE	SMSY_GRPTYPE	CHAR	20	0	Group Type
5	MANDT	☑	SMSY_MANDT	SMSY_MANDT	CHAR	3	0	Client
6	ROLE	☑	SMSY_ROLE	SMSY_ROLE	CHAR	1	0	System Role	SMSY_ROLES
7	DBVENDOR	☑	SMSY_DB_VENDOR	SMSY_DB_VENDOR	CHAR	120	0	Database Manufacturer	SMSY_DB_SYS
8	DBRELEASE	☑	SMSY_DB_REL		CHAR	16	0	Database Release	SMSY_DB_SYS
9	DBHOSTNAME	☑	SMSY_HOSTNAME	SMSY_HOSTNAME	CHAR	20	0	Server Name
10	DBNAME	☑	SMSY_DB_NAME	SYCHAR10	CHAR	10	0	Datenbase Name
11	DBSCHEMA	☑	SMSY_DB_SCHEMA	CHAR30	CHAR	30	0	Database Schema
12	DBPRODUCT	☑	SMSYPRODUCT	SMSYPRODUCT	CHAR	20	0	PPMS Product
13	DBINSTANCE	☑	SMSYINSTANCE	SMSYINSTANCE	CHAR	20	0	Product Instance
14	ENTITY_KEY	☑	SMSY_ENTITY_GUID	CHAR32	CHAR	32	0	System Landscape Entity GUID
15	KONZS	☑	KONZS	KONZS	CHAR	10	0	Group key

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_GRP_DATABAS	DBRELEASE	SMSY_DB_SYS	DBVERSION		1	CN
2	SMSY_GRP_DATABAS	DBVENDOR	SMSY_DB_SYS	DBTYPE		1	CN
3	SMSY_GRP_DATABAS	ROLE	SMSY_ROLES	ROLE	KEY	C	CN

History

Last changed by/on	SAP	20100705
SAP Release Created in